Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 1641:

  Which of the following describes the Snowflake Cloud Services layer?

  A. Coordinates activities in the Snowflake account
  B. Executes queries submitted by the Snowflake account users
  C. Manages quotas on the Snowflake account storage
  D. Manages the virtual warehouse cache to speed up queries
  A. Coordinates activities in the Snowflake account

  ---

  Explanation

• Question 1642:

  Which Snowflake data governance feature supports resource usage monitoring?

  A. Data classification
  B. Column lineage
  C. Access history
  D. Object tagging
  D. Object tagging

  ---

  Explanation

• Question 1643:

  Which URL identifies the database, schema, stage, and tile path to a set of files for accessing the unstructured data files in Snowflake?

  A. Scoped URL
  B. File URL
  C. Pre-signed URL
  D. HTTPS URL
  D. HTTPS URL

  ---

  Explanation

  When accessing unstructured data files in Snowflake, the HTTPS URL identifies the database, schema, stage, and file path.

  Example:

  https://.snowflakecomputing.com////

  References:

  Snowflake Documentation: Managing Unstructured Data

• Question 1644:

  Which function is used to convert rows in a relational table to a single VARIANT column?

  A. ARRAY_AGG
  B. OBJECT_AGG
  C. ARRAY_CONSTRUCT
  D. OBJECT_CONSTRUCT
  D. OBJECT_CONSTRUCT

  ---

  Explanation

• Question 1645:

  A user with which privileges can create or manage other users in a Snowflake account? (Choose two.)

  A. GRANT
  B. SELECT
  C. MODIFY
  D. OWNERSHIP
  E. CREATE USER
  D. OWNERSHIP
  E. CREATE USER

  ---

  Explanation

• Question 1646:

  What commands can be used to see what files are stored in a stage? (Choose two.)

  A. LIST
  B. SELECT
  C. LS
  D. GET
  E. DESCRIBE
  A. LIST
  C. LS

  ---

  Explanation

• Question 1647:

  What is the default period of time the Warehouse Activity section provides a graph of Snowsight activity?

  A. 2 hours
  B. 1 week
  C. 2 weeks
  D. 1 month
  C. 2 weeks

  ---

  Explanation

• Question 1648:

  The effects of query pruning can be observed by evaluating which statistics? (Choose two.)

  A. Partitions scanned
  B. Partitions total
  C. Bytes scanned
  D. Bytes read from result
  E. Bytes written
  A. Partitions scanned
  B. Partitions total

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/ui-query-profile

• Question 1649:

  Which of the following items does the Cloud services Layer manage? (Choose four)

  A. user authentication
  B. Metadata
  C. Query compilation and optimization
  D. external blob storage
  E. Data security
  A. user authentication
  B. Metadata
  C. Query compilation and optimization
  E. Data security

  ---

  Explanation

• Question 1650:

  Which feature allows a user the ability to control the organization of data in a micro-partition?

  A. Range Partitioning
  B. Search Optimization Service
  C. Automatic Clustering
  D. Horizontal Partitioning
  C. Automatic Clustering

  ---

  Explanation