Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 901:

  Which operator is used to evaluate query pruning efficiency by comparing partitions scanned to partitions total?

  A. IndexScan
  B. ExternalScan
  C. TableScan
  D. Filter
  C. TableScan

  ---

  Explanation

• Question 902:

  What is the MINIMUM configurable idle timeout value for a session policy in Snowflake?

  A. 2 minutes
  B. 5 minutes
  C. 10 minutes
  D. 15 minutes
  B. 5 minutes

  ---

  Explanation

• Question 903:

  Which file function gives a user or application access to download unstructured data from a Snowflake stage?

  A. BUILD_SCOPED_FILE_URL
  B. BUILD_STAGE_FILE_URL
  C. GET_PRESIGNED_URL
  D. GET_STAGE_LOCATION
  C. GET_PRESIGNED_URL

  ---

  Explanation

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

• Question 904:

  What can a Snowflake user do in the Admin area of Snow right?

  A. Analyze query performance.
  B. Write queries and execute them.
  C. Provide an overview of the listings in the Snowflake Marketplace.
  D. Connect to Snowflake partners to explore extended functionality.
  D. Connect to Snowflake partners to explore extended functionality.

  ---

  Explanation

• Question 905:

  What are characteristics of transient tables in Snowflake? (Choose two.)

  A. Transient tables have a Fail-safe period of 7 days.
  B. Transient tables can be cloned to permanent tables.
  C. Transient tables persist until they are explicitly dropped.
  D. Transient tables can be altered to make them permanent tables.
  E. Transient tables have Time Travel retention periods of 0 or 1 day.
  C. Transient tables persist until they are explicitly dropped.
  E. Transient tables have Time Travel retention periods of 0 or 1 day.

  ---

  Explanation

• Question 906:

  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
  C. Copy History
  D. Query History

  ---

  Explanation

• Question 907:

  It is possible to unload structured data to semi-structured formats such as JSON and parquet.

  A. True
  B. False
  A. True

  ---

  Explanation

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

• Question 908:

  Which Snowflake data governance feature supports the tracking of sensitive data for compliance, discovery, protection, and resource usage?

  A. Row access policies
  B. Data classification
  C. Object dependencies
  D. Object tagging
  D. Object tagging

  ---

  Explanation

• Question 909:

  Which Snowflake object does not consume any storage costs?

  A. Secure view
  B. Materialized view
  C. Temporary table
  D. Transient table
  A. Secure view

  ---

  Explanation

• Question 910:

  How does the Access_History view enhance overall data governance pertaining to read and write operations? (Choose two.)

  A. Shows how the accessed data was moved from the source to the target objects
  B. Provides a unified picture of what data was accessed and when it was accessed
  C. Protects sensitive data from unauthorized access while allowing authorized users to access it at query runtime
  D. Identifies columns with personal information and tags them so masking policies can be applied to protect sensitive data
  E. Determines whether a given row in a table can be accessed by the user by filtering the data based on a given policy
  B. Provides a unified picture of what data was accessed and when it was accessed
  E. Determines whether a given row in a table can be accessed by the user by filtering the data based on a given policy

  ---

  Explanation