- (Topic 6)
How can a user MINIMIZE Continuous Data Protection costs when using large, high-churn, dimension tables?

1. A. Create transient tables and periodically copy them to permanent tables.
2. B. Create temporary tables and periodically copy them to permanent tables
3. C. Create regular tables with extended Time Travel and Fail-safe settings.
4. D. Create regular tables with default Time Travel and Fail-safe settings

Correct Answer: A
To minimize Continuous Data Protection (CDP) costs when dealing with large, high-churn dimension tables in Snowflake, using transient tables is a recommended approach.
✑ Transient Tables: These are designed for data that does not require fail-safe
protection. They provide the benefit of reducing costs associated with continuous data protection since they do not have the seven-day Fail-safe period that is mandatory for permanent tables.
✑ Periodic Copying to Permanent Tables: By periodically copying data from transient
tables to permanent tables, you can achieve a balance between data protection and cost-efficiency. Permanent tables offer the extended data protection features, including Time Travel and Fail-safe, but these features can be applied selectively rather than continuously, reducing the overall CDP costs.
References:
✑ Snowflake Documentation on Transient Tables
✑ Snowflake Documentation on Time Travel & Fail-safe

- (Topic 1)
What feature can be used to reorganize a very large table on one or more columns?

1. A. Micro-partitions
2. B. Clustering keys
3. C. Key partitions
4. D. Clustered partitions

Correct Answer: B
Clustering keys in Snowflake are used to reorganize large tables based on one or more columns. This feature optimizes the arrangement of data within micro- partitions to improve query performance, especially for large tables where efficient data retrieval is crucial. References: [COF-C02] SnowPro Core Certification Exam Study Guide https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html

- (Topic 2)
What is true about sharing data in Snowflake? (Choose two.)

1. A. The Data Consumer pays for data storage as well as for data computing.
2. B. The shared data is copied into the Data Consumer account, so the Consumer can modify it without impacting the base data of the Provider.
3. C. A Snowflake account can both provide and consume shared data.
4. D. The Provider is charged for compute resources used by the Data Consumer to query the shared data.
5. E. The Data Consumer pays only for compute resources to query the shared data.

Correct Answer: CE
In Snowflake??s data sharing model, any full Snowflake account can both provide and consume shared data. Additionally, the data consumer pays only for the compute resources used to query the shared data. No actual data is copied or transferred between accounts, and shared data does not take up any storage in a consumer account, so the consumer does not pay for data storage1.
References = Introduction to Secure Data Sharing | Snowflake Documentation

- (Topic 6)
What is the MINIMUM Snowflake edition that must be used in order to see the ACCESS_HISTORY view?

1. A. Standard
2. B. Enterprise
3. C. Business Critical
4. D. Virtual Private Snowflake (VPS)

Correct Answer: B
The ACCESS_HISTORY view in Snowflake provides detailed information about queries executed in the account, including metadata such as the time of execution, the user, and the SQL text of the queries. This view is available in the Snowflake Enterprise edition and higher editions. The Standard edition does not include this feature.
References:
✑ Snowflake Documentation: Access History
✑ Snowflake Editions: Snowflake Pricing

- (Topic 2)
Which of the following objects are contained within a schema? (Choose two.)

1. A. Role
2. B. Stream
3. C. Warehouse
4. D. External table
5. E. User
6. F. Share

Correct Answer: BD
In Snowflake, a schema is a logical grouping of database objects, which can include streams and external tables. A stream is an object that allows users to query data that has changed in specified tables or views, and an external table is a table that references data stored outside of Snowflake. Roles, warehouses, users, and shares are not contained within a schema. References: SHOW OBJECTS, Database, Schema, & Share DDL