COF-C02 Free Practice Test

- (Topic 6)
Which Snowsight feature can be used to perform data manipulations and transformations using a programming language?

1. A. SnowSQL
2. B. Dashboards
3. C. Python worksheets
4. D. Provider Studio

Correct Answer: C
Python worksheets in Snowsight enable users to perform data manipulations and transformations using the Python programming language directly within the Snowflake environment. This feature integrates the power of Python with Snowflake's data warehousing capabilities, allowing for sophisticated data analysis and manipulation.
✑ Introduction to Python Worksheets:
✑ Functionality:
✑ Integration with Snowflake:
References:
✑ Snowflake Documentation: Snowsight Python Worksheets

- (Topic 2)
What is the following SQL command used for? Select * from table(validate(t1, job_id => '_last'));

1. A. To validate external table files in table t1 across all sessions
2. B. To validate task SQL statements against table t1 in the last 14 days
3. C. To validate a file for errors before it gets executed using a COPY command
4. D. To return errors from the last executed COPY command into table t1 in the current session

Correct Answer: D
The SQL command Select * from table(validate(t1, job_id => '_last')); is used to return errors from the last executed COPY command into table t1 in the current session. It checks the results of the most recent data load operation and provides details on any errors that occurred during that process1.

- (Topic 1)
A user unloaded a Snowflake table called mytable to an internal stage called mystage. Which command can be used to view the list of files that has been uploaded to the staged?

1. A. list @mytable;
2. B. list @%raytable;
3. C. list @ %m.ystage;
4. D. list @mystage;

Correct Answer: D
The command list @mystage; is used to view the list of files that have been uploaded to an internal stage in Snowflake. The list command displays the metadata for all files in the specified stage, which in this case is mystage. This command is particularly useful for verifying that files have been successfully unloaded from a Snowflake table to the stage and for managing the files within the stage.
References:
✑ Snowflake Documentation on Stages
✑ SnowPro® Core Certification Study Guide

- (Topic 2)
Which command should be used to load data from a file, located in an external stage, into a table in Snowflake?

1. A. INSERT
2. B. PUT
3. C. GET
4. D. COPY

Correct Answer: D
The COPY command is used in Snowflake to load data from files located in an external stage into a table. This command allows for efficient and parallelized data loading from various file formats1.
References = [COF-C02] SnowPro Core Certification Exam Study Guide, Snowflake Documentation

- (Topic 2)
What is the minimum Snowflake edition that has column-level security enabled?

1. A. Standard
2. B. Enterprise
3. C. Business Critical
4. D. Virtual Private Snowflake

Correct Answer: B
Column-level security, which allows for the application of masking policies to columns in tables or views, is available starting from the Enterprise edition of Snowflake1. References = [COF-C02] SnowPro Core Certification Exam Study Guide, Snowflake Documentation1