SnowPro Core Exam QuestionsBrowse all questions from this exam

SnowPro Core Exam - Question 146


Which of the following are characteristics of Snowflake virtual warehouses? (Choose two.)

Show Answer
Correct Answer: ACE

Snowflake virtual warehouses allow users to utilize the SnowSQL command line client with options for setting default warehouses through configuration files. Additionally, users have the flexibility to change the default size of a virtual warehouse at any time, ensuring scalability and adaptability based on usage patterns and requirements.

Discussion

17 comments
Sign in to comment
nintendogamer64
Dec 30, 2022

CE are correct. I cant believe exam topics wants to charge for this test. We cant even vote for the correct answer in this case. What a joke.

gstv_gOptions: CE
Oct 28, 2023

C and E. Rule out A: Multi-cluster warehouses support all the same properties and actions as single-cluster warehouses, including auto-resuming a suspended warehouse when new queries are submitted. (https://docs.snowflake.com/en/user-guide/warehouses-multicluster) Rule out B: Warehouses can be suspended in non-Enterprise versions of Snowflake, but auto-suspending multi-cluster warehouses is only available in Enterprise. (https://docs.snowflake.com/en/user-guide/warehouses-considerations) Rule out D: Default warehouse size is set in the connection parameters of ODBC connections (https://docs.snowflake.com/en/developer-guide/odbc/odbc-parameters)

EmiBOption: E
Mar 6, 2023

CE is correct

HeetecOption: E
Oct 29, 2023

CE correct

AfzyOptions: CE
Oct 31, 2023

C AND E

pranalig
Jun 16, 2024

Correct Answer: CE

AmitsnowflakeOption: E
Aug 23, 2023

C and E

ThaiyaOption: C
Sep 11, 2023

c & e. Voting not enabled to choose 2 options as expected in the question

Amitsnowflake
Sep 17, 2023

CE are correct. For a multi cluster warehouse Auto suspend happens only when minimum number of cluster are running and there is no activity for a specified period of time Auto resume happens only when entire warehouse is suspend Auto resume and susped applies to entire warehouse not to individual cluster.

sid1604Option: E
Sep 22, 2023

CE are correct

BobFar
Oct 13, 2023

The Answer is C & E.

ColourseunOptions: CE
Nov 8, 2023

C and E Are correct

sandy91Options: CE
Jan 19, 2024

C and E

_yyuktaOption: E
Feb 25, 2024

CE correct

gunasekarantjk1996
May 24, 2024

CE. Still exam topics we cant blindly believe.

pranalig
Jun 15, 2024

Correct Answer: CE

Mallikharjuna452Options: CE
Jul 19, 2024

C and E are correct