DEA-C01 · Question #204
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…
The correct answer is A. Use the SUPER data type to store the data in the Amazon Redshift table. Amazon Redshift's SUPER data type is purpose-built for storing and querying semi-structured data, including JSON. You can load JSON directly into a SUPER column using the COPY command with the JSON option, and then query it using PartiQL-Redshift's SQL-compatible language for…
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.
How the community answered
(40 responses)- A93% (37)
- B5% (2)
- C3% (1)
Explanation
Amazon Redshift's SUPER data type is purpose-built for storing and querying semi-structured data, including JSON. You can load JSON directly into a SUPER column using the COPY command with the JSON option, and then query it using PartiQL-Redshift's SQL-compatible language for semi-structured data-without any transformation. This requires the least effort because no preprocessing pipeline is needed. Using AWS Glue to flatten the JSON (B) and using Lambda to flatten it (D) both require building and maintaining additional ETL code. Storing in S3 and querying with Athena (C) does not load the data into Redshift at all, which fails to meet the requirement.
Topics
Community Discussion
No community discussion yet for this question.