- (Topic 2)
Which command sets the Virtual Warehouse for a session?
Correct Answer:C
The command USE WAREHOUSE <<warehouse name>>; is used to set the virtual warehouse for the current session in Snowflake. This command specifies which virtual warehouse to use for executing queries in that session1.
Reference: https://docs.snowflake.com/en/user-guide/warehouses-tasks.html
- (Topic 4)
Which Snowflake view is used to support compliance auditing?
Correct Answer:A
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
- (Topic 4)
How can a Snowflake user traverse semi-structured data?
Correct Answer:A
To traverse semi-structured data in Snowflake, a user can insert a colon (:) between the VARIANT column name and any first-level element. This path syntax is used to retrieve elements in a VARIANT column4.
- (Topic 4)
Which commands are restricted in owner's rights stored procedures? (Select TWO).
Correct Answer:AE
In owner??s rights stored procedures, certain commands are restricted to maintain security and integrity. The SHOW and DESCRIBE commands are limited because they can reveal metadata and structure information that may not be intended for all roles.
- (Topic 3)
Which file format will keep floating-point numbers from being truncated when data is unloaded?
Correct Answer:D
The Parquet file format is known for preserving the precision of floating-point numbers when data is unloaded, preventing truncation of the values3.