CompTIA
Checkpoint
ISC
HP
Dell
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
Certiport
ISC2
All Vendors
  2. Home
  3. Exams
  4. Snowflake
  5. SnowPro Core

Free SnowPro Core Exam Braindumps (page: 27)

Page 26 of 287
PDF with 1268 Questions

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

Answer(s): C


Reference:

https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions.html



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

  1. True
  2. False

Answer(s): B


Reference:

https://docs.snowflake.com/en/user-guide/credits.html



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

  1. Concurrency
  2. Performance

Answer(s): B


Reference:

https://docs.snowflake.com/en/user-guide/warehouses-considerations.html#warehouse-resizing-improves-performance



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

Answer(s): D


Reference:

https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html






Post your Comments and Discuss Snowflake SnowPro Core exam with other Community members:

SnowPro Core Discussions & Posts