MLS-C01 Question #315: Real Exam Question with Answer & Explanation

Question

A company processes millions of orders every day. The company uses Amazon DynamoDB tables to store order information. When customers submit new orders, the new orders are immediately added to the DynamoDB tables. New orders arrive in the DynamoDB tables continuously. A data scientist must build a peak-time prediction solution. The data scientist must also create an Amazon QuickSight dashboard to display near real-time order insights. The data scientist needs to build a solution that will give QuickSight access to the data as soon as new order information arrives. Which solution will meet these requirements with the LEAST delay between when a new order is processed and when QuickSight can access the new order information?

Options

• AUse AWS Glue to export the data from Amazon DynamoDB to Amazon S3. Configure QuickSight
• BUse Amazon Kinesis Data Streams to export the data from Amazon DynamoDB to Amazon S3.
• CUse an API call from QuickSight to access the data that is in Amazon DynamoDB directly.
• DUse Amazon Kinesis Data Firehose to export the data from Amazon DynamoDB to Amazon S3.

Explanation

To enable near real-time ingestion of continuous DynamoDB order data into QuickSight with minimal delay, Kinesis Data Firehose should export data to S3, from where QuickSight can access it.

Common mistakes.

• A. AWS Glue is typically used for batch ETL jobs, which introduces significant latency and is not suitable for near real-time data transfer for continuous data streams.
• B. While Kinesis Data Streams can capture changes from DynamoDB Streams, it requires additional processing (e.g., a Lambda function or Kinesis Data Analytics) to write data to S3, adding complexity and potentially more latency compared to the direct integration of Kinesis Data Firehose.
• C. QuickSight does not have a native direct connector to Amazon DynamoDB for live querying, especially not for large, continuously updated datasets in a near real-time fashion; it primarily connects to data lakes, warehouses, or data services.

Concept tested. Real-time data ingestion for analytics

Reference. https://docs.aws.amazon.com/firehose/latest/dev/create-stream-dynamodb.html

No community discussion yet for this question.