AWS Certified Data Engineer - Associate DEA-C01Demo

By Amazon · Question Mode

QuestionQ312

Data Ingestion and Transformation

A company must implement real-time analytics for a retail shopping platform. The company wants to capture clickstream data, process it, and load it into Amazon Redshift for analysis. The solution must support hundreds of megabytes of data each second.

Which solution meets these requirements with the LEAST analytics query latency?

  • A Use Amazon Data Firehose to capture the data. Store the data in an Amazon S3 bucket. Use the COPY command to load data into Amazon Redshift.
  • B Use Amazon Managed Streaming for Apache Kafka (Amazon MSK) to capture the data. Use Amazon EMR to process the data. Use federated queries to access data in Amazon Redshift.
  • C Use Amazon Kinesis Data Streams to capture the data. Use Amazon Redshift streaming ingestion to load data directly into materialized views.
  • D Use Amazon DynamoDB Streams to capture the data. Use AWS Glue to process the data. Use a zero-ETL integration to load the data into Amazon Redshift.
Explanation

Amazon Redshift streaming ingestion consumes Amazon Kinesis Data Streams directly into Redshift materialized views, eliminating an intermediate Amazon S3 staging area and batch COPY loading. It is designed for low-latency, high-speed streaming ingestion, and a materialized-view refresh can ingest hundreds of megabytes per second.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!