SnowPro Core Exam QuestionsBrowse all questions from this exam

SnowPro Core Exam - Question 26


Which of the following statements are true of Virtual Warehouses? (Choose all that apply.)

Show Answer
Correct Answer: ABCD

Virtual Warehouses have several configurable features. Customers can change the size of the Warehouse after creation, and this can be done while the Warehouse is running, allowing for dynamic scaling based on demand. Additionally, Warehouses can be configured to suspend automatically after a period of inactivity to save resources and auto-resume when new queries are submitted, ensuring efficient resource utilization.

Discussion

17 comments
Sign in to comment
ggwwOptions: AB
Dec 28, 2021

all fours are true

Marge23
Sep 16, 2023

Additionally, multi-cluster warehouses support all the same properties and actions as single-cluster warehouses, including: Specifying a warehouse size. Resizing a warehouse at any time. Auto-suspending a running warehouse due to inactivity; note that this does not apply to individual clusters, but rather the entire multi-cluster warehouse. Auto-resuming a suspended warehouse when new queries are submitted.

BobFar
Oct 10, 2023

https://docs.snowflake.com/en/user-guide/warehouses-overview

Tapasgup007Options: AB
Dec 3, 2022

All four are True

jerintomOptions: AB
May 31, 2024

All ABCD options are true, system is not allowing voters to select all 4 options at the same time

sandy91Options: ABCD
Jan 15, 2024

all the options are correct

avashishOptions: AB
Jan 20, 2024

All option looks correct A. Customers can change the size of the Warehouse after creation. this can be done from warehouse configuration. B. A Warehouse can be resized while running. Its part of auto scaling. C. A Warehouse can be configured to suspend after a period of inactivity. User can configure suspend timings in warehouse configuration. D. A Warehouse can be configured to auto-resume when new queries are submitted. it is also configured in warehouse settings

grantzOptions: AB
Mar 15, 2024

Additionally, multi-cluster warehouses support all the same properties and actions as single-cluster warehouses, including: Specifying a warehouse size. Resizing a warehouse at any time. Auto-suspending a running warehouse due to inactivity; note that this does not apply to individual clusters, but rather the entire multi-cluster warehouse. Auto-resuming a suspended warehouse when new queries are submitted. https://docs.snowflake.com/en/user-guide/warehouses-multicluster

gandugaruaOptions: CD
Mar 23, 2024

this is misleading. All four are true

TheHuman_Options: CD
May 6, 2024

abcd true

deeshubhOptions: AB
May 7, 2024

ABCD All Four are Correct, Please correct the UI also

_yyuktaOptions: AB
Feb 23, 2024

A and B

abhijit2683Options: AB
Mar 30, 2024

All options are correct.

jerintomOptions: ABCD
Apr 16, 2024

All options

PrashantGupta1616Options: AB
Jun 6, 2024

ABCD The following statements are true of Snowflake Virtual Warehouses: A. Customers can change the size of the Warehouse after creation B. A Warehouse can be resized while running C. A Warehouse can be configured to suspend after a period of inactivity D. A Warehouse can be configured to auto-resume when new queries are submitted

PrashantGupta1616Options: AB
Jun 11, 2024

all fours are true

pranaligOptions: AB
Jun 16, 2024

correct answer:ABCD

Mallikharjuna452Options: ABCD
Jul 17, 2024

All options are correct

Anithec0derOptions: AB
Jul 20, 2024

All fours are true