Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 1111:

  True or False: Snowflake allows its customers to directly access the micro-partition files that make up its tables.

  A. True

  B. False

  Correct Answer: B

• Question 1112:

  Data storage for individual tables can be monitored using which commands and/or object(s)? Choose 2 answers

  A. SHOW TABLES;

  B. SHOW STORAGE BY TABLE;

  C. Information Schema-> TABLE_STORAGE_METRICS

  D. Information Schema-> TASLE_HISTORY

  Correct Answer: AC

• Question 1113:

  Which of the following are common use cases for zero-copy cloning? Choose 3 answers

  A. Quick provisioning of Dev and Test/QA environments

  B. Data backups

  C. Point in time snapshots

  D. Performance optimization

  Correct Answer: ABC

  Reference: https://community.snowflake.com/s/question/0D50Z00009C3VlMSAV/zero-copy-cloning

• Question 1114:

  Which of the following are true of multi-cluster Warehouses? Select all that apply below.

  A. A multi-cluster Warehouse can add clusters automatically based on query activity

  B. A multi-cluster Warehouse can automatically turn itself off after a period of inactivity

  C. A multi-cluster Warehouse can scale down when query activity slows

  D. A multi-cluster Warehouse can automatically turn itself on when a query is executed against it

  Correct Answer: ABCD

• Question 1115:

  True or False: Data in Fail-safe can be deleted by a user or the Snowflake team before it expires.

  A. True

  B. False

  Correct Answer: B

  Reference: https://blog.knoldus.com/ksnow-time-travel-and-fail-safe-in-snowflake/

• Question 1116:

  Which of the following statements is true of zero-copy cloning?

  A. Zero-copy clones objects inherit

  B. All zero-copy clone objects inherit the privileges of their original objects

  C. Zero-copy coning is licensed as an additional Snowflake feature

  D. At the instance/instance a clone is created, all micro-partitions in the original table and the clone are fully shared.

  Correct Answer: D

  Reference: https://community.snowflake.com/s/question/0D50Z00009D8VOd/zero-copy-cloning-base-data

• Question 1117:

  True or False: Data Providers can share data with only the Data Consumer.

  A. True

  B. False

  Correct Answer: B

• Question 1118:

  A role is created and owns 2 tables. This role is then dropped. Who will now own the two tables?

  A. The tables are now orphaned

  B. The user that deleted the role

  C. SYSADMIN

  D. The assumed role that dropped the role

  Correct Answer: D

  Reference: https://docs.snowflake.com/en/sql-reference/sql/drop-role.html

• Question 1119:

  which of the following are valid approaches to loading data into a snowflake table? select all the below that apply.

  A. Bulk copy from an External Stage

  B. Continuous load using Snowpipe REST API

  C. The Snowflake Web Interface (UT) data loading wizard

  D. Bulk copy from an Internal Stage

  Correct Answer: ABCD

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

• Question 1120:

  What is the maximum compressed row size in Snowflake?

  A. 8KB

  B. 16MB

  C. 50MB

  D. 4000GB

  Correct Answer: B

  MAX size for compressed data for semi-structured data type is also 16 MB. That means if our table has a semi-structured data type column with 16MB data other columns will have NULL data.