Snowflake SnowPro Core Recertification - COF-R02 Exam Practice Test

A. False B. True

A. In the remote storage layer B. In the cloud services layer C. Within the data files D. In the virtual warehouse layer

A. False B. True

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. 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(); C. 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. D. 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();

A. False B. True

A. False B. True

A. Calculating the funds left on an account's contract B. Summarizing the throughput of Snowpipe costs for an account C. Gathering the hourly credit usage for an account D. Compiling an account's average cloud services cost over the previous month

A. Data is not available for copying or moving to an individual Snowflake account. B. Data needs to be loaded into a cloud provider as a consumer account. C. Data is live, ready-to-query, and can be personalized. D. Data is available without copying or moving. E. Data transformations are required when combining Data Marketplace datasets with existing data in Snowflake.

A.
B.
C.
D.