Free COF-C03 Questions for Snowflake SnowPro® Core Certification 2026 Exam (COF-C03) COF-C03 Exam as PDF & Practice Test Engine

Exam Code/Number: COF-C03
Exam Name/Title: SnowPro® Core Certification 2026 Exam (COF-C03)
Certification Provider: Snowflake
Corresponding Certification: SnowPro Core

Exam Questions: 1187
Updated On: Oct 09, 2026

Question #1

Which Snowflake tool provides detailed execution statistics of a query with no cost to the user?

A. Query acceleration service

B. Query history

C. Query Profile

D. Visualization chart

Discussion 0

Correct Answer: C Vote an answer

Question #2

What will be the result of this command?
SELECT value FROM LATERAL FLATTEN(input = > parse_json( ' [1, 2, 3] ' ));

A. It will return a single row with the array [1, 2, 3].

B. It will return a single row with three columns with values 1, 2, and 3.

C. It will return three rows with the values 1, 2, and 3.

D. It will return a single row with the values 1, 2, and 3 concatenated.

Discussion 0

Correct Answer: B Vote an answer

Question #3

What is true about sharing data in Snowflake? (Choose two.)

A. The Data Consumer pays for data storage as well as for data computing.

B. The Data Consumer pays only for compute resources to query the shared data.

C. The Provider is charged for compute resources used by the Data Consumer to query the shared data.

D. The shared data is copied into the Data Consumer account, so the Consumer can modify it without impacting the base data of the Provider.

E. A Snowflake account can both provide and consume shared data.

Discussion 0

Correct Answer: B,E Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Question #4

Which governance feature is supported by all Snowflake editions?

A. Object tags

B. Row access policies

C. Masking policies

D. OBJECT_DEPENDENCIES View

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Question #5

A user has unloaded data from Snowflake to a stage
Which SQL command should be used to validate which data was loaded into the stage?

A. show @file__stage

B. verify @file__stage

C. list @file__stage

D. view @file__stage

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Question #6

Which types of subqueries does Snowflake support? (Select TWO).

A. EXISTS, ANY /ALL, and IN subqueries in WHERE clauses: these subqueries can be correlated or uncorrelated

B. Uncorrelated scalar subqueries in WHERE clauses

C. EXISTS, ANY / ALL, and IN subqueries in where clauses: these subqueries can be correlated only

D. Uncorrelated scalar subqueries in any place that a value expression can be used

E. EXISTS, ANY / ALL, and IN subqueries in WHERE clauses: these subqueries can be uncorrelated only

Discussion 0

Correct Answer: A,D Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Question #7

A query is using more credits than expected. The Query Profile shows that a majority of the query execution is spent on remote disk I/O.
How can this be prevented m the future?

A. Increase the size of the virtual warehouse.

B. Increase the number of clusters in the virtual warehouse.

C. Increase the auto suspend time in the virtual warehouse.

D. Convert the virtual warehouse to Maximized mode.

Discussion 0

Correct Answer: A Vote an answer

Question #8

How should Multi-Factor Authentication (MFA) be enabled for a user?

A. A SECURITYADMIN must enroll the user

B. Each Snowflake user must enroll themselves

C. An ACCOUNTADMIN must enroll the user

D. A USERADMIN must enroll the user

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Question #9

What is the benefit of using the STRIP_OUTER_ARRAY parameter with the COPY INTO < table > command when loading data from a JSON file into a table?

A. It flattens multiple arrays into a single array.

B. It transforms a pivoted table into an array.

C. It removes the outer array structure and loads separate rows of data

D. It tokenizes each data string using the defined delimiters.

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Question #10

A tabular User-Defined Function (UDF) is defined by specifying a return clause that contains which keyword?

A. ROW_NUMBER

B. TABULAR

C. TABLE

D. VALUES

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Question #11

What is the MINIMUM Snowflake edition required to use the periodic rekeying of micro-partitions?

A. Business Critical

B. Enterprise

C. Virtual Private Snowflake

D. Standard

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Question #12

A user needs to create a materialized view in the schema MYDB.MYSCHEMA. Which statements will provide this access?

A. GRANT ROLE MYROLE TO USER USER1;GRANT CREATE MATERIALIZED VIEW ON
SCHEMA MYDB.MYSCHEMA TO MYROLE;

B. GRANT ROLE MYROLE TO USER USER1;GRANT CREATE MATERIALIZED VIEW ON
SCHEMA MYDB. K " - ' SCHEMA TO USER! ;

C. GRANT ROLE MYROLE TO USER USER1;GRANT CREATE MATERIALIZED VIEW ON
SCHEMA MYDB.MYSCHEMA TO USER USER1;

D. GRANT ROLE MYROLE TO USER USER1;GRANT CREATE MATERIALIZED VIEW ON
SCHEMA MYDB.MYSCHEMA TO ROLE MYROLE;

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Free COF-C03 Questions for Snowflake SnowPro® Core Certification 2026 Exam (COF-C03) COF-C03 Exam as PDF & Practice Test Engine

Download Free Snowflake COF-C03 Demo