Exam AWS Certified Data Engineer - Associate DEA-C01 topic 1 question 68 discussion

Exam question from Amazon's AWS Certified Data Engineer - Associate DEA-C01

Question #: 68
Topic #: 1

[All AWS Certified Data Engineer - Associate DEA-C01 Questions]

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?

A. Use AWS Glue DataBrew to read the files. Use the NEST_TO_ARRAY transformation to create the new column.
B. Use AWS Glue DataBrew to read the files. Use the NEST_TO_MAP transformation to create the new column.
C. Use AWS Glue DataBrew to read the files. Use the PIVOT transformation to create the new column.
D. Write a Lambda function in Python to read the files. Use the Python data dictionary type to create the new column.

Show Suggested Answer

Suggested Answer: B 🗳️

by damaldon at March 7, 2024, 3:01 p.m.

Disclaimers:

- ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
- Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Submit Cancel

FuriouZ

Highly Voted 1 year, 3 months ago

Selected Answer: B

NEST_TO_ARRAY would result in: [ {"key": "key1", "value": "value1"}, {"key": "key2", "value": "value2"}, {"key": "key3", "value": "value3"}] while NEST_TO_MAP results: { "key1": "value1", "key2": "value2", "key3": "value3" } Therefore go with B

upvoted 14 times

...

pypelyncar

Most Recent 1 year, 1 month ago

Selected Answer: B

The NEST_TO_MAP transformation is specifically designed to convert data from nested structures (like rows in a CSV) into key-value pairs, perfectly matching the requirement of creating a new column with address components as key-value pairs

upvoted 3 times

...

Ousseyni

1 year, 2 months ago

Selected Answer: B

AWS Glue DataBrew is a visual data preparation tool that allows for easy transformation of data without requiring extensive coding. The NEST_TO_MAP transformation in DataBrew allows you to convert columns into a JSON map, which aligns with the desired JSON format for the address data.

upvoted 4 times

...

GiorgioGss

1 year, 3 months ago

Selected Answer: A

Come on guys. That's and array there so...

upvoted 1 times

GiorgioGss

1 year, 3 months ago

I take that back. I will go with B because NEST_TO_ARRAY is not suitable for the desired JSON format where each attribute has its own key.

upvoted 2 times

...

kj07

1 year, 4 months ago

Option B: NEST_TO_MAP: Converts user-selected columns into key-value pairs, each with a key representing the column name and a value representing the row value. The order of the selected column is not maintained while creating the resultant map. The different column data types are typecast to a common type that supports the data types of all columns. https://docs.aws.amazon.com/databrew/latest/dg/recipe-actions.NEST_TO_MAP.html PIVOT: Converts all the row values in a selected column into individual columns with values. NEST_TO_ARRAY: Converts user-selected columns into array values. The order of the selected columns is maintained while creating the resultant array. The different column data types are typecast to a common type that supports the data types of all columns.

upvoted 2 times

...

damaldon

1 year, 4 months ago

Ans. A NEST_TO_ARRAY Converts user-selected columns into array values. The order of the selected columns is maintained while creating the resultant array. https://docs.aws.amazon.com/databrew/latest/dg/recipe-actions.NEST_TO_ARRAY.html

upvoted 1 times

...