- (Topic 4)
Which Snowflake view is used to support compliance auditing?

1. A. ACCESS_HISTORY
2. B. COPY_HISTORY
3. C. QUERY_HISTORY
4. D. ROW ACCESS POLICIES

Correct Answer: A
The ACCESS_HISTORY view in Snowflake is utilized to support compliance auditing. It provides detailed information on data access within Snowflake, including reads and writes by user queries. This view is essential for regulatory compliance auditing as it offers insights into the usage of tables and columns, and maintains a direct link between the user, the query, and the accessed data1.
References: [COF-C02] SnowPro Core Certification Exam Study Guide

- (Topic 6)
While running a query on a virtual warehouse in auto-scale mode, additional clusters are stated immediately if which setting is configured?
A)
MISSING
B)

C)

D)

1. A. Option A
2. B. Option B
3. C. Option C
4. D. Option D

Correct Answer: A
In Snowflake, auto-scaling allows virtual warehouses to automatically start additional clusters to handle increasing query loads. The setting that triggers the immediate startof additional clusters when a warehouse is running in auto-scale mode is:A. MAX_CLUSTER_COUNT is increased and new_max_clusters is greater than running_clusters: When the maximum number of clusters (MAX_CLUSTER_COUNT) is increased and the new maximum is higher than the number of clusters currently running (running_clusters), additional clusters will start immediately if required by the workload. This configuration ensures that performance scales with demand by allowing more compute resources to be provisioned as needed.
This behavior is designed to maintain performance by dynamically adjusting the compute resources without manual intervention, ensuring that queries are executed with minimal delay, even under varying workloads. It aligns with the principles of elasticity and scalability in cloud computing, particularly within Snowflake's architecture.

- (Topic 4)
Which views are included in the DATA SHARING USAGE schema? (Select TWO).

1. A. ACCESS_HISTORY
2. B. DATA_TRANSFER_HISTORY
3. C. WAREHOUSE_METERING_HISTORY
4. D. MONETIZED_USAGE_DAILY
5. E. LISTING TELEMETRY DAILY

Correct Answer: DE
The DATA_SHARING_USAGE schema includes views that display information about listings published in the Snowflake Marketplace or a data exchange, which includes DATA_TRANSFER_HISTORY and LISTING_TELEMETRY_DAILY2.

- (Topic 5)
Regardless of which notation is used, what are considerations for writing the column name and element names when traversing semi-structured data?

1. A. The column name and element names are both case-sensitive.
2. B. The column name and element names are both case-insensitive.
3. C. The column name is case-sensitive but element names are case-insensitive.
4. D. The column name is case-insensitive but element names are case-sensitive.

Correct Answer: D
When querying semi-structured data in Snowflake, the behavior towards case sensitivity is distinct between column names and the names of elements within the semi-structured data. Column names follow the general SQL norm of being case- insensitive, meaning you can reference them in any case without affecting the query. However, element names within JSON, XML, or other semi-structured data are case- sensitive. This distinction is crucial for accurate data retrieval and manipulation in Snowflake, especially when working with JSON objects where the case of keys can significantly alter the outcome of queries.
References:
✑ Snowflake Documentation: Querying Semi-structured Data

- (Topic 4)
A Snowflake account has activated federated authentication.
What will occur when a user with a password that was defined by Snowflake attempts to log in to Snowflake?

1. A. The user will be unable to enter a password.
2. B. The user will encounter an error, and will not be able to log in.
3. C. The user will be able to log into Snowflake successfully.
4. D. After entering the username and password, the user will be redirected to an Identity Provider (IdP) login page.

Correct Answer: A
When federated authentication is activated in Snowflake, users authenticate via an external identity provider (IdP) rather than using Snowflake-managed credentials. Therefore, a user with a password defined by Snowflake will be unable to enter a password and must use their IdP credentials to log in.