nerdexam
SnowflakeSnowflake

DEA-C02 · Question #16

DEA-C02 Question #16: Real Exam Question with Answer & Explanation

Sign in or unlock DEA-C02 to reveal the answer and full explanation for question #16. The question stem and answer options stay visible for context.

Performance Optimization

Question

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?

Options

  • AAssign queries to a multi-cluster virtual warehouse with economy auto-scaling. Allow the system
  • BAssign all queries to a multi-cluster virtual warehouse set to maximized mode. Monitor to
  • CCreate a virtual warehouse for every 250 Analysts. Monitor to determine how many of these
  • DCreate a size XL virtual warehouse to support all the dashboard queries. Monitor query runtimes

Unlock DEA-C02 to see the answer

You've previewed enough free DEA-C02 questions. Unlock DEA-C02 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#Multi-cluster Virtual Warehouses#Warehouse Maximized Mode#Performance Tuning#Concurrency Management
Full DEA-C02 PracticeBrowse All DEA-C02 Questions