AWS Certified Data Analytics – Specialty — Question 104

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?

Answer options

Correct answer: D

Explanation

Materialized views are an effective way to enhance the performance of frequently run queries, especially for the executive team needing fast access to financial reports. While Concurrency scaling and Workload management (WLM) assist in managing query loads, they do not specifically optimize the performance of repeated queries like materialized views do. Short query acceleration (SQA) is designed for speeding up short queries, which doesn't align with the needs of the executive team for optimal performance.