AWS Certified Data Engineer – Associate (DEA-C01) — Question 104

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?

Answer options

• A. Increase the query result limit.
• B. Configure provisioned capacity for an existing workgroup.
• C. Use federated queries.
• D. Allow users who run the Athena queries to an existing workgroup.

Correct answer: B

Explanation

The correct answer is B because configuring provisioned capacity for a workgroup allows for a dedicated amount of resources to handle queries, reducing queuing. Option A does not address the queuing issue directly, while option C is unrelated to query execution capacity. Option D may help with user access but does not resolve the underlying resource limitation leading to queuing.