Snowflake COF-R02 Online Practice Questions and Exam Preparation

Snowflake COF-R02 Online Questions & Answers

• Question 91:

  What is the MINIMUM edition of Snowflake that is required to use a SCIM security integration?

  A. Business Critical Edition
  B. Standard Edition
  C. Virtual Private Snowflake (VPS)
  D. Enterprise Edition
  D. Enterprise Edition

• Question 92:

  Which feature allows a user the ability to control the organization of data in a micro-partition?

  A. Range Partitioning
  B. Search Optimization Service
  C. Automatic Clustering
  D. Horizontal Partitioning
  D. Horizontal Partitioning

• Question 93:

  Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).

  A. The table contains a column that has very low cardinality
  B. DML statements that are being issued against the table are blocked
  C. The table has a small number of micro-partitions
  D. Queries on the table are running slower than expected
  E. The clustering depth for the table is large
  A. The table contains a column that has very low cardinality
  E. The clustering depth for the table is large

• Question 94:

  A running virtual warehouse is suspended.

  What is the MINIMUM amount of time that the warehouse will incur charges for when it is restarted?

  A. 1 second
  B. 60 seconds
  C. 5 minutes
  D. 60 minutes
  B. 60 seconds

• Question 95:

  What is a best practice after creating a custom role?

  A. Create the custom role using the SYSADMIN role.
  B. Assign the custom role to the SYSADMIN role
  C. Assign the custom role to the PUBLIC role
  D. Add__CUSTOM to all custom role names
  B. Assign the custom role to the SYSADMIN role

  ---

  Explanation/Reference:

  When creating roles that will serve as the owners of securable objects in the system, Snowflake recommends creating a hierarchy of custom roles, with the top-most custom role assigned to the system role SYSADMIN. This role structure allows system administrators to manage all objects in the account, such as warehouses and database objects, while restricting management of users and roles to the USERADMIN role.

• Question 96:

  Why would a customer size a Virtual Warehouse from an X-Small to a Medium?

  A. To accommodate more queries
  B. To accommodate more users
  C. To accommodate fluctuations in workload
  D. To accommodate a more complex workload
  D. To accommodate a more complex workload

  ---

  Explanation/Reference:

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

• Question 97:

  Which of the following is an example of an operation that can be completed without requiring compute, assuming no queries have been executed previously?

  A. SELECT SUM (ORDER_AMT) FROM SALES;
  B. SELECT AVG(ORDER_QTY) FROM SALES;
  C. SELECT MIN(ORDER_AMT) FROM SALES;
  D. SELECT ORDER_AMT * ORDER_QTY FROM SALES;
  B. SELECT AVG(ORDER_QTY) FROM SALES;

• Question 98:

  True or False: A table in Snowflake can only be queried using the Virtual Warehouse that was used to load the data.

  A. True
  B. False
  B. False

• Question 99:

  Which Snowflake tool would be BEST to troubleshoot network connectivity?

  A. SnowCLI
  B. SnowUI
  C. SnowSQL
  D. SnowCD
  D. SnowCD

  ---

  Explanation/Reference:

  https://docs.snowflake.com/en/user-guide/snowcd.html#:~:text=SnowCD%20(i.e.%20Snowflake%20Connectivity%20Diagnostic,their%20network%20connection%20to%20Snowflake.

• Question 100:

  What are two ways to create and manage Data Shares in Snowflake? (Choose two.)

  A. Via the Snowflake Web Interface (Ul)
  B. Via the data_share=true parameter
  C. Via SQL commands
  D. Via Virtual Warehouses
  A. Via the Snowflake Web Interface (Ul)
  C. Via SQL commands

  ---

  Explanation/Reference:

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