SnowPro Core Practice Test

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

Question 61

To run a Multi-Cluster Warehouse in auto-scale mode, a user would:

  1. Configure the Maximum Clusters setting to ג€Auto-Scaleג€
  2. Set the Warehouse type to ג€Autoג€
  3. Set the Minimum Clusters and Maximum Clusters settings to the same value
  4. Set the Minimum Clusters and Maximum Clusters settings to the different values

Question 62

Which of the following terms best describes Snowflake's database architecture?

  1. Columnar shared nothing
  2. Shared disk
  3. Multi-cluster, shared data
  4. Cloud-native shared memory

Question 63

Which of the following are options when creating a Virtual Warehouse? (Choose two.)

  1. Auto-drop
  2. Auto-resize
  3. Auto-resume
  4. Auto-suspend

Question 64

A Virtual Warehouse's auto-suspend and auto-resume settings apply to:

  1. The primary cluster in the Virtual Warehouse
  2. The entire Virtual Warehouse
  3. The database the Virtual Warehouse resides in
  4. The queries currently being run by the Virtual Warehouse

Question 65

Fail-safe is unavailable on which table types? (Choose two.)

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