Snowflake SnowPro Core Practice Test - Questions Answers, Page 39
Related questions
Question 381

Which function unloads data from a relational table to JSON?
Explanation:
TheTO_JSONfunction 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.
Reference: [COF-C02] SnowPro Core Certification Exam Study Guide
Question 382

Which commands can only be executed using SnowSQL? (Select TWO).
Explanation:
TheLISTandPUTcommands are specific to SnowSQL and cannot be executed in the web interface or other SQL clients.LISTis used to display the contents of a stage, andPUTis used to upload files to a stage.
Reference: [COF-C02] SnowPro Core Certification Exam Study Guide
Question 383

What is the relationship between a Query Profile and a virtual warehouse?
Explanation:
A Query Profile provides detailed execution information for a query, which can be used to analyze the performance and behavior of queries. This information can help users optimize and right-size their virtual warehouses for better efficiency.
Reference: [COF-C02] SnowPro Core Certification Exam Study Guide
Question 384

What is the primary purpose of a directory table in Snowflake?
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.
Reference: [COF-C02] SnowPro Core Certification Exam Study Guide
Question 385

Which statements describe benefits of Snowflake's separation of compute and storage? (Select TWO).
Explanation:
Snowflake's architecture allows for the independent scaling of compute resources, meaning you can increase or decrease the computational power as needed without affecting storage. This separation also means that storage can grow independently of compute usage, allowing for more flexible and cost-effective data management.
Question 386

Which commands are restricted in owner's rights stored procedures? (Select TWO).
Explanation:
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.
Question 387

Which Snowflake feature allows administrators to identify unused data that may be archived or deleted?
Explanation:
The Access History feature in Snowflake allows administrators to track data access patterns and identify unused data. This information can be used to make decisions about archiving or deleting data to optimize storage and reduce costs.
Question 388

Which privilege must be granted by one role to another role, and cannot be revoked?
Explanation:
The OWNERSHIP privilege is unique in that it must be granted by one role to another and cannot be revoked. This ensures that the transfer of ownership is deliberate and permanent, reflecting the importance of ownership in managing access and permissions.
Question 389

How can performance be optimized for a query that returns a small amount of data from a very large base table?
Explanation:
The search optimization service in Snowflake is designed to improve the performance of selective point lookup queries on large tables, which is ideal for scenarios where a query returns a small amount of data from a very large base table1.
Reference: [COF-C02] SnowPro Core Certification Exam Study Guide
Question 390

What does the LATERAL modifier for the FLATTEN function do?
Explanation:
The LATERAL modifier for the FLATTEN function allows joining information outside the object (such as other columns in the source table) with the flattened data, creating a lateral view that correlates with the preceding tables in the FROM clause2345.
Reference: [COF-C02] SnowPro Core Certification Exam Study Guide
Question