DAS-C01 · Question #136
A company is hosting an enterprise reporting solution with Amazon Redshift. The application provides reporting capabilities to three main groups: an executive group to access financial reports, a…
The correct answer is C. Workload management (WLM). Workload Management (WLM) in Amazon Redshift allows administrators to define separate queues for different user groups, each with its own concurrency, memory allocation, and priority settings. In this scenario, you would create a high-priority queue for executives (small, fast…
Question
A company is hosting an enterprise reporting solution with Amazon Redshift. The application provides reporting capabilities to three main groups: an executive group to access financial reports, a data analyst group to run long-running ad-hoc queries, and a data engineering group to run stored procedures and ETL processes. The executive team requires queries to run with optimal performance. The data engineering team expects queries to take minutes. Which Amazon Redshift feature meets the requirements for this task?
Options
- AConcurrency scaling
- BShort query acceleration (SQA)
- CWorkload management (WLM)
- DMaterialized views
How the community answered
(28 responses)- A11% (3)
- B4% (1)
- C82% (23)
- D4% (1)
Explanation
Workload Management (WLM) in Amazon Redshift allows administrators to define separate queues for different user groups, each with its own concurrency, memory allocation, and priority settings. In this scenario, you would create a high-priority queue for executives (small, fast financial queries), a separate queue for analysts (long-running ad hoc queries), and another for data engineers (stored procedures/ETL). WLM ensures executive queries are not starved by long-running jobs. Option A (Concurrency Scaling) adds burst capacity but does not prioritize between groups. Option B (SQA) automatically prioritizes short queries over long ones but is not group-aware. Option D (Materialized Views) pre-computes results but does not manage workload routing.
Topics
Community Discussion
No community discussion yet for this question.