Snowflake Snowflake Certifications COF-R02 Questions & Answers

• Question 51:

  Query parsing and compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?

  A. Cloud services layer

  B. Compute layer

  C. Storage layer

  D. Cloud agnostic layer

  Correct Answer: B

  Reference: https://www.projectpro.io/article/snowflake-architecture-what-does-snowflake-do/556

• Question 52:

  Which of the following is a data tokenization integration partner?

  A. Protegrity

  B. Tableau

  C. DBeaver

  D. SAP

  Correct Answer: A

• Question 53:

  The Snowflake cloud services layer is responsible for which tasks? (Choose two.)

  A. Local disk caching

  B. Authentication and access control

  C. Metadata management

  D. Query processing

  E. Database storage

  Correct Answer: CD

• Question 54:

  What is true about sharing data in Snowflake? (Choose two.)

  A. The Data Consumer pays for data storage as well as for data computing.

  B. The shared data is copied into the Data Consumer account, so the Consumer can modify it without impacting the base data of the Provider.

  C. A Snowflake account can both provide and consume shared data.

  D. The Provider is charged for compute resources used by the Data Consumer to query the shared data.

  E. The Data Consumer pays only for compute resources to query the shared data.

  Correct Answer: BC

• Question 55:

  True or False: Snowpipe via REST API can only reference External Stages as source.

  A. True

  B. False

  Correct Answer: B

  Reference: https://community.snowflake.com/s/article/Making-Transient-table-by-Default

• Question 56:

  Which command should be used to download files from a Snowflake stage to a local folder on a client's machine?

  A. PUT

  B. GET

  C. COPY

  D. SELECT

  Correct Answer: B

  Reference: https://docs.snowflake.com/en/sql-reference/sql/get.html

• Question 57:

  What are common issues found by using the Query Profile? (Choose two.)

  A. Identifying queries that will likely run very slowly before executing them

  B. Locating queries that consume a high amount of credits

  C. Identifying logical issues with the queries

  D. Identifying inefficient micro-partition pruning

  E. Data spilling to a local or remote disk

  Correct Answer: AD

• Question 58:

  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

  Correct Answer: CD

• Question 59:

  Snowflake supports the use of external stages with which cloud platforms? (Choose three.)

  A. Amazon Web Services

  B. Docker

  C. IBM Cloud

  D. Microsoft Azure Cloud

  E. Google Cloud Platform

  F. Oracle Cloud

  Correct Answer: BDE

• Question 60:

  A Snowflake Administrator needs to ensure that sensitive corporate data in Snowflake tables is not visible to end users, but is partially visible to functional managers.

  How can this requirement be met?

  A. Use data encryption.

  B. Use dynamic data masking.

  C. Use secure materialized views.

  D. Revoke all roles for functional managers and end users.

  Correct Answer: B