Snowflake
COF-C03
Q1:
What are the benefits of using the Snowflake Access_History view? (Select TWO)
☐
A
It identifies data that is not being used so that it can be archived or deleted.☐
B
It allows the user to compare query performance data over time.☐
C
It audits whether query policies are being enforced correctly.☐
D
It tracks how sensitive data has been moved.☐
E
It allows users to track the relationships among objects.
Snowflake
COF-C03
Q2:
Which activities are included in the Cloud Services layer? {Select TWO).
☐
A
Data storage☐
B
Dynamic data masking☐
C
Partition scanning☐
D
User authentication☐
E
Infrastructure management
Snowflake
COF-C03
Q3:
A user has unloaded data from a Snowflake table to an external stage.
Which command can be used to verify if data has been uploaded to the external stage named my_stage?
○
A
view @my_stage○
B
list @my_stage○
C
show @my_stage○
D
display @my_stage
Snowflake
COF-C03
Q4:
What are value types that a VARIANT column can store? (Select TWO)
☐
A
STRUCT☐
B
OBJECT☐
C
BINARY☐
D
ARRAY☐
E
CLOB
Snowflake
COF-C03
Q5:
Which Snowflake data governance feature supports resource usage monitoring?
○
A
Data classification○
B
Column lineage○
C
Access history○
D
Object tagging