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
Which data types can be used in Snowflake to store semi-structured data? (Select TWO)
Select 2
Options
A VARIANT
B ARRAY
C CLOB
D BLOB
E JSON
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

2
Question
How does Snowflake define i1s approach to Discretionary Access Control (DAC)?
Options
A A defined level of access to an object
B Each object has an owner, who can in turn grail access to that object.
C An entity in which access can be granted
D Access privileges are assigned to roles. which are in turn assigned to use's
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

3
Question
Snowflake users can create a resource monitor at which levels? (Select TWO).
Select 2
Options
A Virtual warehouse level
B User level
C Account level
D Pipe level
E Cloud services level
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

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

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

Finish Practice?

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