Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 41:

  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

• Question 42:

  What Snowflake recommendation is designed to ensure that staged data is only loaded once?

  A. Partitioning staged data files

  B. Loading only the most recently-staged data files

  C. Removing data files after loading

  D. Identifying and removing duplicates after each data load

  Correct Answer: C

• Question 43:

  Which Snowflake function and command combination should be used to convert rows in a relational table to a single VARIANT column, and unload the rows into a file in JSON format? (Choose two.)

  A. PUT

  B. GET

  C. COPY

  D. EXPORT

  E. OBJECT_CONSTRUCT

  Correct Answer: CE

• Question 44:

  What is the MINIMUM Snowflake edition that supports database replication?

  A. Standard

  B. Enterprise

  C. Business Critical

  D. Virtual Private Snowflake (VPS)

  Correct Answer: C

  https://docs.snowflake.com/en/user-guide/db-replication-intro

• Question 45:

  Which Snowflake governance feature allows users to assign metadata labels to improve data governance and database access control?

  A. Secure functions

  B. Secure views

  C. Object tagging

  D. Row-level security

  Correct Answer: C

  https://docs.snowflake.com/en/user-guide/object-tagging

• Question 46:

  Which security models are used in Snowflake to manage access control? (Choose two.)

  A. Discretionary Access Control (DAC)

  B. Identity Access Management (IAM)

  C. Mandatory Access Control (MAC)

  D. Role-Based Access Control (RBAC)

  E. Security Assertion Markup Language (SAML)

  Correct Answer: AD

• Question 47:

  How can a 5 GB table be downloaded into a single file MOST efficiently?

  A. Keep the default MAX_FILE_SIZE to 16 MB.

  B. Set the default MAX_FILE_SIZE to 5 GB.

  C. Set the SINGLE parameter to TRUE.

  D. Use a regular expression in the stage specifications of the COPY command.

  Correct Answer: C

• Question 48:

  Why would a Snowflake user load JSON data into a VARIANT column instead of a string column?

  A. A VARIANT column is more secure than a string column.

  B. A VARIANT column compresses data and a string column does not.

  C. A VARIANT column can be used to create a data hierarchy and a string column cannot.

  D. A VARIANT column will have a better query performance than a string column.

  Correct Answer: C

• Question 49:

  Which Snowflake native tool can be used to diagnose and troubleshoot network connections?

  A. SnowSQL

  B. Snowflake Python connector

  C. Snowsight

  D. SnowCD

  Correct Answer: A

• Question 50:

  How can the Query Profile be used to troubleshoot a problematic query?

  A. It will indicate if a virtual warehouse memory is too small to run the query.

  B. It will indicate if a user lacks the privileges needed to run the query.

  C. It will indicate if a virtual warehouse is in auto-scale mode.

  D. It will indicate if the user has enough Snowflake credits to run the query.

  Correct Answer: A