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 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!

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 are valid values for the FIELD_OPTIONALLY_ENCLOSED_BY option in the copy into command used during data unloading? (Select TWO).
Select 2
Options
A 'NONE'
B Single quote character (')
C 'NULL'
D NULL
E NONE
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
When would Snowsight automatically detect if a target account is in a different region and enable cross-cloud auto-fulfillment?
Options
A When using a paid listing on the Snowflake Marketplace
B When using a personalized listing on the Snowflake Marketplace
C When using a private listing on the Snowflake Marketplace
D When using a Direct Share with another account
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.