AWS Certified Big Data – Specialty — Question 62

A Redshift data warehouse has different user teams that need to query the same table with very different query types. These user teams are experiencing poor performance.
Which action improves performance for the user teams in this situation?

Answer options

• A. Create custom table views.
• B. Add interleaved sort keys per team.
• C. Maintain team-specific copies of the table.
• D. Add support for workload management queue hopping.

Correct answer: D

Explanation

The correct answer is D because workload management queue hopping allows queries from different teams to be prioritized and processed more efficiently, improving overall performance. Options A and B do not address the underlying performance issues effectively, as custom views and sort keys may not resolve conflicts created by simultaneous queries. Option C introduces redundancy and can lead to increased storage costs without necessarily improving performance.