Official Bank 0/769

SnowPro-Core Exam (COF-C03) - Snowflake Exam Questions

Last updated on July 22, 2026

97% Exam Compliance
769 Total Questions
1
Question
Query parsing and compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?
Options
A Compute layer
B Cloud services layer
C Storage layer
D Cloud agnostic layer
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

2
Question
What are characteristics of Snowflake network policies? (Select TWO).
Select 2
Options
A They can only be managed using the ORGADMIN role.
B They can be applied to roles.
C They can be set for any Snowflake Edition.
D They restrict or enable access to specific IP addresses.
E They are activated using ALTER DATABASE SQL commands.
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

3
Question
What metadata does Snowflake store concerning all rows stored in a micro-partition? (Select TWO).
Select 2
Options
A The number of distinct values for each column in the micro-partition
B The range of values for each partition in the micro-partition
C A count of the number of total values in the micro-partition
D The range of values for each of the rows in the micro-partition
E The range of values for each of the columns in the micro-partition
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

4
Question
What happens to the privileges granted to Snowflake system-defined roles?
Options
A The privileges cannot be revoked.
B The privileges can be revoked by an orgadmin.
C The privileges can be revoked by an ACCOUNTADMIN.
D The privileges can be revoked by any user-defined role with appropriate privileges.
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

5
Question
In Snowflake, what allows users to perform recursive queries?
Options
A LATERAL
B QUALIFY
C PIVOT
D CONNECT BY
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

Finish Practice?

Are you sure you want to finish? This will end your practice session.