Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 521:

  What type of columns does Snowflake recommend to be used as clustering keys? (Choose two.)

  A. A VARIANT column

  B. A column with very low cardinality

  C. A column with very high cardinality

  D. A column that is most actively used in selective filters

  E. A column that is most actively used in join predicates

  Correct Answer: DE

• Question 522:

  Which objects together comprise a namespace in Snowflake? (Choose two.)

  A. Account

  B. Database

  C. Schema

  D. Table

  E. Virtual warehouse

  Correct Answer: BC

• Question 523:

  What statistical information in a Query Profile indicates that the query is too large to fit in memory? (Choose two.)

  A. Bytes spilled to local cache.

  B. Bytes spilled to local storage.

  C. Bytes spilled to remote cache.

  D. Bytes spilled to remote storage.

  E. Bytes spilled to remote metastore.

  Correct Answer: BD

• Question 524:

  Which pages are included in the Activity area of Snowsight? (Choose two.)

  A. Contacts

  B. Sharing settings

  C. Copy History

  D. Query History

  E. Automatic Clustering History

  Correct Answer: CD

• Question 525:

  When should a user consider disabling auto-suspend for a virtual warehouse? (Choose two.)

  A. When users will be using compute at different times throughout a 24/7 period

  B. When managing a steady workload

  C. When the compute must be available with no delay or lag time

  D. When the user does not want to have to manually turn on the warehouse each time it is needed

  E. When the warehouse is shared across different teams

  Correct Answer: BC

• Question 526:

  What can a Snowflake user do in the Activity section in Snowsight?

  A. Create dashboards.

  B. Write and run SQL queries.

  C. Explore databases and objects.

  D. Explore executed query performance.

  Correct Answer: D

• Question 527:

  How does Snowflake reorganize data when it is loaded? (Choose two.)

  A. Binary format

  B. Columnar format

  C. Compressed format

  D. Raw format

  E. Zipped format

  Correct Answer: BC

• Question 528:

  Which operations are handled in the Cloud Services layer of Snowflake? (Choose two.)

  A. Security

  B. Data storage

  C. Data visualization

  D. Query computation

  E. Metadata management

  Correct Answer: AE

• Question 529:

  Which data types can be used in a Snowflake table that holds semi-structured data? (Choose two.)

  A. ARRAY

  B. BINARY

  C. TEXT

  D. VARIANT

  E. VARCHAR

  Correct Answer: AD

• Question 530:

  Which constraint is enforced in Snowflake?

  A. FOREIGN KEY

  B. NOT NULL

  C. PRIMARY KEY

  D. UNIQUE KEY

  Correct Answer: B