AmazonAmazon
DEA-C01 · Question #18
DEA-C01 Question #18: Real Exam Question with Answer & Explanation
Sign in or unlock DEA-C01 to reveal the answer and full explanation for question #18. The question stem and answer options stay visible for context.
Data Ingestion and Transformation
Question
A data engineer must ingest a source of structured data that is in .csv format into an Amazon S3 data lake. The .csv files contain 15 columns. Data analysts need to run Amazon Athena queries on one or two columns of the dataset. The data analysts rarely query the entire file. Which solution will meet these requirements MOST cost-effectively?
Options
- AUse an AWS Glue PySpark job to ingest the source data into the data lake in .csv format.
- BCreate an AWS Glue extract, transform, and load (ETL) job to read from the .csv structured data
- CUse an AWS Glue PySpark job to ingest the source data into the data lake in Apache Avro
- DCreate an AWS Glue extract, transform, and load (ETL) job to read from the .csv structured data
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.
Topics
#AWS Glue ETL#Amazon Athena#Data Lake#Data Formats