Snowflake COF-R02 Online Practice Questions and Exam Preparation

Snowflake COF-R02 Online Questions & Answers

• Question 51:

  What is the purpose of an External Function?

  A. To call code that executes outside of Snowflake
  B. To run a function in another Snowflake database
  C. To share data in Snowflake with external parties
  D. To ingest data from on-premises data sources
  A. To call code that executes outside of Snowflake

  ---

  Explanation/Reference:

  https://docs.snowflake.com/en/sql-reference/external-functions.html

• Question 52:

  What is the default file size when unloading data from Snowflake using the COPY command?

  A. 5 MB
  B. 8 GB
  C. 16 MB
  D. 32 MB
  C. 16 MB

• Question 53:

  What is an advantage of using an explain plan instead of the query profiler to evaluate the performance of a query?

  A. The explain plan output is available graphically.
  B. An explain plan can be used to conduct performance analysis without executing a query.
  C. An explain plan will handle queries with temporary tables and the query profiler will not.
  D. An explain plan's output will display automatic data skew optimization information.
  B. An explain plan can be used to conduct performance analysis without executing a query.

• Question 54:

  What is the minimum Snowflake edition required for row level security?

  A. Standard
  B. Enterprise
  C. Business Critical
  D. Virtual Private Snowflake
  B. Enterprise

• Question 55:

  Which of the following are considerations when using a directory table when working with unstructured data? (Choose two.)

  A. A directory table is a separate database object.
  B. Directory tables store data file metadata.
  C. A directory table will be automatically added to a stage.
  D. Directory tables do not have their own grantable privileges.
  E. Directory table data can not be refreshed manually.
  B. Directory tables store data file metadata.
  D. Directory tables do not have their own grantable privileges.

• Question 56:

  What happens to the shared objects for users in a consumer account from a share, once a database has been created in that account?

  A. The shared objects are transferred.
  B. The shared objects are copied.
  C. The shared objects become accessible.
  D. The shared objects can be re-shared.
  B. The shared objects are copied.

• Question 57:

  What Snowflake role must be granted for a user to create and manage accounts?

  A. ACCOUNTADMIN
  B. ORGADMIN
  C. SECURITYADMIN
  D. SYSADMIN
  A. ACCOUNTADMIN

  ---

  Explanation/Reference:

  https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html

• Question 58:

  A data provider wants to share data with a consumer who does not have a Snowflake account. The provider creates a reader account for the consumer following these steps:

  1.

  Created a user called "CONSUMER"

  2.

  Created a database to hold the share and an extra-small warehouse to query the data

  3.

  Granted the role PUBLIC the following privileges: Usage on the warehouse, database, and schema, and SELECT on all the objects in the share

  Based on this configuration what is true of the reader account?

  A. The reader account will automatically use the Standard edition of Snowflake.
  B. The reader account compute will be billed to the provider account.
  C. The reader account can clone data the provider has shared, but cannot re-share it.
  D. The reader account can create a copy of the shared data using CREATE TABLE AS...
  C. The reader account can clone data the provider has shared, but cannot re-share it.

• Question 59:

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

  A. True
  B. False
  B. False

  ---

  Explanation/Reference:

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

• Question 60:

  Which of the following are handled by the cloud services layer of the Snowflake architecture? (Choose two.)

  A. Query execution
  B. Data loading
  C. Time Travel data
  D. Security
  E. Authentication and access control
  B. Data loading
  D. Security