Snowflake COF-R02 Online Practice Questions and Exam Preparation

Snowflake COF-R02 Online Questions & Answers

• Question 311:

  A role is created and owns 2 tables. This role is then dropped. Who will now own the two tables?

  A. The tables are now orphaned
  B. The user that deleted the role
  C. SYSADMIN
  D. The assumed role that dropped the role
  D. The assumed role that dropped the role

  ---

  Explanation/Reference:

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

• Question 312:

  Which Snowflake SQL statement would be used to determine which users and roles have access to a role called MY_ROLE?

  A. SHOW GRANTS OF ROLE MY_ROLE
  B. SHOW GRANTS TO ROLE MY_ROLE
  C. SHOW GRANTS FOR ROLE MY_ROLE
  D. SHOW GRANTS ON ROLE MY_ROLE
  B. SHOW GRANTS TO ROLE MY_ROLE

• Question 313:

  What is the minimum Snowflake edition that has column-level security enabled?

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

• Question 314:

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

  A. Compute layer
  B. Storage layer
  C. Cloud infrastructure layer
  D. Cloud services layer
  A. Compute layer

  ---

  Explanation/Reference:

  For query execution, Snowflake uses the Virtual Warehouse. The query processing layer is separated from the disk storage layer in the Snowflake data architecture. You can use the data from the storage layer to run queries in this layer https://www.projectpro.io/article/snowflake-architecture-what-does-snowflake-do/556#:~:text=Query%20Processing%20Layer%2FCompute%20Layer,run%20queries%20in%20this%20layer.

• Question 315:

  A table needs to be loaded. The input data is in JSON format and is a concatenation of multiple JSON documents. The file size is 3 GB. A warehouse size small is being used. The following COPY INTO command was executed:

  COPY INTO SAMPLE FROM @~/SAMPLE.JSON (TYPE=JSON)

  The load failed with this error:

  Max LOB size (16777216) exceeded, actual size of parsed column is 17894470.

  How can this issue be resolved?

  A. Compress the file and load the compressed file.
  B. Split the file into multiple files in the recommended size range (100 MB-250 MB).
  C. Use a larger-sized warehouse.
  D. Set STRIP_OUTER_ARRAY=TRUE in the COPY INTO command.
  A. Compress the file and load the compressed file.

• Question 316:

  A user created a new worksheet within the Snowsight Ul and wants to share this with teammates

  How can this worksheet be shared?

  A. Create a zero-copy clone of the worksheet and grant permissions to teammates
  B. Create a private Data Exchange so that any teammate can use the worksheet
  C. Share the worksheet with teammates within Snowsight
  D. Create a database and grant all permissions to teammates
  C. Share the worksheet with teammates within Snowsight

• Question 317:

  Which of the following describes the Snowflake Cloud Services layer?

  A. Coordinates activities in the Snowflake account
  B. Executes queries submitted by the Snowflake account users
  C. Manages quotas on the Snowflake account storage
  D. Manages the virtual warehouse cache to speed up queries
  A. Coordinates activities in the Snowflake account

• Question 318:

  The number of queries that a Virtual Warehouse can concurrently process is determined by: Choose 2 answers

  A. The complexity of each query
  B. The CONCURRENT_QUERY_UMIT parameter set on the Snowflake account
  C. The size of the data required for each query
  D. The tool that s executing the query
  A. The complexity of each query
  C. The size of the data required for each query

  ---

  Explanation/Reference:

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

• Question 319:

  What is the purpose of multi-cluster virtual warehouses?

  A. To create separate data warehouses to increase query optimization
  B. To allow users the ability to choose the type of compute nodes that make up a virtual warehouse cluster
  C. To eliminate or reduce Queuing of concurrent queries
  D. To allow the warehouse to resize automatically
  C. To eliminate or reduce Queuing of concurrent queries

  ---

  Explanation/Reference:

  https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html#:~:text=Multi%2Dcluster%20warehouses%20enable%20you,during%20peak%20and%20off%20hours.

• Question 320:

  True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.

  A. True
  B. False
  B. False

  ---

  Explanation/Reference:

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