Snowflake Exam SnowPro-Core Topic 3 Question 100 Discussion

Actual exam question for Snowflake's SnowPro-Core exam

Question #: 100
Topic #: 3

[All SnowPro-Core Questions]

What are key characteristics of virtual warehouses in Snowflake? (Select TWO).

AWarehouses that are multi-cluster can have nodes of different sizes.

BWarehouses can be started and stopped at any time.

CWarehouses can be resized at any time, even while running.

DWarehouses are billed on a per-minute usage basis.

EWarehouses can only be used for querying and cannot be used for data loading.

Show Suggested Answer

Suggested Answer: B, C

Virtual warehouses in Snowflake can be started and stopped at any time, providing flexibility in managing compute resources.They can also be resized at any time, even while running, to accommodate varying workloads910. Reference: [COF-C02] SnowPro Core Certification Exam Study Guide

by Jani at Sep 13, 2024, 01:32 PM

Limited Time Offer

25%

Off

Get Premium SnowPro-Core Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Jannette

8 months ago

Virtual warehouses, huh? Sounds like a perfect place to store my virtual inventory of virtual goods. Where do I sign up?

upvoted 0 times

Dona

7 months ago

C) Warehouses can be resized at any time, even while running.

upvoted 0 times

...

Dean

8 months ago

A) Warehouses can be started and stopped at any time.

upvoted 0 times

...

Lashon

8 months ago

Hold up, did you say virtual warehouses? I thought we were talking about actual warehousing, like forklifts and stuff. This tech stuff is just too much for me!

upvoted 0 times

...

Bulah

8 months ago

I agree with B and D, but isn't A also a thing? I mean, how else are we supposed to handle those big data workloads?

upvoted 0 times

Lou

7 months ago

D) Warehouses are billed on a per-minute usage basis.

upvoted 0 times

...

Mattie

8 months ago

B) Warehouses can be started and stopped at any time.

upvoted 0 times

...

Azalee

8 months ago

A) Warehouses that are multi-cluster can have nodes of different sizes.

upvoted 0 times

...

Shaniqua

9 months ago

Hmm, I'm pretty sure C is also a key feature. Being able to resize your warehouse on the fly is super handy.

upvoted 0 times

Delisa

8 months ago

D) Warehouses are billed on a per-minute usage basis.

upvoted 0 times

...

Krystina

8 months ago

C) Warehouses can be resized at any time, even while running.

upvoted 0 times

...

Nicholle

8 months ago

A) Warehouses that are multi-cluster can have nodes of different sizes.

upvoted 0 times

...

Merlyn

9 months ago

I believe virtual warehouses in Snowflake are billed on a per-minute usage basis. That's another important characteristic.

upvoted 0 times

...

Yuki

9 months ago

Wow, this is a tricky one! I think B and D are the key characteristics. Gotta love that on-demand billing, am I right?

upvoted 0 times

Micaela

8 months ago

It's great to have that flexibility and cost-effectiveness with virtual warehouses.

upvoted 0 times

...

Telma

8 months ago

Definitely! And the fact that they are billed on a per-minute usage basis is a huge plus.

upvoted 0 times

...

Jani

9 months ago

I agree, being able to start and stop warehouses at any time is super convenient.

upvoted 0 times

...

Joye

9 months ago

I agree with Iola. Another key characteristic is that warehouses can be resized while running.

upvoted 0 times

...

Iola

9 months ago

I think key characteristics of virtual warehouses in Snowflake are being able to start and stop them at any time.

upvoted 0 times

...