Snowflake SnowPro Core Practice Test - Questions Answers, Page 41

Viewscan be used with Secure Data Sharing in Snowflake.Materialized views, external tables, and UDFs are not typically shared directly for security and performance reasons2.

To determine which user has accessed a database object containing sensitive information, a Snowflake administrator can query theACCESS_HISTORYview in theACCOUNT_USAGEschema, which provides information about access to database objects3.

TheLOOPtype of loop in Snowflake Scripting does not have a built-in termination condition and requires aBREAKstatement to stop executing4.

Micro-partitioning is a Snowflake function that is maintained separately from the data and supports features such as Time Travel, Secure Data Sharing, and pruning.It allows Snowflake to efficiently manage and query large datasets by organizing them into micro-partitions1.

The DATA_SHARING_USAGE schema includes views that display information about listings published in the Snowflake Marketplace or a data exchange, which includes DATA_TRANSFER_HISTORY and LISTING_TELEMETRY_DAILY2.

To view and modify resource monitors, the least privileges needed are MONITOR and MODIFY.These privileges allow a user to monitor credit usage and make changes to resource monitors3.

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.

The purpose of the Snowflake SPLIT_TO_TABLE function is to split a string based on a specified delimiter and flatten the results into rows.This table function is useful for transforming a delimited string into a set of rows that can be further processed or queried5.

In Snowflake, to extract a specific value from a VARIANT column, you use the column name followed by a colon and then the key. The keys are case-sensitive. Therefore, to extract the employee's name from the ''Data'' column, the correct syntax isdata:employee.name.