- (Topic 6)
Which key access control concept does Snowflake descibe as a defined level of access to an object?

1. A. Grant
2. B. Privilege
3. C. Role
4. D. Session

Correct Answer: B
In Snowflake, the term "privilege" refers to a defined level of access to an object. Privileges are specific actions that roles can perform on securable objects in Snowflake, such as tables, views, warehouses, databases, and schemas. These privileges are granted to roles and can be further granted to users through their roles, forming the basis of Snowflake??s access control framework.References:Snowflake Documentation on Access Control Privileges

- (Topic 2)
What is the purpose of multi-cluster virtual warehouses?

1. A. To create separate data warehouses to increase query optimization
2. B. To allow users the ability to choose the type of compute nodes that make up a virtual warehouse cluster
3. C. To eliminate or reduce Queuing of concurrent queries
4. D. To allow the warehouse to resize automatically

Correct Answer: C
Multi-cluster virtual warehouses in Snowflake are designed to manage user and query concurrency needs. They allow for the allocation of additional clusters of compute resources, either statically or dynamically, to handle increased loads and reduce or eliminate the queuing of concurrent queries2.
https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html#:~:text=Multi%2Dcluster%20warehouses%20enable%20you,during%20p eak%20and%20off%20hours.

- (Topic 1)
Will data cached in a warehouse be lost when the warehouse is resized?

1. A. Possibly, if the warehouse is resized to a smaller size and the cache no longer fits.
2. B. Ye
3. C. because the compute resource is replaced in its entirety with a new compute resource.
4. D. N
5. E. because the size of the cache is independent from the warehouse size
6. F. Ye
7. G. became the new compute resource will no longer have access to the cache encryption key

Correct Answer: C
When a Snowflake virtual warehouse is resized, the data cached in the warehouse is not lost. This is because the cache is maintained independently of the warehouse size. Resizing a warehouse, whether scaling up or down, does not affect the cached data, ensuring that query performance is not impacted by such changes. References:
✑ [COF-C02] SnowPro Core Certification Exam Study Guide
✑ Snowflake Documentation on Virtual Warehouse Performance1

- (Topic 5)
What are characteristic of Snowsight worksheet? (Select TWO.)

1. A. Worksheets can be grouped under folder, and a folder of folders.
2. B. Each worksheet is a unique Snowflake session.
3. C. Users are limited to running only one on a worksheet.
4. D. The Snowflake session ends when a user switches worksheets.
5. E. Users can import worksheets and share them with other users.

Correct Answer: AE
Characteristics of Snowsight worksheets in Snowflake include:
✑ A. Worksheets can be grouped under folders, and a folder of folders: This organizational feature allows users to efficiently manage and categorize their worksheets within Snowsight, Snowflake's web-based UI, enhancing the user experience by keeping related worksheets together.
✑ E. Users can import worksheets and share them with other users: Snowsight supports the sharing of worksheets among users, fostering collaboration by allowing users to share queries, analyses, and findings. This feature is crucial for collaborative data exploration and analysis workflows.
References:
✑ Snowflake Documentation: Snowsight (UI for Snowflake)

- (Topic 6)
What can a user win a reader account do in Snowflake?

1. A. Load now data
2. B. Update existing data
3. C. Create a new snare
4. D. Query shared data

Correct Answer: D
In Snowflake, a user within a reader account primarily has read-only access to the shared data. Reader accounts are created to enable third parties or separate business units to access and query data shared with them without allowing them to modify the underlying data. This means a user with a reader account can perform operations like querying shared data to analyze or report on it but cannot load new data, update existing data, or create new shares. This setup is crucial for maintaining data governance and security while enabling data sharing and collaboration.References:Snowflake Documentation on Reader Accounts