Free Snowflake COF-C02 Exam Questions

Become Snowflake Certified with updated COF-C02 exam questions and correct answers

Page: 1 / 279

Total 1392 Questions | Updated On: Feb 20, 2025

Add To Cart

Question 1

The is the minimum Fail-safe retention time period for transient tables?

A : 1 day

B : 7 days

C : 12 hours

D : 0 days

Answer: D

Question 2

Users are responsible for data storage costs until what occurs?

A : Data expires from Time Travel

B : Data expires from Fail-safe

C : Data is deleted from a table

D : Data is truncated from a table

Answer: B

Question 3

Select true statement with respect to API Integration..

A : An API integration object is tied to a specific cloud platform account and role within that account, but not to a specific HTTPS proxy URL

B : Your Snowflake account can have multiple API integration objects

C : Multiple external functions can use the same API integration object, and thus the same HTTPS proxy service

D : Only Snowflake roles with OWNERSHIP or USAGE privileges on the API integration can use the API integration directly

Answer: A,B,C,D

Question 4

Marko, a Data Engineer is using Snowpipe for data loading in micro batches for one of the Finance Data workload. There are set of files he attempted to load into the snowflake table using Snowpipe. While monitoring he found that there are set of files has multiple issue, He queried the COPY_HISTORY view & checked the STATUS column which indicates whether a particular set of files was loaded, partially loaded, or failed to load. But he wants to view all errors in the files alongwith Load status, how he can check all errors?

A : He can check RETURN_ALL_ERROR_MESSAGE column in the COPY_HISTORY view which can provides a reason and view all errors in the files

B : He can view all errors in the files, by executing a COPY INTO

statement with the VALIDATION_ERROR_MODE copy option set to RETURN_ALL_PIPE_ERRORS

C : Marko can look out for FIRST_ERROR_MESSAGE column in the COPY_HISTORY view which can provides a reason why a files partially loaded or failed for all the files

D : He can view all errors in the files, by executing a COPY INTO

statement with the VALIDATION_MODE copy option set to RETURN_ALL_ERRORS

Answer: D

Question 5

Which of the following are true regarding External tables?

A : External tables are read-only.

B : An external table points to an external stage.

C : Data in external tables can be updated using the DML language.

D : Data in External tables can be deleted using the DELETE SQL command.

Answer: A,B

Page: 1 / 279

Total 1392 Questions | Updated On: Feb 20, 2025

Add To Cart