Snowflake Snowflake Certifications COF-R02 Questions & Answers

• Question 61:

  Users are responsible for data storage costs until what occurs?

  A. Data expires from Time Travel

  B. Data expires from Fail-safe

  C. Data is deleted from a table

  D. Data is truncated from a table

  Correct Answer: B

• Question 62:

  What is the recommended compressed file size range for continuous data loads using Snowpipe?

  A. 8-16 MB

  B. 16-24 MB

  C. 10-99 MB

  D. 100-250 MB

  Correct Answer: B

• Question 63:

  A user created a transient table and made several changes to it over the course of several days. Three days after the table was created, the user would like to go back to the first version of the table.

  How can this be accomplished?

  A. Use Time Travel, as long as DATA_RETENTION_TIME_IN_DAYS was set to at least 3 days.

  B. The transient table version cannot be retrieved after 24 hours.

  C. Contact Snowflake Support to have the data retrieved from Fail-safe storage.

  D. Use the FAIL_SAFE parameter for Time Travel to retrieve the data from Fail-safe storage.

  Correct Answer: B

• Question 64:

  In a Snowflake role hierarchy, what is the top-level role?

  A. SYSADMIN

  B. ORGADMIN

  C. ACCOUNTADMIN D. SECURITYADMIN

  Correct Answer: B

• Question 65:

  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...

  Correct Answer: C

• Question 66:

  Where is Snowflake metadata stored?

  A. Within the data files

  B. In the virtual warehouse layer

  C. In the cloud services layer

  D. In the remote storage layer

  Correct Answer: B

  Reference: https://docs.snowflake.com/en/user-guide/querying-metadata.html#:~:text=Snowflake%20automatically%20generates%20metadata%20for,using%20a%20standard%20SELECT%20statement

• Question 67:

  Which of the following features, associated with Continuous Data Protection (CDP), require additional Snowflake-provided data storage? (Choose two.)

  A. Tri-Secret Secure

  B. Time Travel

  C. Fail-safe

  D. Data encryption

  E. External stages

  Correct Answer: BC

• Question 68:

  How would a user run a multi-cluster warehouse in maximized mode?

  A. Configure the maximum clusters setting to "Maximum."

  B. Turn on the additional clusters manually after starting the warehouse.

  C. Set the minimum Clusters and maximum Clusters settings to the same value.

  D. Set the minimum clusters and maximum clusters settings to different values.

  Correct Answer: D

• Question 69:

  The following JSON is stored in a VARIANT column called src of the CAR_SALES table:

  

  A user needs to extract the dealership information from the JSON.

  How can this be accomplished?

  A. select src:dealership from car_sales;

  B. select src.dealership from car_sales;

  C. select src:Dealership from car_sales;

  D. select dealership from car_sales;

  Correct Answer: A

• Question 70:

  The is the minimum Fail-safe retention time period for transient tables?

  A. 1 day

  B. 7 days

  C. 12 hours

  D. 0 days

  Correct Answer: D