- (Topic 3)
Which features could be used to improve the performance of queries that return a small subset of rows from a large table? (Select TWO).

1. A. Search optimization service
2. B. Automatic clustering
3. C. Row access policies
4. D. Multi-cluster virtual warehouses
5. E. Secure views

Correct Answer: AB
The search optimization service and automatic clustering are features that can improve the performance of queries returning a small subset of rows from a large table. The search optimization service is designed for low-latency point lookup queries, while automatic clustering organizes data in micro-partitions based on specific dimensions to reduce the amount of data scanned during queries.

- (Topic 6)
What is the PRIMARY factor that determines the cost of using a virtual warehouse in Snowflake?

1. A. The type of SQL statements executed
2. B. The number of tables or databases queried
3. C. The amount of data stored in the warehouse
4. D. The length of time the compute resources in each cluster run

Correct Answer: D
The primary factor that determines the cost of using a virtual warehouse in Snowflake isD. The length of time the compute resources in each cluster run. Snowflake's pricing model for compute usage is based on the concept of Snowflake credits, which are consumed based on the time virtual warehouses are running and the size of the warehouses. The more compute resources are utilized and the longer they run, the more credits are consumed, which directly impacts the cost.
References:
✑ Snowflake Documentation on Virtual Warehouses: Understanding and Managing Warehouse Credit Usage

- (Topic 4)
What does a Notify & Suspend action for a resource monitor do?

1. A. Send an alert notification to all account users who have notifications enabled.
2. B. Send an alert notification to all virtual warehouse users when thresholds over 100% have been met.
3. C. Send a notification to all account administrators who have notifications enabled, and suspend all assigned warehouses after all statements being executed by the warehouses have completed.
4. D. Send a notification to all account administrators who have notifications enabled, and suspend all assigned warehouses immediately, canceling any statements being executed by the warehouses.

Correct Answer: C
The Notify & Suspend action for a resource monitor in Snowflake sends a notification to all account administrators who have notifications enabled and suspends all assigned warehouses. However, the suspension only occurs after all currently running statements in the warehouses have been completed1. References: [COF-C02] SnowPro Core Certification Exam Study Guide

- (Topic 5)
Which SQL command can be used to verify the privileges that are granted to a role?

1. A. SHOW GRANTS ON ROLE <Role Name>
2. B. SHOW ROLES <Role Name>
3. C. SHOW GRANTS TO ROLE <Role Name>
4. D. SHOW GRANTS FOR ROLE <Role Name>

Correct Answer: C
To verify the privileges that have been granted to a specific role in Snowflake, the correct SQL command isSHOW GRANTS TO ROLE <Role Name>. This command lists all the privileges granted to the specified role, including access to schemas, tables, and other database objects. This is a useful command for administrators and users withsufficient privileges to audit and manage role permissions within the Snowflake environment.
References:
✑ Snowflake Documentation: SHOW GRANTS

- (Topic 6)
What are the main differences between the account usage views and the information schema views? (Select TWO).

1. A. No active warehouse to needed to query account usage views but one is needed to query information schema views.
2. B. Account usage views do not contain data about tables but information schema views do.
3. C. Account issue views contain dropped objects but information schema views do not.
4. D. Data retention for account usage views is 1 year but is 7 days to 6 months forinformation schema views, depending on the view.
5. E. Information schema views are read-only but account usage views are not.

Correct Answer: CD
The account usage views in Snowflake provide historical usage data about the Snowflake account, and they retain this data for a period of up to 1 year. These views include information about dropped objects, enabling audit and tracking activities. On the other hand, information schema views provide metadata about database objects currently in use, such as tables and views, but do not include dropped objects. The retention of data in information schema views varies, but it is generally shorter than the retention for account usage views, ranging from 7 daysto a maximum of 6 months, depending on the specific view.References:Snowflake Documentation on Account Usage and Information Schema