DAS-C01 · Question #125
A company analyzes historical data and needs to query data that is stored in Amazon S3. New data is generated daily as .csv files that are stored in Amazon S3. The company's analysts are using Amazon
Sign in or unlock DAS-C01 to reveal the answer and full explanation for question #125. The question stem and answer options stay visible for context.
Question
A company analyzes historical data and needs to query data that is stored in Amazon S3. New data is generated daily as .csv files that are stored in Amazon S3. The company's analysts are using Amazon Athena to perform SQL queries against a recent subset of the overall data. The amount of data that is ingested into Amazon S3 has increased substantially over time, and the query latency also has increased. Which solutions could the company implement to improve query performance? (Choose two.)
Options
- AUse MySQL Workbench on an Amazon EC2 instance, and connect to Athena by using a JDBC or
- BUse Athena to extract the data and store it in Apache Parquet format on a daily basis. Query the
- CRun a daily AWS Glue ETL job to convert the data files to Apache Parquet and to partition the
- DRun a daily AWS Glue ETL job to compress the data files by using the .gzip format. Query the
- ERun a daily AWS Glue ETL job to compress the data files by using the .lzo format. Query the
Unlock DAS-C01 to see the answer
You've previewed enough free DAS-C01 questions. Unlock DAS-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.