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

Question

A company wants to ingest streaming data into an Amazon Redshift data warehouse from an Amazon Managed Streaming for Apache Kafka (Amazon MSK) cluster. A data engineer needs to develop a solution that provides low data access time and that optimizes storage costs. Which solution will meet these requirements with the LEAST operational overhead?

Accepted Answer

Correct answer: A. The correct answer is A. Option A: Create an external schema that maps to the MSK cluster. Create a materialized view that references the external schema to consume the streaming data from the MSK topic. Amazon MSK provides fully managed Apache Kafka for streaming.

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