Question 1
During recovery testing, the following problem occurs: Athena repeatedly scans every raw CSV byte for simple date-filtered metrics. What is the most appropriate corrective action?
Explanation
Correct Answer
The symptom is: Athena repeatedly scans every raw CSV byte for simple date-filtered metrics. Columnar conversion and partition pruning reduce Athena scans for analytical queries. Apply the selected action and confirm: Queries scan only selected partitions and return reconciled rows at lower latency.
Incorrect Answers
Streaming ingestion needs sustained partition throughput and consumer scaling beyond a nightly batch service.
Managed Firehose delivery can batch and transform streams but has buffering latency and schema prerequisites.
Distributed data processing capacity can be provisioned per job while source data persists separately.