SnowPro Core Practice Test

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

Question 211

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

  1. Amazon Web Services
  2. Docker
  3. IBM Cloud
  4. Microsoft Azure Cloud
  5. Google Cloud Platform
  6. Oracle Cloud

Question 212

What is a limitation of a Materialized View?

  1. A Materialized View cannot support any aggregate functions
  2. A Materialized View can only reference up to two tables
  3. A Materialized View cannot be joined with other tables
  4. A Materialized View cannot be defined with a JOIN

Question 213

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

  1. The user who created the object
  2. The SYSADMIN role
  3. Ownership depends on the type of object
  4. The role used to create the object

Question 214

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

  1. Standard
  2. Enterprise
  3. Business Critical
  4. Virtual Private Snowflake (VPC)

Question 215

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

  1. Compute resources
  2. Query execution
  3. Authentication
  4. Data storage
  5. Metadata