ExamTopics Logo
Mail Us[email protected]
Menu
Amazon Discussions
exam questions

Exam AWS Certified Data Engineer - Associate DEA-C01 All Questions

View all questions & answers for the AWS Certified Data Engineer - Associate DEA-C01 exam
Go to Exam

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

Exam question from Amazon's AWS Certified Data Engineer - Associate DEA-C01
Question #: 194
Topic #: 1
[All AWS Certified Data Engineer - Associate DEA-C01 Questions]

A company needs to load customer data that comes from a third party into an Amazon Redshift data warehouse. The company stores order data and product data in the same data warehouse. The company wants to use the combined dataset to identify potential new customers.

A data engineer notices that one of the fields in the source data includes values that are in JSON format.

How should the data engineer load the JSON data into the data warehouse with the LEAST effort?

  • A. Use the SUPER data type to store the data in the Amazon Redshift table.
  • B. Use AWS Glue to flatten the JSON data and ingest it into the Amazon Redshift table.
  • C. Use Amazon S3 to store the JSON data. Use Amazon Athena to query the data.
  • D. Use an AWS Lambda function to flatten the JSON data. Store the data in Amazon S3.
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
by kupo777 at Nov. 4, 2024, 10:47 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

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
HagarTheHorrible
4 months, 1 week ago
Selected Answer: A
The SUPER data type in Amazon Redshift allows you to store semi-structured data such as JSON directly in a Redshift table without the need to flatten or transform the data first.
upvoted 2 times
...
kupo777
5 months, 3 weeks ago
A is correct. https://docs.aws.amazon.com/redshift/latest/dg/super-overview.html
upvoted 3 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago