Exam SnowPro Advanced Data Engineer topic 1 question 16 discussion

Actual exam question from Snowflake's SnowPro Advanced Data Engineer

Question #: 16
Topic #: 1

[All SnowPro Advanced Data Engineer 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 topic 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?

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.
B. Assign all queries to a multi-cluster virtual warehouse set to maximized mode. Monitor to determine the smallest suitable number of clusters.
C. Create a virtual warehouse for every 250 Analysts. Monitor to determine how many of these virtual warehouses are being utilized at capacity.
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.

Show Suggested Answer

Suggested Answer: B 🗳️

by stopthisnow at Oct. 30, 2023, 1:41 p.m.

Comments

Submit Cancel

stopthisnow

6 months, 3 weeks ago

Selected Answer: B

This mode is enabled by specifying the same value for both maximum and minimum number of clusters (note that the specified value must be larger than 1). In this mode, when the warehouse is started, Snowflake starts all the clusters so that maximum resources are available while the warehouse is running. This mode is effective for statically controlling the available compute resources, particularly if you have large numbers of concurrent user sessions and/or queries and the numbers do not fluctuate significantly. The key term here is : "The top priority is the responsiveness". A is also valid but it will have impact on the responsiveness due to economy option. The queries will queue up before scale-up happens.

upvoted 4 times

...