COF-C02 Snowflake Exam Questions and Free Practice Test

Question 121

- (Topic 6)
A Snowflake user wants to optimize performance for a query that queries only a small number of rows in a table. The rows require significant processing. The data in the table does not change frequently.
What should the user do?

A. Add a clustering key to the table.

B. Add the search optimization service to the table.

C. Create a materialized view based on the query.

D. Enable the query acceleration service for the virtual warehouse.

Correct Answer:C
In a scenario where a Snowflake user queries only a small number of rows that require significant processing and the data in the table does not change frequently, the most effective way to optimize performance is by creating a materialized view based on the query. Materialized views store the result of the query and can significantly reduce the computation time for queries that are executed frequently over unchanged data.
✑ Why Materialized Views:Materialized views precompute and store the result of the query. This is especially beneficial for queries that require heavy processing. Since the data does not change frequently, the materialized view will not need to be refreshed often, making it an ideal solution for this use case.
✑ Implementation Steps:
CREATEMATERIALIZEDVIEWmy_materialized_viewASSELECT...FROMmy_tableWHER E...;
✑ uk.co.certification.simulator.questionpool.PList@6dd07e9a
Reference:For more information on materialized views and how they can be used to optimize query performance, refer to the Snowflake documentation on materialized views: https://docs.snowflake.com/en/user-guide/views-materialized.html

Question 122

- (Topic 3)
How does Snowflake allow a data provider with an Azure account in central Canada to share data with a data consumer on AWS in Australia?

A. The data provider in Azure Central Canada can create a direct share to AWS Asia Pacific, if they are both in the same organization.

B. The data consumer and data provider can form a Data Exchange within the same organization to create a share from Azure Central Canada to AWS Asia Pacific.

C. The data provider uses the GET DATA workflow in the Snowflake Data Marketplace to create a share between Azure Central Canada and AWS Asia Pacific.

D. The data provider must replicate the database to a secondary account in AWS Asia Pacific within the same organization then create a share to the data consumer's account.

Correct Answer:D
Snowflake allows data providers to share data with consumers across different cloud platforms and regions through database replication. The data provider must replicate the database to a secondary account in the target region or cloud platform within the same organization, and then create a share to the data consumer??s account. This process ensures that the data is available in the consumer??sregion and on their cloud platform, facilitating seamless data sharing. References: Sharing data securely across regions and cloud platforms | Snowflake Documentation

Question 123

- (Topic 6)
Which privilege grants the ability to set a column-level security masking policy on a table or view column?

A. APPLY

B. CREATE

C. SET

D. MODIFY

Correct Answer:A
In Snowflake, theAPPLYprivilege is required to set a masking policy on a table or view column. This privilege allows a user to associate a masking policy with a specific column, thereby controlling how data in that column is masked or hidden.
✑ Create a Masking Policy:Define a masking policy using theCREATE MASKING
POLICYcommand.
✑ Grant APPLY Privilege:Grant theAPPLYprivilege on the masking policy to the relevant roles or users.
✑ Apply the Masking Policy:Use theALTER TABLEorALTER VIEWcommand to apply
the masking policy to a column.
References:
✑ Snowflake Documentation: Data Masking
✑ Snowflake Documentation: CREATE MASKING POLICY
✑ Snowflake Documentation: Privileges for Masking Policies

Question 124

- (Topic 4)
Who can grant object privileges in a regular schema?

A. Object owner

B. Schema owner

C. Database owner

D. SYSADMIN

Correct Answer:A
In a regular schema within Snowflake, the object owner has the privilege to grant object privileges. The object owner is typically the role that created the object or to whom the ownership of the object has been transferred78.
References = [COF-C02] SnowPro Core Certification Exam Study Guide

Question 125

- (Topic 6)
Which statistics on a Query Profile reflect the efficiency of the query pruning? (Select TWO).

A. Partitions scanned

B. Partitions total

C. Bytes spilled

D. Bytes scanned

E. Bytes written

Correct Answer:AD
In a Snowflake Query Profile, the statistics "Partitions scanned" and "Bytes scanned" reflect the efficiency of query pruning. Query pruning refers to the ability of the query engine to skip unnecessary data, thereby reducing the amount of data that needs to be processed. Efficient pruning results in fewer partitions and bytes being scanned, improving query performance.
References:
✑ Snowflake Documentation: Understanding Query Profiles Top of Form Bottom of Form

Question 126

- (Topic 2)
How many days is load history for Snowpipe retained?

A. 1 day

B. 7 days

C. 14 days

D. 64 days

Correct Answer:C
Snowpipe retains load history for 14 days. This allows users to view and audit the data that has been loaded into Snowflake using Snowpipe within this time frame3.

START COF-C02 EXAM