SnowPro Core Certification Exam Questions and Answers
Question 197
What is the primary purpose of a directory table in Snowflake?
Options:
A.
To store actual data from external stages
B.
To automatically expire file URLs for security
C.
To manage user privileges and access control
D.
To store file-level metadata about data files in a stage
Answer:
D
Explanation:
A directory table in Snowflake is used to store file-level metadata about the data files in a stage. It is conceptually similar to an external table and provides information such as file size, last modified timestamp, and file URL. References: [COF-C02] SnowPro Core Certification Exam Study Guide
Question 198
Which Snowflake view is used to support compliance auditing?
Options:
A.
ACCESS_HISTORY
B.
COPY_HISTORY
C.
QUERY_HISTORY
D.
ROW ACCESS POLICIES
Answer:
A
Explanation:
The ACCESS_HISTORY view in Snowflake is utilized to support compliance auditing. It provides detailed information on data access within Snowflake, including reads and writes by user queries. This view is essential for regulatory compliance auditing as it offers insights into the usage of tables and columns, and maintains a direct link between the user, the query, and the accessed data1.
References: [COF-C02] SnowPro Core Certification Exam Study Guide
Question 199
Which function unloads data from a relational table to JSON?
Options:
A.
TO_OBJECT
B.
TO_JSON
C.
TO_VARIANT
D.
OBJECT CONSTRUCT
Answer:
B
Explanation:
The TO_JSON function is used to convert a VARIANT value into a string containing the JSON representation of the value. This function is suitable for unloading data from a relational table to JSON format. References: [COF-C02] SnowPro Core Certification Exam Study Guide
Question 200
What is a characteristic of materialized views in Snowflake?
Options:
A.
Materialized views do not allow joins.
B.
Clones of materialized views can be created directly by the user.
C.
Multiple tables can be joined in the underlying query of a materialized view.
D.
Aggregate functions can be used as window functions in materialized views.
Answer:
C
Explanation:
One of the characteristics of materialized views in Snowflake is that they allow multiple tables to be joined in the underlying query. This enables the pre-computation of complex queries involving joins, which can significantly improve the performance of subsequent queries that access the materialized view4. References: [COF-C02] SnowPro Core Certification Exam Study Guide