This website uses cookies to ensure you get the best experience.
Learn more.
Analysts use Athena to query years of clickstream CSV files in S3. Most queries select a few columns for one day, but currently scan almost all historical data. Which TWO changes best reduce scanned data and improve these queries? (Choose TWO.)
- Put every file into one unpartitioned prefix and select every column in every query.
- Convert the dataset to a suitable compressed columnar format such as Parquet.
- Partition the data by event date and include appropriate partition filters in queries.
- Create a Glue crawler that discovers the existing unpartitioned CSV schema but leave file layout and queries unchanged.
- Transition all active query files to Glacier Deep Archive and query them immediately without restoration.
Exam
Practice exam
AWS Solutions Architect Associate (SAA-C03) - Full Practice Exam 1
A full-length, original 65-question practice exam covering secure, resilient, high-performing, and cost-optimized AWS architectures. Includes scenario-based single-answer and multiple-answer questions, with explanations for every choice. Suggested practice time: 130 minutes. Independent preparation
65 questions
Free practice
SAA-C03
Oleksandr Andrushchenko
Oct 13