Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 981:

  Which Snowflake feature is used for both querying and restoring data?

  A. Cluster keys

  B. Time Travel

  C. Fail-safe

  D. Cloning

  Correct Answer: B

  https://docs.snowflake.com/en/user-guide/data-availability.html#:~:text=Snowflake%20provides%20powerful%20CDP%20features,days%20through% 20Snowflake%20Time%20Travel.

• Question 982:

  What is a limitation of a Materialized View?

  A. A Materialized View cannot support any aggregate functions

  B. A Materialized View can only reference up to two tables

  C. A Materialized View cannot be joined with other tables

  D. A Materialized View cannot be defined with a JOIN

  Correct Answer: D

  There are several limitations to using materialized views:

  A materialized view can query only a single table.

  Joins, including self-joins, are not supported.

• Question 983:

  In the query profiler view for a query, which components represent areas that can be used to help optimize query performance? (Select TWO)

  A. Bytes scanned

  B. Bytes sent over the network

  C. Number of partitions scanned

  D. Percentage scanned from cache E. External bytes scanned

  Correct Answer: CD

• Question 984:

  True or False: Fail-safe can be disabled within a Snowflake account.

  A. True

  B. False

  Correct Answer: B

  Reference: https://docs.snowflake.com/en/user-guide/data-failsafe.html

  Separate and distinct from Time Travel, Fail-safe ensures historical data is protected in the event of a system failure or other catastrophic event, e.g. a hardware failure or security breach. Fail safe feature cannot be enabled or disabled from the user end .

• Question 985:

  What are two ways to create and manage Data Shares in Snowflake? (Choose two.)

  A. Via the Snowflake Web Interface (Ul)

  B. Via the data_share=true parameter

  C. Via SQL commands

  D. Via Virtual Warehouses

  Correct Answer: AC

  Reference: https://docs.snowflake.com/en/user-guide/data-sharing-provider.html

• Question 986:

  Which of the following describes how clustering keys work in Snowflake?

  A. Clustering keys update the micro-partitions in place with a full sort, and impact the DML operations.

  B. Clustering keys sort the designated columns over time, without blocking DML operations

  C. Clustering keys create a distributed, parallel data structure of pointers to a table's rows and columns

  D. Clustering keys establish a hashed key on each node of a virtual warehouse to optimize joins at run-time

  Correct Answer: B

• Question 987:

  True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.

  A. True

  B. False

  Correct Answer: A

• Question 988:

  Which Snowflake objects track DML changes made to tables, like inserts, updates, and deletes?

  A. Pipes

  B. Streams

  C. Tasks

  D. Procedures

  Correct Answer: B

  https://dataterrain.com/how-to-change-tracking-using-table-streams-in-snowflake/#:~:text=A%20stream%20is%20a%20Snowflake,as%20metadata%20about% 20each%20change.

• Question 989:

  Will data cached in a warehouse be lost when the warehouse is resized?

  A. Possibly, if the warehouse is resized to a smaller size and the cache no longer fits.

  B. Yes. because the compute resource is replaced in its entirety with a new compute resource.

  C. No. because the size of the cache is independent from the warehouse size

  D. Yes. became the new compute resource will no longer have access to the cache encryption key

  Correct Answer: A

• Question 990:

  Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).

  A. Internal stages

  B. Incremental backups

  C. Time Travel

  D. Zero-copy clones

  E. Fail-safe

  Correct Answer: CE

  Time travel and fail safe are the two continuous data protection features support the recovery of data automatically. Snowflake provides powerful CDP features for ensuring the maintenance and availability of your historical data (i.e. data that

  has been changed or deleted):

  Querying, cloning, and restoring historical data in tables, schemas, and databases for up to 90 days through Snowflake Time Travel. Disaster recovery of historical data (by Snowflake) through Snowflake Fail-safe.

  https://docs.snowflake.com/en/user-guide/data-availability.html