DEA-C01 Practice Question 87: Athena Capacity Reservation Workgroup

Athena capacity reservations give you *"dedicated serverless processing capacity for the queries you run in Athena."* You create a reservation, specify the number of Data Processing Units (DPUs) and assign workgroups to it: *"you can allocate capacity to a workgroup used for time-sensitive financial reporting queries to isolate those queries from less critical queries in another workgroup. This gives you predictable query execution for critical workloads"* (option A). No SQL changes are required.

- B is wrong because the data scanned limit is a cost control that cancels queries scanning too much. It adds no processing capacity. - C is wrong because result reuse helps when the same query is repeated. Month-end reports typically run new queries, and reuse does not reserve capacity. - D is wrong because a higher DML quota lets more queries start at once, but they still share on-demand capacity with the ad hoc queries. Queries that run on a reservation do not count toward that quota, and only a reservation provides dedicated capacity.

Reference: Manage query processing capacity