SnowPro Core Practice Test

SnowPro Core Practice Test practice questions, page 44 of 54, with answer review and explanations.

Question 216

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?

  1. Row access policies
  2. Data masking policies
  3. Data encryption
  4. Role based access control

Question 217

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?

  1. view @my_stage
  2. list @my_stage
  3. show @my_stage
  4. display @my_stage

Question 218

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

  1. Management of metadata
  2. Computing the data
  3. Maintaining Availability Zones
  4. Infrastructure security
  5. Parsing and optimizing queries

Question 219

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

  1. The Data Consumer pays for data storage as well as for data computing.
  2. The shared data is copied into the Data Consumer account, so the Consumer can modify it without impacting the base data of the Provider.
  3. A Snowflake account can both provide and consume shared data.
  4. The Provider is charged for compute resources used by the Data Consumer to query the shared data.
  5. The Data Consumer pays only for compute resources to query the shared data.

Question 220

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?

  1. select src:dealership from car_sales;
  2. select src.dealership from car_sales;
  3. select src:Dealership from car_sales;
  4. select dealership from car_sales;