DEA-C01 · Question #182
DEA-C01 Question #182: Real Exam Question with Answer & Explanation
Sign in or unlock DEA-C01 to reveal the answer and full explanation for question #182. The question stem and answer options stay visible for context.
Question
A company receives a data file from a partner each day in an Amazon S3 bucket. The company uses a daily AWS Glue extract, transform, and load (ETL) pipeline to clean and transform each data file. The output of the ETL pipeline is written to a CSV file named Daily.csv in a second S3 bucket. Occasionally, the daily data file is empty or is missing values for required fields. When the file is missing data, the company can use the previous day's CSV file. A data engineer needs to ensure that the previous day's data file is overwritten only if the new daily file is complete and valid. Which solution will meet these requirements with the LEAST effort?
Options
- AInvoke an AWS Lambda function to check the file for missing data and to fill in missing values in
- BConfigure the AWS Glue ETL pipeline to use AWS Glue Data Quality rules. Develop rules in Data
- CUse AWS Glue Studio to change the code in the ETL pipeline to fill in any missing values in the
- DRun a SQL query in Amazon Athena to read the CSV file and drop missing rows. Copy 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.