Snowflake COF-R02 Online Practice Questions and Exam Preparation

Snowflake COF-R02 Online Questions & Answers

• Question 211:

  In which use cases does Snowflake apply egress charges?

  A. Data sharing within a specific region
  B. Query result retrieval
  C. Database replication
  D. Loading data into Snowflake
  A. Data sharing within a specific region

  ---

  Explanation/Reference:

  Cloud providers apply data egress charges in either of the following use cases: Data is transferred from one region to another within the same cloud platform. Data is transferred out of the cloud platform.

  https://docs.snowflake.com/en/user-guide/billing-data-transfer.html#:~:text=Cloud%20providers%20apply%20data%20egress,out%20of%20the%20cloud%20platform.

• Question 212:

  What transformations are supported in a CREATE PIPE ... AS COPY ... FROM (....) statement? (Select TWO.)

  A. Data can be filtered by an optional where clause
  B. Incoming data can be joined with other tables
  C. Columns can be reordered
  D. Columns can be omitted
  E. Row level access can be defined
  C. Columns can be reordered
  D. Columns can be omitted

• Question 213:

  What SQL command would be used to view all roles that were granted to user.1?

  A. show grants to user USER1;
  B. show grants of user USER1;
  C. describe user USER1;
  D. show grants on user USER1;
  A. show grants to user USER1;

• Question 214:

  The fail-safe retention period is how many days?

  A. 1 day
  B. 7 days
  C. 45 days
  D. 90 days
  B. 7 days

  ---

  Explanation/Reference:

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

• Question 215:

  What feature can be used to reorganize a very large table on one or more columns?

  A. Micro-partitions
  B. Clustering keys
  C. Key partitions
  D. Clustered partitions
  B. Clustering keys

  ---

  Explanation/Reference:

  https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html

• Question 216:

  Which of the following describes a Snowflake stored procedure?

  A. They can be created as secure and hide the underlying metadata from the user.
  B. They can only access tables from a single database.
  C. They can contain only a single SQL statement.
  D. They can be created to run with a caller's rights or an owner's rights.
  A. They can be created as secure and hide the underlying metadata from the user.

  ---

  Explanation/Reference:

  Reference: https://docs.snowflake.com/en/sql-reference/stored-procedures-overview.html

• Question 217:

  User-level network policies can be created by which of the following roles? (Select TWO).

  A. ROLEADMIN
  B. ACCOUNTADMIN
  C. SYSADMIN
  D. SECURITYADMIN
  E. USERADMIN
  D. SECURITYADMIN
  E. USERADMIN

  ---

  Explanation/Reference:

  By default, Snowflake allows users to connect to the service from any computer or device IP address. A security administrator (or higher) can create a network policy to allow or deny access to a single IP address or a list of addresses. Network policies currently support only Internet Protocol version 4 (i.e. IPv4) addresses. An administrator with sufficient permissions can create any number of network policies.

  https://docs.snowflake.com/en/user-guide/network-policies.html#:~:text=A%20security%20administrator%20(or%20higher,any%20number%20of%20network%20policies.

• Question 218:

  True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.

  A. True
  B. False
  A. True

  ---

  Explanation/Reference:

  You can experiment the same with snowflake UI.

• Question 219:

  What is the minimum Snowflake edition that customers planning on storing protected information in Snowflake should consider for regulatory compliance?

  A. Standard
  B. Premier
  C. Enterprise
  D. Business Critical Edition
  D. Business Critical Edition

  ---

  Explanation/Reference:

  Reference: https://docs.snowflake.com/en/user-guide/intro-editions.html

• Question 220:

  When cloning a database containing stored procedures and regular views, that have fully qualified table references, which of the following will occur?

  A. The cloned views and the stored procedures will reference the cloned tables in the cloned database.
  B. An error will occur, as views with qualified references cannot be cloned.
  C. An error will occur, as stored objects cannot be cloned.
  D. The stored procedures and views will refer to tables in the source database.
  D. The stored procedures and views will refer to tables in the source database.