COF-C02 Snowflake Exam Questions and Free Practice Test

Question 97

- (Topic 4)
What objects in Snowflake are supported by Dynamic Data Masking? (Select TWO).'

A. Views

B. Materialized views

C. Tables

D. External tables

E. Future grants

Correct Answer:AC
Dynamic Data Masking in Snowflake supports tables and views. These objects can have masking policies applied to their columns to dynamically mask data at query time3.

Question 98

- (Topic 4)
What feature of Snowflake Continuous Data Protection can be used for maintenance of historical data?

A. Access control

B. Fail-safe

C. Network policies

D. Time Travel

Correct Answer:D
Snowflake??s Time Travel feature is used for the maintenance of historical data, allowing users to access and restore data that has been changed or deleted within a defined period4.

Question 99

- (Topic 1)
The fail-safe retention period is how many days?

A. 1 day

B. 7 days

C. 45 days

D. 90 days

Correct Answer:B
Fail-safe is a feature in Snowflake that provides an additional layer of data protection. After the Time Travel retention period ends, Fail-safe offers a non-configurable 7-day period during which historical data may be recoverable by Snowflake. This period is designed to protect against accidental data loss and is not intended for customer access. References: Understanding and viewing Fail-safe | Snowflake Documentation

Question 100

- (Topic 2)
What types of data listings are available in the Snowflake Data Marketplace? (Choose two.)

A. Reader

B. Consumer

C. Vendor

D. Standard

E. Personalized

Correct Answer:CE
In the Snowflake Data Marketplace, the types of data listings available include ??Vendor??, which refers to the providers of data, and ??Personalized??, which indicates customized data offerings tailored to specific consumer needs45.

Question 101

- (Topic 4)
What is the purpose of a Query Profile?

A. To profile how many times a particular query was executed and analyze its u^age statistics over time.

B. To profile a particular query to understand the mechanics of the query, its behavior, and performance.

C. To profile the user and/or executing role of a query and all privileges and policies applied on the objects within the query.

D. To profile which queries are running in each warehouse and identify proper warehouse utilization and sizing for better performance and cost balancing.

Correct Answer:B
The purpose of a Query Profile is to provide a detailed analysis of a particular query??s execution plan, including the mechanics, behavior, and performance. It helps in identifying potential performance bottlenecks and areas for optimization

Question 102

- (Topic 6)
Which table function is used to perform additional processing on the results of a previously- run query?

A. QUERY_HISTORY

B. RESULT_SCAN

C. DESCRIBE_RESULTS

D. QUERY HISTORY BY SESSION

Correct Answer:B
TheRESULT_SCANtable function is used in Snowflake to perform additional processing on the results of a previously-run query. It allows users to reference the result set of a previous query by its query ID, enabling further analysis or transformations without re-executing the original query.
References:
✑ Snowflake Documentation: RESULT_SCAN

START COF-C02 EXAM