DEA-C01 · Question #263
DEA-C01 Question #263: Real Exam Question with Answer & Explanation
Sign in or unlock DEA-C01 to reveal the answer and full explanation for question #263. The question stem and answer options stay visible for context.
Question
A company adds new data to a large CSV file in an Amazon S3 bucket every day. The file contains company sales data from the previous 5 years. The file currently includes more than 5,000 rows. The CSV file structure is shown below with sample data: The company needs to use Amazon Athena to run queries on the CSV file to fetch data from a specific time period. Which solution will meet this requirement MOST cost-effectively?
Options
- AWrite an Apache Spark script to convert the CSV data to JSON format. Create an AWS Glue job
- BUse prefixes to partition the data in the S3 bucket. Use the SALE_DATE column to create a
- CLaunch an Amazon EMR cluster. Specify AWS Glue Data Catalog as the default Apache Hive
- DCreate an Amazon RDS database. Create a table named SALES that matches the schema of the
Unlock DEA-C01 to see the answer
You've previewed enough free DEA-C01 questions. Unlock DEA-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.