Snowflake COF-R02 Online Practice Questions and Exam Preparation

Snowflake COF-R02 Online Questions & Answers

• Question 231:

  True or False: Pipes can be suspended and resumed.

  A. True
  B. False
  A. True

  ---

  Explanation/Reference:

  https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html#pausing-or-resuming-pipes Pausing or Resuming Pipes In addition to the pipe owner, a role that has the following minimum permissions can pause or resume the pipe

• Question 232:

  How long is Snowpipe data load history retained?

  A. As configured in the create pipe settings
  B. Until the pipe is dropped
  C. 64 days
  D. 14 days
  C. 64 days

  ---

  Explanation/Reference:

  Bulk data load

  Stored in the metadata of the target table for 64 days. Available upon completion of the COPY statement as the statement output. https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html#:~:text=Load%20History,-Bulk%

  20data%20loadandtext=Stored%20in%20the%20metadata%20of,statement%20as%20the%20statement%20output.andtext=Stored%20in% 20the%20metadata%20of%20the%20pipe%20for%2014%20days.

• Question 233:

  Where can a user find and review the failed logins of a specific user for the past 30 days?

  A. The USERS view in ACCOUNT_USAGE
  B. The LOGIN_HISTORY view in ACCOUNT_USAGE
  C. The ACCESS_HISTORY view in ACCOUNT_USAGE
  D. The SESSIONS view in ACCOUNT_USAGE
  B. The LOGIN_HISTORY view in ACCOUNT_USAGE

• Question 234:

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

  A. True
  B. False
  A. True

  ---

  Explanation/Reference:

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

• Question 235:

  How can a user change which columns are referenced in a view?

  A. Modify the columns in the underlying table
  B. Use the ALTER VIEW command to update the view
  C. Recreate the view with the required changes
  D. Materialize the view to perform the changes
  B. Use the ALTER VIEW command to update the view

• Question 236:

  True or False: A Snowflake account is charged for data stored in both Internal and External Stages.

  A. True
  B. False
  A. True

  ---

  Explanation/Reference:

  Reference: https://docs.snowflake.com/en/user-guide/tables-storage-considerations.html

• Question 237:

  What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?

  A. Data is hashed by the cluster key to facilitate fast searches for common data values
  B. Larger micro-partitions are created for common data values to reduce the number of partitions that must be scanned
  C. Smaller micro-partitions are created for common data values to allow for more parallelism
  D. Data may be colocated by the cluster key within the micro-partitions to improve pruning performance
  D. Data may be colocated by the cluster key within the micro-partitions to improve pruning performance

• Question 238:

  True or False: Snowflake's Global Services Layer gathers and maintains statistics on all columns in all micro-partitions.

  A. True
  B. False
  A. True

  ---

  Explanation/Reference:

  Snowflake is a single, integrated platform delivered as-a-service. It features storage, compute, and global services layers that are physically separated but logically integrated.

• Question 239:

  What features that are part of the Continuous Data Protection (CDP) feature set in Snowflake do not require additional configuration? (Choose two.)

  A. Row level access policies
  B. Data masking policies
  C. Data encryption
  D. Time Travel
  E. External tokenization
  C. Data encryption
  D. Time Travel

• Question 240:

  Which of the following activities consume virtual warehouse credits in the Snowflake environment? (Choose two.)

  A. Caching query results
  B. Running EXPLAIN and SHOW commands
  C. Cloning a database
  D. Running a custom query
  E. Running COPY commands
  A. Caching query results
  D. Running a custom query