Logo ExamsQA
Exit
Official Bank 0/778

SnowPro Core Certification Exam (COF-C02) - Snowflake Exam Questions

Last updated on June 20, 2026

97% Exam Compliance
778 Total Questions
1
Question
What versions of Snowflake should be used to manage compliance with Personal Identifiable Information (PII) requirements? (Choose two.)
Select 2
Options
A Enterprise Edition
B Custom Edition
C Business Critical Edition
D Virtual Private Snowflake
E Standard Edition
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

2
Question
A Snowflake user is actively logged into Snowflake when a user-level network policy is assigned to that user.

Which Snowflake do it the user's IP address does not match the user-level network policy rules?
Options
A Log the user out.
B Prevent the user from executing additional queries.
C Deactivate the network policy.
D Allow the user to continue until the session or login token expires.
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

3
Question
What type of function returns one value for each Invocation?
Options
A Aggregate
B Table
C Scalar
D Window
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

4
Question
Which SQL command can be used to verify the privileges that are granted to a role?
Options
A SHOW GRANTS ON ROLE
B SHOW GRANTS TO ROLE
C SHOW ROLES
D SHOW GRANTS FOR ROLE
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

5
Question
Which Snowflake feature allows administrators to identify unused data that may be archived or deleted?
Options
A Access history
B Dynamic Data Masking
C Data classification
D Object tagging
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.