COF-C02 Free Practice Test

- (Topic 3)
If file format options are specified in multiple locations, the load operation selects which option FIRST to apply in order of precedence?

1. A. Table definition
2. B. Stage definition
3. C. Session level
4. D. COPY INTO TABLE statement

Correct Answer: D
When file format options are specified in multiple locations, the load operation applies the options in the following order of precedence: first, the COPY INTO TABLE statement; second, the stage definition; and third, the table definition1

- (Topic 1)
In which scenarios would a user have to pay Cloud Services costs? (Select TWO).

1. A. Compute Credits = 50 Credits Cloud Services = 10
2. B. Compute Credits = 80 Credits Cloud Services = 5
3. C. Compute Credits = 10 Credits Cloud Services = 9
4. D. Compute Credits = 120 Credits Cloud Services = 10
5. E. Compute Credits = 200 Credits Cloud Services = 26

Correct Answer: AE
In Snowflake, Cloud Services costs are incurred when the Cloud Services usage exceeds 10% of the compute usage (measured in credits). Therefore, scenarios A and E would result in Cloud Services charges because the Cloud Services usage is more than 10% of the compute credits used.
References:
✑ [COF-C02] SnowPro Core Certification Exam Study Guide
✑ Snowflake??s official documentation on billing and usage1

- (Topic 4)
What happens to the objects in a reader account when the DROP MANAGED ACCOUNT command is executed?

1. A. The objects are dropped.
2. B. The objects enter the Fail-safe period.
3. C. The objects enter the Time Travel period.
4. D. The objects are immediately moved to the provider account.

Correct Answer: A
When the DROP MANAGED ACCOUNT command is executed in Snowflake, it removes the managed account, including all objects created within the account, and access to the account is immediately restricted2.
References: [COF-C02] SnowPro Core Certification Exam Study Guide

- (Topic 6)
Which SQL statement will require a virtual warehouse to run?

1. A. SELECT COUNT{*) FROM TBL_EMPLOYEE;
2. B. ALTER TABLE TBL_EMPLOYEE ADD COLUMN EMP_REGI0N VARCHAR(20);
3. C. INSERT INTO TBL_EMPLOYEE(EMP_ID, EMP_NAME, EMP_SALARY, DEPT)VALUES(1,'Adam*,20000,* Finance');
4. D. CREATE OR REPLACE TABLE TBL_EMPLOYEE ( EMP_ID NUMBER,EMP_NAME VARCHAR(30),EMP_SALARY NUMBER, DEPT VARCHAR{20));

Correct Answer: C
A virtual warehouse in Snowflake is used to perform data processing tasks that require computational resources, such as queries that modify data or perform significant computation. Of the options provided:
✑ C. INSERT INTO TBL_EMPLOYEE(EMP_ID, EMP_NAME, EMP_SALARY,
DEPT) VALUES(1,'Adam',20000,'Finance');This SQL statement performs a data modification operation (DML) by inserting a new record into theTBL_EMPLOYEEtable, which requires computational resources provided by a virtual warehouse to execute.
References:
✑ Snowflake Documentation: Understanding Virtual Warehouses

- (Topic 2)
How are serverless features billed?

1. A. Per second multiplied by an automatic sizing for the job
2. B. Per minute multiplied by an automatic sizing for the job, with a minimum of one minute
3. C. Per second multiplied by the size, as determined by the SERVERLESS_FEATURES_SIZE account parameter
4. D. Serverless features are not billed, unless the total cost for the month exceeds 10% of the warehouse credits, on the account

Correct Answer: B
Serverless features in Snowflake are billed based on the time they are used, measured in minutes. The cost is calculated by multiplying the duration of the job by an automatic sizing determined by Snowflake, with a minimum billing increment of one minute. This means that even if a serverless feature is used for less than a minute, it will still be billed for the full minute.