Performance Concepts: Virtual Warehouses Quiz

Question 1

What is a virtual Warehouse? Choose one correct value.
- A virtual warehouse is another name for the persistent storage layer
- A virtual warehouse is a named abstraction for one or more compute modes
- A virtual warehouse is a way of logically grouping schemas
- A virtual warehouse is a cluster of compute nodes the user sets up and maintains

Answer 1

• A virtual warehouse is a named abstraction for one or more compute modes

Question 2

The following command is permitted when interacting with a Virtual Warehouse: ALTER WAREHOUSE DE_VW SET WAREHOUSE_SIZE=LARGE. True or false?

Answer 2

True

Question 3

If you were to keep a L virtual warehouse active for 4 hours, how many credits would it cost?

Answer 3

32

Question 4

What data type does the virtual warehouse property AUTO RESUME take?

Answer 4

BOOLEAN

Question 5

A Virtual warehouse can only be scaled up manually. True or false?

Answer 5

True

Question 6

What is the function of the initially suspend property of a virtual Warehouse? Choose one correct value.
- It specifies if a virtual warehouse should be suspended immediately after it’s created
- It specifies whether to automatically resume a warehouse when a SQL statement is submitted
- It specifies the number of seconds of inactivity after which a warehouse is automatically suspended
- It specifies the max threshold of queries after which point a virtual warehouse will be automatically suspended

Answer 6

It specifies if a virtual warehouse should be suspended immediately after it’s created

Question 7

What will happen to existing queries if the virtual warehouse executing them is resized? Choose one correct value.
- Existing queries will be aborted
- Existing queries will be aborted but restarted on the new size warehouse
- Existing queries are put on hold
- Existing queries are not impacted by a virtual warehouse resize

Answer 7

Existing queries are not impacted by a virtual warehouse resize

Question 8

What does it mean to scale up a virtual warehouse?
- Creating a new warehouse of the same size as one already created
- Reducing the size of a virtual warehouse
- Increasing the size of a virtual warehouse
- Dropping a virtual warehouse

Answer 8

Increasing the size of a virtual warehouse

Question 9

What does the MIN_CLUSTER_COUNT specify when creating a multi-cluster warehouse? Choose one correct value.
- The maximum number of compute nodes on the cloud platform to provision for a multi-cluster warehouse
- The minimum number of compute nodes on the cloud platform to provision for a multi-cluster warehouse
- The minimum number of warehouses that make up a multi-cluster warehouse
- The maximum number of warehouses that make up a multi-cluster warehouse

Answer 9

The minimum number of warehouses that make up a multi-cluster warehouse

Question 10

The total credit cost of a multi-cluster warehouse is the sum of all the individual running warehouses that make up that cluster. True or false

Answer 10

True