DEA-C01 Data Store Management Practice Question

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

• ✓

  Create a workload management (WLM) queue with a higher priority for critical reports and assign them to that queue.

  Why this is correct

  Amazon Redshift WLM allows you to create separate queues with different priorities. By assigning critical reports to a high-priority queue, they are scheduled before queries in lower-priority queues. This ensures that critical reports run promptly even when ad-hoc queries are present. This is the most direct way to prioritize specific workloads without affecting others.

• ✗

  Use short query acceleration (SQA) to run short queries in a dedicated space.

  Why it's wrong here

  SQA is designed to speed up short-running queries by executing them in a separate queue, but it does not prioritize long-running critical reports. In fact, SQA might further delay critical reports if they are long-running and not eligible for SQA. The requirement is to prioritize critical reports, not short queries.

• ✗

  Increase the cluster size by adding more nodes to reduce overall query time.

  Why it's wrong here

  Adding nodes increases compute capacity and can improve overall performance, but it does not provide prioritization. Critical reports would still compete with ad-hoc queries for resources. While scaling might reduce queue times, it does not guarantee that critical reports run promptly during peak hours, and it is a more expensive and less targeted solution.

• ✗

  Enable concurrency scaling to automatically add transient clusters for queued queries.

  Why it's wrong here

  Concurrency scaling adds additional cluster capacity to handle bursts of queries, but it does not prioritize critical reports over ad-hoc queries. All queries in the same queue would benefit from additional capacity, but there is no guarantee that critical reports will run ahead of ad-hoc queries. It also incurs additional costs and may not address the root cause of queue contention.

Go deeper

Related to this question