Snowflake Snowflake Certifications COF-R02 Questions & Answers

• Question 141:

  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

  Correct Answer: C

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

• Question 142:

  Assume there is a table consisting of five micro-partitions with values ranging from A to Z.

  Which diagram indicates a well-clustered table?

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: A

• Question 143:

  Which of the following statements describe features of Snowflake data caching? (Choose two.)

  A. When a virtual warehouse is suspended, the data cache is saved on the remote storage layer.

  B. When the data cache is full, the least-recently used data will be cleared to make room.

  C. A user can only access their own queries from the query result cache.

  D. A user must set USE_METADATA_CACHE to TRUE to use the metadata cache in queries.

  E. The RESULT_SCAN table function can access and filter the contents of the query result cache.

  Correct Answer: BD

• Question 144:

  How would a user execute a series of SQL statements using a task?

  A. Include the SQL statements in the body of the task CREATE TASK mytask .. AS INSERT INTO target1 SELECT .. FROM stream_s1 WHERE .. INSERT INTO target2 SELECT .. FROM stream_s1 WHERE ..

  B. A stored procedure can have only one DML statement per stored procedure invocation and therefore the user should sequence stored procedure calls in the task definition CREATE TASK mytask .... AS call stored_proc1(); call stored_proc2();

  C. Use a stored procedure executing multiple SQL statements and invoke the stored procedure from the task. CREATE TASK mytask .... AS call stored_proc_multiple_statements_inside();

  D. Create a task for each SQL statement (e.g. resulting in task1, task2, etc.) and string the series of SQL statements by having a control task calling task1, task2, etc. sequentially.

  Correct Answer: D

• Question 145:

  What is the maximum total Continuous Data Protection (CDP) charges incurred for a temporary table?

  A. 30 days

  B. 7 days

  C. 48 hours

  D. 24 hours

  Correct Answer: D

• Question 146:

  Which privilege is required for a role to be able to resume a suspended warehouse if auto-resume is not enabled?

  A. USAGE

  B. OPERATE

  C. MONITOR

  D. MODIFY

  Correct Answer: B

  Reference: https://community.snowflake.com/s/question/0D50Z00008yHYdqSAG/auto-resume-operate-warehouse-privilege

• Question 147:

  What do the terms scale up and scale out refer to in Snowflake? (Choose two.)

  A. Scaling out adds clusters of the same size to a virtual warehouse to handle more concurrent queries.

  B. Scaling out adds clusters of varying sizes to a virtual warehouse.

  C. Scaling out adds additional database servers to an existing running cluster to handle more concurrent queries.

  D. Snowflake recommends using both scaling up and scaling out to handle more concurrent queries.

  E. Scaling up resizes a virtual warehouse so it can handle more complex workloads.

  F. Scaling up adds additional database servers to an existing running cluster to handle larger workloads.

  Correct Answer: AE

• Question 148:

  What happens to the shared objects for users in a consumer account from a share, once a database has been created in that account?

  A. The shared objects are transferred.

  B. The shared objects are copied.

  C. The shared objects become accessible.

  D. The shared objects can be re-shared.

  Correct Answer: B

• Question 149:

  Which TABLE function helps to convert semi-structured data to a relational representation?

  A. CHECK_JSON

  B. TO_JSON

  C. FLATTEN

  D. PARSE_JSON

  Correct Answer: D

• Question 150:

  Credit charges for Snowflake virtual warehouses are calculated based on which of the following considerations? (Choose two.)

  A. The number of queries executed

  B. The number of active users assigned to the warehouse

  C. The size of the virtual warehouse

  D. The length of time the warehouse is running

  E. The duration of the queries that are executed

  Correct Answer: AD