Snowflake SnowPro Core Actual Exam Questions Topic 1 - Single Topic Snowflake provides a mechanism for its customers to override its natural clustering algorithms. This method is: A. Micro-partitions B. Clustering keys C. Key partitions D. Clustered partitions Correct Answer: B 🗳️ Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.) Correct Answer: BD 🗳️ True or False: A single database can exist in more than one Snowflake account. Correct Answer: B 🗳️ Which of the following roles is recommended to be used to create and manage users and roles? B. SECURITYADMIN D. ACCOUNTADMIN Correct Answer: B 🗳️ True or False: Bulk unloading of data from Snowflake supports the use of a SELECT statement. Correct Answer: A 🗳️ Select the different types of Internal Stages: (Choose three.) D. Schema Stage Correct Answer: ABC 🗳️ True or False: A customer using SnowSQL / native connectors will be unable to also use the Snowflake Web Interface (UI) unless access to the UI is explicitly granted by support. Correct Answer: B 🗳️ Account-level storage usage can be monitored via: A. The Snowflake Web Interface (UI) in the Databases section B. The Snowflake Web Interface (UI) in the Account -> Billing & Usage section C. The Information Schema -> ACCOUNT_USAGE_HISTORY View

D. The Account Usage Schema -> ACCOUNT_USAGE_METRICS View Correct Answer: B 🗳️ Credit Consumption by the Compute Layer (Virtual Warehouses) is based on: (Choose two.) A. Number of users B. Warehouse size C. Amount of data processed D. # of clusters for the Warehouse Correct Answer: BD 🗳️ Which statement best describes `clustering`? A. Clustering represents the way data is grouped together and stored within Snowflake's micro-partitions B. The database administrator must define the clustering methodology for each Snowflake table C. The clustering key must be included on the COPY command when loading data into Snowflake D. Clustering can be disabled within a Snowflake account Correct Answer: A 🗳️ Loading discussion Want to Unlock Features That Will Help You Study for SnowPro Core? By buying Contributor Access for yourself, you will gain the following features: 1 Month 2.58 / day All Questions for 1 Exam Community Discussions No Captcha / Robot Checks Includes New Updates 3 Months 1.43 / day All Questions for 1 Exam Community Discussions No Captcha / Robot Checks Includes New Updates