AWS Certified Data Engineer - Associate DEA-C01 — Topic 1 Question 68

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?

Accepted Answer

Correct answer: B. The correct answer is B. Option B: Use AWS Glue DataBrew to read the files. Use the NEST_TO_MAP transformation to create the new column. AWS Glue is a serverless ETL and data-catalog service that prepares and integrates data.

AWS Certified Data Engineer - Associate DEA-C01 — Question 68