SnowPro Core Practice Test

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

Question 101

Which of the following statements is true of Snowflake micro-partitioning?

  1. Micro-partitioning has been known to introduce data skew
  2. Micro-partitioning: requires a partitioning schema to be defined up front
  3. Micro-partitioning is transparently completed using the ordering that occurs when the data is inserted/loaded
  4. Micro-partitioning can be disabled within a Snowflake account

Question 102

True or False: Snowflake bills for a minimum of five minutes each time a Virtual Warehouse is started.

  1. True
  2. False

Question 103

When scaling up Virtual Warehouses by increasing Virtual Warehouse t-shirt size, you are primarily scaling for improved:

  1. Concurrency
  2. Performance

Question 104

As a best practice, clustering keys should only be defined on tables of which minimum size?

  1. Multi-Kilobyte (KB) Range
  2. Multi-Megabyte (MB) Range
  3. Multi-Gigabyte (GB) Range
  4. Multi-Terabyte (TB) Range

Question 105

How a Snowpipe charges calculated?

  1. Per-second/per Warehouse size
  2. Per-second/per-core granularity
  3. Number of Pipes in account
  4. Total storage bucket size