Free COF-C02 Exam Dumps

Question 21

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

A. Load now data
B. Update existing data
C. Create a new snare
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

Question 22

- (Topic 4)
Which command is used to start configuring Snowflake for Single Sign-On (SSO)?

A. CREATE SESSION POLICY
B. CREATE NETWORK RULE
C. CREATE SECURITY INTEGRATION
D. CREATE PASSWORD POLICY

Correct Answer:C
To start configuring Snowflake for Single Sign-On (SSO), the CREATE SECURITY INTEGRATION command is used. This command sets up a security integration object in Snowflake, which is necessary for enabling SSO with external identity providers using SAML 2.01.
References: [COF-C02] SnowPro Core Certification Exam Study Guide

Question 23

- (Topic 6)
Which Snowflake data governance feature can support auditing when a user query reads column data?

A. Access History
B. Data classification
C. Column-level security
D. Object dependencies

Correct Answer:A
Access History in Snowflake is a feature designed to support auditing by tracking access to data within Snowflake, including when a user's query reads column data. It provides detailed information on queries executed, including the user who ran the query, the query text, and the objects (e.g., tables, views) accessed by the query. This feature is instrumental for auditing purposes, helping organizations to monitor and audit data access for security and compliance.
Reference: Snowflake Documentation on Access History which details its use for auditing
access to data: https://docs.snowflake.com/en/user-guide/access-history.html

Question 24

- (Topic 3)
A materialized view should be created when which of the following occurs? (Choose two.)

A. There is minimal cost associated with running the query.
B. The query consumes many compute resources every time it runs.
C. The base table gets updated frequently.
D. The query is highly optimized and does not consume many compute resources.
E. The results of the query do not change often and are used frequently.

Correct Answer:BE
A materialized view is beneficial when the query consumes many compute resources every time it runs (B), and when the results of the query do not change often and are used frequently (E). This is because materialized views store pre-computed data, which can speed up query performance for workloads that are run frequently or are complex

Question 25

- (Topic 6)
What kind of authentication do Snowpipe REST endpoints use?

A. OAuth
B. Key-based
C. Username and password
D. Single Sign-On (SSO)

Correct Answer:B
Snowpipe uses key-based authentication for its REST endpoints. This involves generating and using a key pair (public and private keys) to securely authenticate API requests.
✑ Generate Key Pair:Generate a public and private key pair.
✑ Register Public Key:Register the public key with the Snowflake user that will be making the API requests.
✑ Authenticate Requests:Use the private key to sign API requests sent to Snowpipe REST endpoints.
References:
✑ Snowflake Documentation: Key Pair Authentication & Key Rotation
✑ Snowflake Documentation: Using Snowpipe REST API