Snowflake Exam DEA-C01 Topic 5 Question 30 Discussion

Actual exam question for Snowflake's DEA-C01 exam

Question #: 30
Topic #: 5

A company is building a dashboard for thousands of Analysts. The dashboard presents the results of a few summary queries on tables that are regularly updated. The query conditions vary by tope according to what data each Analyst needs Responsiveness of the dashboard queries is a top priority, and the data cache should be preserved.

How should the Data Engineer configure the compute resources to support this dashboard?

AAssign queries to a multi-cluster virtual warehouse with economy auto-scaling Allow the system to automatically start and stop clusters according to demand.

BAssign all queries to a multi-cluster virtual warehouse set to maximized mode Monitor to determine the smallest suitable number of clusters.

CCreate a virtual warehouse for every 250 Analysts Monitor to determine how many of these virtual warehouses are being utilized at capacity.

DCreate a size XL virtual warehouse to support all the dashboard queries Monitor query runtimes to determine whether the virtual warehouse should be resized.

Show Suggested Answer

Suggested Answer: B

This option is the best way to configure the compute resources to support this dashboard. By assigning all queries to a multi-cluster virtual warehouse set to maximized mode, the Data Engineer can ensure that there is enough compute capacity to handle thousands of concurrent queries from different analysts. A multi-cluster virtual warehouse can scale up or down by adding or removing clusters based on the load. A maximized scaling policy ensures that there is always at least one cluster running and that new clusters are added as soon as possible when needed. By monitoring the utilization and performance of the virtual warehouse, the Data Engineer can determine the smallest suitable number of clusters that can meet the responsiveness requirement and minimize costs.

by Salley at Aug 07, 2024, 04:59 PM

Limited Time Offer

25%

Off

Get Premium DEA-C01 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Nicholle

6 months ago

I think option C could work well too, having a virtual warehouse for every 250 Analysts can help distribute the load evenly.

upvoted 0 times

...

Desire

6 months ago

I agree with Carrol, option A seems like the most flexible solution for varying demand.

upvoted 0 times

...

Rusty

6 months ago

I disagree, I believe option D is better. Having one XL virtual warehouse can handle all queries effectively.

upvoted 0 times

...

Carrol

6 months ago

I think option A sounds like a good choice. Auto-scaling can help manage demand efficiently.

upvoted 0 times

...

Marquetta

7 months ago

I agree, D is a bit excessive. I'd go for B - let the system automatically scale up and down as needed to maintain performance.

upvoted 0 times

...

Rikki

7 months ago

Haha, D is just asking for trouble. An XL warehouse for all the queries? That's like using a sledgehammer to crack a nut!

upvoted 0 times

Kenneth

6 months ago

Haha, D is just asking for trouble. An XL warehouse for all the queries? That's like using a sledgehammer to crack a nut!

upvoted 0 times

...

Meaghan

6 months ago

A) Assign queries to a multi-cluster virtual warehouse with economy auto-scaling Allow the system to automatically start and stop clusters according to demand.

upvoted 0 times

...

Aleshia

7 months ago

I think option C could also work well. Having a virtual warehouse for every 250 Analysts could help with resource allocation.

upvoted 0 times

...

Theola

7 months ago

I prefer option D. Having a size XL virtual warehouse could provide enough resources for all queries.

upvoted 0 times

...

Fanny

7 months ago

I agree with Sonia. Auto-scaling would ensure that resources are allocated efficiently.

upvoted 0 times

...

Arlean

7 months ago

I'm not sure about B. Creating a separate warehouse for every 250 analysts seems like overkill. C might be more cost-effective and give you the control you need.

upvoted 0 times

Sena

6 months ago

I agree, having a virtual warehouse for every 250 Analysts seems like a good balance between cost-effectiveness and control.

upvoted 0 times

...

Kimbery

7 months ago

C) Create a virtual warehouse for every 250 Analysts Monitor to determine how many of these virtual warehouses are being utilized at capacity.

upvoted 0 times

...

Charolette

7 months ago

A) Assign queries to a multi-cluster virtual warehouse with economy auto-scaling Allow the system to automatically start and stop clusters according to demand.

upvoted 0 times

...

Sonia

7 months ago

I think option A sounds like a good choice. Auto-scaling would help with demand fluctuations.

upvoted 0 times

...

Emogene

8 months ago

Option B sounds like the best approach. Maintaining a single multi-cluster warehouse with max resources should provide the responsiveness needed while allowing for efficient scaling.

upvoted 0 times

Arlette

7 months ago

D) Create a size XL virtual warehouse to support all the dashboard queries Monitor query runtimes to determine whether the virtual warehouse should be resized.

upvoted 0 times

...

Gail

7 months ago

A) Assign queries to a multi-cluster virtual warehouse with economy auto-scaling Allow the system to automatically start and stop clusters according to demand.

upvoted 0 times

...

Eric

7 months ago

B) Assign all queries to a multi-cluster virtual warehouse set to maximized mode Monitor to determine the smallest suitable number of clusters.

upvoted 0 times

...