AmazonAmazon
DEA-C01 · Question #39
DEA-C01 Question #39: Real Exam Question with Answer & Explanation
Sign in or unlock DEA-C01 to reveal the answer and full explanation for question #39. The question stem and answer options stay visible for context.
Data Ingestion and Transformation
Question
A company receives .csv files that contain physical address data. The data is in columns that have the following names: Door_No, Street_Name, City, and Zip_Code. The company wants to create a single column to store these values in the following format: Which solution will meet this requirement with the LEAST coding effort?
Options
- AUse AWS Glue DataBrew to read the files. Use the NEST_TO_ARRAY transformation to create
- BUse AWS Glue DataBrew to read the files. Use the NEST_TO_MAP transformation to create the
- CUse AWS Glue DataBrew to read the files. Use the PIVOT transformation to create the new
- DWrite a Lambda function in Python to read the files. Use the Python data dictionary type to create
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 DataBrew#Data Transformation#NEST_TO_MAP#Column Aggregation