Snowflake SnowPro Core Practice Test - Questions Answers, Page 18

In Snowflake's access control model, the default owner of an object is the role that was used to create the object.This role has the OWNERSHIP privilege on the object and can grant access to other roles1

The minimum Snowflake edition required to use Dynamic Data Masking is the Enterprise edition.This feature is not available in the Standard edition2.

The Snowflake Cloud Services layer manages various services, including authentication and metadata management.This layer ties together all the different components of Snowflake to process user requests, manage sessions, and control access3.

Data masking policies in Snowflake allow for the obfuscation of specific data within a field, enabling some users to see the full data while limiting others.This feature is particularly useful for handling PII, ensuring that sensitive information is only visible to authorized users1.

Thelist @my_stagecommand in Snowflake can be used to verify if data has been uploaded to an external stage namedmy_stage.This command provides a list of files that are present in the specified stage2.

The Snowflake Cloud Services layer performs a variety of tasks, including the management of metadata and the parsing and optimization of queries.This layer is responsible for coordinating activities across Snowflake, including user session management, security, and query compilation3.

In Snowflake's data sharing model, any full Snowflake account can both provide and consume shared data. Additionally, the data consumer pays only for the compute resources used to query the shared data.No actual data is copied or transferred between accounts, and shared data does not take up any storage in a consumer account, so the consumer does not pay for data storage1.

Reference =Introduction to Secure Data Sharing | Snowflake Documentation

In Snowflake, to extract a specific element from a JSON stored in a VARIANT column, the correct syntax is to use the dot notation. Therefore, the queryselect src.dealership from car_sales;will return the dealership information contained within each JSON object in thesrccolumn.

The Search Optimization Service significantly improves the performance of selective point lookup queries on tables by creating and maintaining a persistent data structure called a search access path, which allows some micro-partitions to be skipped when scanning the table