Snowflake COF-C02 Online Practice Questions and Exam Preparation

Snowflake COF-C02 Online Questions & Answers

• Question 981:

  Which Snowflake database object can be used to track data changes made to table data?

  A. Tag
  B. Task
  C. Stream
  D. Stored procedure
  C. Stream

  ---

  Explanation

• Question 982:

  What can a Snowflake user do with the information included in the details section of a Query Profile?

  A. Determine the total duration of the query.
  B. Determine the role of the user who ran the query.
  C. Determine the source system that the queried table is from.
  D. Determine if the query was on structured or semi-structured data.
  A. Determine the total duration of the query.

  ---

  Explanation

• Question 983:

  Which task is supported by the use of Access History in Snowflake?

  A. Data backups
  B. Cost monitoring
  C. Compliance auditing
  D. Performance optimization
  C. Compliance auditing

  ---

  Explanation

• Question 984:

  Which parameter prevents streams on tables from becoming stale?

  A. MAX_DATA_EXTENSION_TIME_IN_DAYS
  B. MIN_DATA_RETENSION_TIME_IN_DAYS
  C. LOCK_TIMEOUT
  D. STALE_AFTER
  A. MAX_DATA_EXTENSION_TIME_IN_DAYS

  ---

  Explanation

• Question 985:

  What unit is used to calculate the monthly cost for storing data in Snowflake?

  A. Gigabyte (GB)
  B. Megabyte (MB)
  C. Terabyte (TB)
  D. Petabyte (PB)
  C. Terabyte (TB)

  ---

  Explanation

  Snowflake bills data storage monthly in units of compressed terabytes (TB) . Usage below 1 TB is prorated.

  Snowflake Docs: Storage Costs

• Question 986:

  What is the purpose of a resource monitor in Snowflake?

  A. To monitor the query performance of virtual warehouses
  B. To create and suspend virtual warehouses automatically
  C. To manage cloud services needed for virtual warehouses
  D. To control costs and credit usage by virtual warehouses
  D. To control costs and credit usage by virtual warehouses

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/resource-monitors

• Question 987:

  Which command is used to determine the file name of each row of data from a staged file?

  A. SHOW FILE FORMATS
  B. SELECT METADATA$FILE_CONTENT_KEY
  C. SELECT METADATA$FILE_ROW_NUMBER
  D. SELECT METADATA$FILENAME
  D. SELECT METADATA$FILENAME

  ---

  Explanation

  https://docs.snowflake.com/en/user-guide/querying-metadata

• Question 988:

  Which governance feature is supported by all Snowflake editions?

  A. Object tags
  B. Masking policies
  C. Row access policies
  D. OBJECT_DEPENDENCIES view
  D. OBJECT_DEPENDENCIES view

  ---

  Explanation

• Question 989:

  What Snowflake object records Data Manipulation Language (DML) changes so that actions can be taken using the changed data?

  A. Pipe
  B. Stream
  C. Task
  D. View
  B. Stream

  ---

  Explanation

• Question 990:

  Which function converts a VARIANT 'null' value to a SQL NULL?

  A. CAST
  B. TO_CHAR
  C. TRY_CAST
  D. TO_BINARY
  A. CAST

  ---

  Explanation