Snowflake SnowPro Core Practice Test - Questions Answers, Page 41
List of questions
Related questions
Question 401

Which Snowflake table objects can be shared with other accounts? (Select TWO).
Explanation:
In Snowflake,permanent tablesandexternal tablescan be shared with other accounts using Secure Data Sharing.Temporary tables, transient tables, and UDTFs are not shareable objects
Question 402

Which object can be used with Secure Data Sharing?
Explanation:
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.
Question 403

How can a Snowflake administrator determine which user has accessed a database object that contains sensitive information?
Explanation:
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.
Question 404

Which type of loop requires a BREAK statement to stop executing?
Explanation:
TheLOOPtype of loop in Snowflake Scripting does not have a built-in termination condition and requires aBREAKstatement to stop executing4.
Question 405

Which Snowflake function is maintained separately from the data and helps to support features such as Time Travel, Secure Data Sharing, and pruning?
Explanation:
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.
Question 406

Which views are included in the DATA SHARING USAGE schema? (Select TWO).
Explanation:
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.
Question 407

What are the least privileges needed to view and modify resource monitors? (Select TWO).
Explanation:
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.
Question 408

How can a Snowflake user traverse semi-structured data?
Explanation:
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.
Question 409

What is the purpose of the Snowflake SPLIT TO_TABLE function?
Explanation:
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.
Question 410

A column named 'Data' contains VARIANT data and stores values as follows:
How will Snowflake extract the employee's name from the column data?
Explanation:
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.
Question