Snowflake Snowflake Certifications COF-C02 Questions & Answers

• Question 871:

  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: C

  https://community.snowflake.com/s/question/0D53r00009kC6WhCAK/can-a-task-have-multiple-sql-queries

• Question 872:

  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: BE

• Question 873:

  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

  Correct Answer: C

• Question 874:

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

  A. Standard

  B. Enterprise

  C. Business Critical

  D. Virtual Private Snowflake

  Correct Answer: B

• Question 875:

  How many resource monitors can be assigned at the account level?

  A. 1

  B. 2

  C. 3

  D. 4

  Correct Answer: A

• Question 876:

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

  A. SYSADMIN

  B. ORGADMIN

  C. ACCOUNTADMIN

  D. SECURITYADMIN

  Correct Answer: C

• Question 877:

  Which of the following are considerations when using a directory table when working with unstructured data? (Choose two.)

  A. A directory table is a separate database object.

  B. Directory tables store data file metadata.

  C. A directory table will be automatically added to a stage.

  D. Directory tables do not have their own grantable privileges.

  E. Directory table data can not be refreshed manually.

  Correct Answer: BD

• Question 878:

  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 879:

  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 880:

  Which query profile statistics help determine if efficient pruning is occurring? (Choose two.)

  A. Bytes sent over network

  B. Percentage scanned from cache

  C. Partitions total

  D. Bytes spilled to local storage

  E. Partitions scanned

  Correct Answer: CE