Snowflake Snowflake Certifications COF-R02 Questions & Answers

• Question 11:

  For non-materialized views, what column in Information Schema and Account Usage identifies whether a view is secure or not?

  A. CHECK_OPTION

  B. IS_SECURE

  C. IS_UPDATEABLE

  D. TABLE_NAME

  Correct Answer: B

• Question 12:

  What is the MINIMUM Snowflake edition required to use the periodic rekeying of micro-partitions?

  A. Enterprise

  B. Business Critical

  C. Standard

  D. Virtual Private Snowflake

  Correct Answer: B

  Reference: https://docs.snowflake.com/en/user-guide/intro-editions.html#business-critical-edition

• Question 13:

  When cloning a database, what is cloned with the database? (Choose two.)

  A. Privileges on the database

  B. Existing child objects within the database

  C. Future child objects within the database

  D. Privileges on the schemas within the database

  E. Only schemas and tables within the database

  Correct Answer: BE

• Question 14:

  Which of the following features are available with the Snowflake Enterprise edition? (Choose two.)

  A. Database replication and failover

  B. Automated index management

  C. Customer managed keys (Tri-secret secure)

  D. Extended time travel

  E. Native support for geospatial data

  Correct Answer: AD

• Question 15:

  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.

  Correct Answer: D

• Question 16:

  A virtual warehouse is created using the following command: Create warehouse my_WH with warehouse_size = MEDIUM min_cluster_count = 1 max_cluster_count = 1 auto_suspend = 60 auto_resume = true; The image below is a graphical representation of the warehouse utilization across two days.

  

  What action should be taken to address this situation?

  A. Increase the warehouse size from Medium to 2XL.

  B. Increase the value for the parameter MAX_CONCURRENCY_LEVEL.

  C. Configure the warehouse to a multi-cluster warehouse.

  D. Lower the value of the parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS.

  Correct Answer: B

• Question 17:

  When publishing a Snowflake Data Marketplace listing into a remote region what should be taken into consideration? (Choose two.)

  A. There is no need to have a Snowflake account in the target region, a share will be created for each user.

  B. The listing is replicated into all selected regions automatically, the data is not.

  C. The user must have the ORGADMIN role available in at least one account to link accounts for replication.

  D. Shares attached to listings in remote regions can be viewed from any account in an organization.

  E. For a standard listing the user can wait until the first customer requests the data before replicating it to the target region.

  Correct Answer: AC

• Question 18:

  Which minimum Snowflake edition allows for a dedicated metadata store?

  A. Standard

  B. Enterprise

  C. Business Critical

  D. Virtual Private Snowflake

  Correct Answer: D

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

• Question 19:

  Which Snowflake feature will allow small volumes of data to continuously load into Snowflake and will incrementally make the data available for analysis?

  A. COPY INTO

  B. CREATE PIPE

  C. INSERT INTO

  D. TABLE STREAM

  Correct Answer: B

• Question 20:

  Which of the following is the Snowflake Account_Usage.Metering_History view used for?

  A. Gathering the hourly credit usage for an account

  B. Compiling an account's average cloud services cost over the previous month

  C. Summarizing the throughput of Snowpipe costs for an account

  D. Calculating the funds left on an account's contract

  Correct Answer: A