SnowPro Core

SnowPro Core 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