COF-C02 Free Practice Test

- (Topic 3)
How would a user execute a series of SQL statements using a task?

1. 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_s1WHERE ..
2. 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 taskdefinition CREATE TASK mytask .... AScall stored_proc1(); call stored_proc2();
3. C. Use a stored procedure executing multiple SQL statements and invoke the stored procedure from the tas
4. D. CREATE TASK mytask .... AS call stored_proc_multiple_statements_inside();
5. E. Create a task for each SQL statement (e.
6. F. resulting in task1, task2, etc.) and string the series of SQL statements by having a control task calling task1, task2, et
7. G. sequentially.

Correct Answer: C
To execute a series of SQL statements using a task, a user would use a stored procedure that contains multiple SQL statements and invoke this stored procedure from the task. References: Snowflake Documentation2.

- (Topic 2)
Which statements are correct concerning the leveraging of third-party data from the Snowflake Data Marketplace? (Choose two.)

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

Correct Answer: AD
When leveraging third-party data from the Snowflake Data Marketplace, the data is live, ready-to-query, and can be personalized. Additionally, the data is available without the need for copying or moving it to an individual Snowflake account, allowing for seamless integration with existing data

- (Topic 1)
Which of the following commands cannot be used within a reader account?

1. A. CREATE SHARE
2. B. ALTER WAREHOUSE
3. C. DROP ROLE
4. D. SHOW SCHEMAS
5. E. DESCRBE TABLE

Correct Answer: A
In Snowflake, a reader account is a type of account that is intended for consuming shared data rather than performing any data management or DDL operations. The CREATE SHARE command is used to share data from your account with another account, which is not a capability provided to reader accounts. Reader accounts are typically restricted from creating shares, as their primary purpose is to read shared data rather than to share it themselves.
References:
✑ Snowflake Documentation on Reader Accounts
✑ SnowPro® Core Certification Study Guide

- (Topic 2)
Which of the following significantly improves the performance of selective point lookup queries on a table?

1. A. Clustering
2. B. Materialized Views
3. C. Zero-copy Cloning
4. D. Search Optimization Service

Correct Answer: D
The Search Optimization Service significantly improves the performance of selective point lookup queries on tables by creating and maintaining a persistent data structure called a search access path, which allows some micro-partitions to be skipped when scanning the table

- (Topic 2)
Network policies can be set at which Snowflake levels? (Choose two.)

1. A. Role
2. B. Schema
3. C. User
4. D. Database
5. E. Account
6. F. Tables

Correct Answer: CE
Network policies in Snowflake can be set at the user level and at the account level2.
Reference: https://docs.snowflake.com/en/user-guide/network-policies.html#creating-network-policies