SAP-C02 Question #270: Real Exam Question with Answer & Explanation

Question

A company processes environmental data. The company has set up sensors to provide a continuous stream of data from different areas in a city. The data is available in JSON format. The company wants to use an AWS solution to send the data to a database that does not require fixed schemas for storage. The data must be sent in real time. Which solution will meet these requirements?

Options

• AUse Amazon Kinesis Data Firehose to send the data to Amazon Redshift.
• BUse Amazon Kinesis Data Streams to send the data to Amazon DynamoDB
• CUse Amazon Managed Streaming for Apache Kafka (Amazon MSK) to send the data to Amazon
• DUse Amazon Kinesis Data Firehose to send the data to Amazon Keyspaces (for Apache

Explanation

To process a continuous stream of JSON data in real time and store it in a schema-less database, the solution should use Amazon Kinesis Data Streams to ingest the data, with Amazon DynamoDB as the NoSQL destination.

Common mistakes.

• A. Amazon Redshift is a data warehouse that requires a fixed schema, which contradicts the requirement for a database that does not require fixed schemas.
• C. While Amazon MSK is a real-time streaming service, the destination "to Amazon" is incomplete, and Kinesis Data Streams with DynamoDB is a more common and direct serverless solution for this specific problem.
• D. Kinesis Data Firehose is typically for near real-time loading (buffering), which may not strictly meet the "real time" requirement as well as Kinesis Data Streams, although Amazon Keyspaces is a suitable schema-less database.

Concept tested. Real-time streaming to NoSQL database

Reference. https://docs.aws.amazon.com/streams/latest/dev/introduction.html

No community discussion yet for this question.