SnowPro Core Practice Test

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

Question 41

Increasing the maximum number of clusters in a Multi-Cluster Warehouse is an example of:

  1. Scaling rhythmically
  2. Scaling max
  3. Scaling out
  4. Scaling up

Question 42

Which statement best describes Snowflake tables?

  1. Snowflake tables are logical representations of underlying physical data
  2. Snowflake tables are the physical instantiation of data loaded into Snowflake
  3. Snowflake tables require that clustering keys be defined to perform optimally
  4. Snowflake tables are owned by a user

Question 43

Which item in the Data Warehouse migration process does not apply in Snowflake?

  1. Migrate Users
  2. Migrate Schemas
  3. Migrate Indexes
  4. Build the Data Pipeline

Question 44

Snowflake provides two mechanisms to reduce data storage costs for short-lived tables. These mechanisms are: (Choose two.)

  1. Temporary Tables
  2. Transient Tables
  3. Provisional Tables
  4. Permanent Tables

Question 45

What is the maximum compressed row size in Snowflake?

  1. 8KB
  2. 16MB
  3. 50MB
  4. 4000GB