🔥 3-day streak
AWS Certified Data Engineer - Associate142 / 159
Question 142 of 159

A retail analytics team runs an Amazon Redshift cluster that serves two distinct workloads: nightly ETL jobs that load and transform large volumes of data, and interactive BI dashboard queries that run throughout the business day. During the day, ad hoc analyst queries sometimes get stuck behind long-running maintenance queries, causing dashboard timeouts. The team wants short interactive queries to get resources quickly without manually tuning memory slots for every query type. Which approach best meets this requirement?

Reviewed for accuracy · Report an issueNext question