BlackFriday 2024! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Snowflake Exam DEA-C01 Topic 1 Question 21 Discussion

Actual exam question for Snowflake's DEA-C01 exam
Question #: 21
Topic #: 1
[All DEA-C01 Questions]

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?

Show Suggested Answer Hide 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 Hubert at Apr 25, 2024, 05:20 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel
Lindsey
6 months ago
That's true, but what if some warehouses are underutilized? Monitoring could be a hassle.
upvoted 0 times
...
Linsey
7 months ago
Yeah, lots to consider with thousands of Analysts, right?
upvoted 0 times
...
Zack
7 months ago
That could work, but we need to monitor query runtimes to resize if needed.
upvoted 0 times
...
Alease
7 months ago
We could also create a size XL virtual warehouse to support all dashboard queries.
upvoted 0 times
...
Dawne
7 months ago
I'm not sure if that would be efficient. Maybe we should monitor utilization first.
upvoted 0 times
...
Zack
7 months ago
What about creating a virtual warehouse for every 250 Analysts?
upvoted 0 times
...
Alease
7 months ago
That sounds like a good idea. We can let the system start and stop clusters based on demand.
upvoted 0 times
...
Dawne
7 months ago
I think we should assign queries to a multi-cluster virtual warehouse with economy auto-scaling.
upvoted 0 times
...

Save Cancel