SnowPro Core Practice Test

Review 1352 SNOWPRO-CORE practice questions with answer explanations and community insights.

Question 1

Snowflake provides a mechanism for its customers to override its natural clustering algorithms. This method is:

  1. Micro-partitions
  2. Clustering keys
  3. Key partitions
  4. Clustered partitions

Question 2

Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.)

  1. Custom
  2. Economy
  3. Optimized
  4. Standard

Question 3

True or False: A single database can exist in more than one Snowflake account.

  1. True
  2. False

Question 4

Which of the following roles is recommended to be used to create and manage users and roles?

  1. SYSADMIN
  2. SECURITYADMIN
  3. PUBLIC
  4. ACCOUNTADMIN

Question 5

True or False: Bulk unloading of data from Snowflake supports the use of a SELECT statement.

  1. True
  2. False