DEA-C01 · Question #204
DEA-C01 Question #204: Real Exam Question with Answer & Explanation
Sign in or unlock DEA-C01 to reveal the answer and full explanation for question #204. The question stem and answer options stay visible for context.
Question
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?
Options
- AUse the SUPER data type to store the data in the Amazon Redshift table.
- BUse AWS Glue to flatten the JSON data and ingest it into the Amazon Redshift table.
- CUse Amazon S3 to store the JSON data. Use Amazon Athena to query the data.
- DUse an AWS Lambda function to flatten the JSON data. Store the data in Amazon S3.
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.