Snowflake Snowflake Certifications COF-R02 Questions & Answers

• Question 41:

  Which command sets the Virtual Warehouse for a session?

  A. COPY WAREHOUSE FROM <>;

  B. SET WAREHOUSE = <>;

  C. USE WAREHOUSE <>;

  D. USE VIRTUAL_WAREHOUSE <>;

  Correct Answer: C

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

• Question 42:

  What are the responsibilities of Snowflake's Cloud Service layer? (Choose three.)

  A. Authentication

  B. Resource management

  C. Virtual warehouse caching

  D. Query parsing and optimization

  E. Query execution

  F. Physical storage of micro-partitions

  Correct Answer: ADE

• Question 43:

  Which of the following are characteristics of security in Snowflake?

  A. Account and user authentication is only available with the Snowflake Business Critical edition.

  B. Support for HIPAA and GDPR compliance is available for UI Snowflake editions.

  C. Periodic rekeying of encrypted data is available with the Snowflake Enterprise edition and higher

  D. Private communication to internal stages is allowed in the Snowflake Enterprise edition and higher.

  Correct Answer: C

• Question 44:

  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

  Correct Answer: C

• Question 45:

  What types of data listings are available in the Snowflake Data Marketplace? (Choose two.)

  A. Reader

  B. Consumer

  C. Vendor

  D. Standard

  E. Personalized

  Correct Answer: DE

• Question 46:

  Files have been uploaded to a Snowflake internal stage. The files now need to be deleted.

  Which SQL command should be used to delete the files?

  A. PURGE

  B. MODIFY

  C. REMOVE

  D. DELETE

  Correct Answer: D

  Reference: https://www.simplilearn.com/tutorials/sql-tutorial/delete-in-sql#:~:text=The%20Delete%20command%20in%20SQL,the%20records%20from%20a%20table

• Question 47:

  Why does Snowflake recommend file sizes of 100-250 MB compressed when loading data?

  A. Optimizes the virtual warehouse size and multi-cluster setting to economy mode

  B. Allows a user to import the files in a sequential order

  C. Increases the latency staging and accuracy when loading the data

  D. Allows optimization of parallel operations

  Correct Answer: D

• Question 48:

  What effect does WAIT_FOR_COMPLETION = TRUE have when running an ALTER WAREHOUSE command and changing the warehouse size?

  A. The warehouse size does not change until all queries currently running in the warehouse have completed.

  B. The warehouse size does not change until all queries currently in the warehouse queue have completed.

  C. The warehouse size does not change until the warehouse is suspended and restarted.

  D. It does not return from the command until the warehouse has finished changing its size.

  Correct Answer: D

• Question 49:

  Which snowflake objects will incur both storage and cloud compute charges? (Select TWO)

  A. Materialized view

  B. Sequence

  C. Secure view

  D. Transient table

  E. Clustered table

  Correct Answer: DE

• Question 50:

  If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?

  A. 4

  B. 8

  C. 16

  D. 32

  Correct Answer: B

  Size specifies the amount of compute resources available per cluster in a warehouse. Snowflake supports the following warehouse sizes:

  

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