Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

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.


Contribute your Thoughts:

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

Save Cancel