A data engineer notices that Amazon Athena queries are held in a queue before the queries run. How can the data engineer prevent the queries from queueing?

Question

Options

• AIncrease the query result limit.
• BConfigure provisioned capacity for an existing workgroup.
• CUse federated queries.
• DAllow users who run the Athena queries to an existing workgroup.

• A
  2% (1)
• B
  89% (40)
• C
  2% (1)
• D
  7% (3)

Explanation

Athena queries queue when concurrent query demand exceeds the available compute capacity (DPUs) allocated to a workgroup. Provisioned capacity lets you pre-allocate a fixed number of DPUs for a workgroup, ensuring queries have dedicated resources and do not wait in a queue. Option A (increasing query result limit) affects result size, not concurrency. Option C (federated queries) expands data sources but does not address queueing. Option D (adding users to a workgroup) controls access, not compute capacity.

No community discussion yet for this question.