- (Topic 3)
Which features make up Snowflake's column level security? (Select TWO).

1. A. Continuous Data Protection (CDP)
2. B. Dynamic Data Masking
3. C. External Tokenization
4. D. Key pair authentication
5. E. Row access policies

Correct Answer: BC
Snowflake??s column level security features include Dynamic Data Masking and External Tokenization. Dynamic Data Masking uses masking policies to selectively mask data at query time, while External Tokenization allows for the tokenization of data before loading it into Snowflake and detokenizing it at query runtime5.

- (Topic 2)
Which of the following features, associated with Continuous Data Protection (CDP), require additional Snowflake-provided data storage? (Choose two.)

1. A. Tri-Secret Secure
2. B. Time Travel
3. C. Fail-safe
4. D. Data encryption
5. E. External stages

Correct Answer: BC
The features associated with Continuous Data Protection (CDP) that require additional Snowflake-provided data storage are Time Travel and Fail-safe. Time Travel allows users to access historical data within a defined period, while Fail-safe provides an additional layer of data protection beyond the Time Travel period. References: [COF-C02] SnowPro Core Certification Exam Study Guide

- (Topic 1)
Where would a Snowflake user find information about query activity from 90 days ago?

1. A. account usage . query history view
2. B. account usage.query history archive View
3. C. information schema . cruery_history view
4. D. information schema - query history_by_ses s i on view

Correct Answer: B
To find information about query activity from 90 days ago, a Snowflake user should use the account_usage.query_history_archive view. This view is designed to provide access to historical query data beyond the default 14-day retention period found in the standard query_history view. It allows users to analyze and audit past query activities for up to 365 days after the date of execution, which includes the 90-day period mentioned. References:
✑ [COF-C02] SnowPro Core Certification Exam Study Guide
✑ Snowflake Documentation on Account Usage Schema1

- (Topic 3)
Which feature is integrated to support Multi-Factor Authentication (MFA) at Snowflake?

1. A. Authy
2. B. Duo Security
3. C. One Login
4. D. RSA SecurlD Access

Correct Answer: B
Snowflake integrates Duo Security to support Multi-Factor Authentication (MFA). This feature provides increased login security for users connecting to Snowflake, and it is managed completely by Snowflake without the need for users to sign up separately with Duo4.

- (Topic 1)
Which of the following are benefits of micro-partitioning? (Select TWO)

1. A. Micro-partitions cannot overlap in their range of values
2. B. Micro-partitions are immutable objects that support the use of Time Travel.
3. C. Micro-partitions can reduce the amount of I/O from object storage to virtual warehouses
4. D. Rows are automatically stored in sorted order within micro-partitions
5. E. Micro-partitions can be defined on a schema-by-schema basis

Correct Answer: BC
Micro-partitions in Snowflake are immutable objects, which means once they are written, they cannot be modified. This immutability supports the use of Time Travel, allowing users to access historical data within a defined period. Additionally, micro-partitions can significantly reduce the amount of I/O from object storage to virtual warehouses. This is because Snowflake??s query optimizer can skip over micro-partitions that do not contain relevant data for a query, thus reducing the amount of data that needs to be scanned and transferred.
References: [COF-C02] SnowPro Core Certification Exam Study Guide https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions.html