Snowflake Quiz (Testing)

Snowflake supports the use of external stages with which cloud platforms? (Choose three.)

• Amazon Web Services

• Docker

• IBM Cloud

• Microsoft Azure Cloud

• Google Cloud Platform

What is a limitation of a Materialized View?

• A Materialized View cannot support any aggregate functions

• A Materialized View can only reference up to two tables

• A Materialized View cannot be joined with other tables

• A Materialized View cannot be defined with a JOIN

In the Snowflake access control model, which entity owns an object by default?

• The user who created the object

• The SYSADMIN role

• Ownership depends on the type of object

• The role used to create the object

What is the minimum Snowflake edition required to use Dynamic Data Masking?

• Standard

• Enterprise

• Business Critical

• Virtual Private Snowflake (VPC)

Which services does the Snowflake Cloud Services layer manage? (Choose two.)

• Compute resources

• Query execution

• Authentication

• Data storage

• Metadata

A company needs to allow some users to see Personally Identifiable Information (PII) while limiting other users from seeing the full value of the PII. Which Snowflake feature will support this?

• Row access policies

• Data masking policies

• Data encryption

• Role based access control

A user has unloaded data from a Snowflake table to an external stage. Which command can be used to verify if data has been uploaded to the external stage named my_stage?

• view @my_stage

• list @my_stage

• show @my_stage

• display @my_stage

Which tasks are performed in the Snowflake Cloud Services layer? (Choose two.)

• Management of metadata

• Computing the data

• Maintaining Availability Zones

• Infrastructure security

• Parsing and optimizing queries

What is true about sharing data in Snowflake? (Choose two.)

• The Data Consumer pays for data storage as well as for data computing.

• The shared data is copied into the Data Consumer account, so the Consumer can modify it without impacting the base data of the Provider.

• A Snowflake account can both provide and consume shared data.

• The Provider is charged for compute resources used by the Data Consumer to query the shared data.

• The Data Consumer pays only for compute resources to query the shared data.

The following JSON is stored in a VARIANT column called src of the CAR_SALES table: A user needs to extract the dealership information from the JSON. How can this be accomplished?

• select src:dealership from car_sales;

• select src.dealership from car_sales;

• select src:Dealership from car_sales;

• select dealership from car_sales;