Answer-first summary for fast verification
Answer: Use Amazon Kinesis Data Streams to stream the data. Use Amazon Kinesis Data Analytics to transform the data. Use Amazon Kinesis Data Firehose to write the data to Amazon S3. Use Amazon Athena to query the transformed data from Amazon S3., Use Amazon Managed Streaming for Apache Kafka (Amazon MSK) to stream the data. Use AWS Glue to transform the data and to write the data to Amazon S3. Use Amazon Athena to query the transformed data from Amazon S3.
## Explanation **Correct Answers: A and B** ### Why A is correct: 1. **Amazon Kinesis Data Streams** is designed for real-time streaming data ingestion 2. **Amazon Kinesis Data Analytics** can transform streaming data in real-time using SQL 3. **Amazon Kinesis Data Firehose** can deliver the transformed data to Amazon S3 4. **Amazon Athena** can query data in S3 using SQL ### Why B is correct: 1. **Amazon MSK** is a managed Apache Kafka service for real-time streaming data 2. **AWS Glue** can transform data (using ETL jobs) and write to S3 3. **Amazon Athena** can query the transformed data in S3 using SQL ### Why C is incorrect: - AWS DMS is for database migration, not real-time streaming data ingestion ### Why D is incorrect: - Amazon RDS query editor cannot query data from S3 directly ### Why E is incorrect: - Amazon RDS query editor cannot query data from S3 directly **Key Points:** - Real-time streaming requires services like Kinesis or MSK - Transformation can be done by Kinesis Data Analytics (real-time SQL) or AWS Glue (batch ETL) - Amazon Athena is the correct service for SQL queries on S3 data - Amazon RDS query editor only works with RDS databases, not S3
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
A company is preparing a new data platform that will ingest real-time streaming data from multiple sources. The company needs to transform the data before writing the data to Amazon S3. The company needs the ability to use SQL to query the transformed data.
Which solutions will meet these requirements? (Choose two.)
A
Use Amazon Kinesis Data Streams to stream the data. Use Amazon Kinesis Data Analytics to transform the data. Use Amazon Kinesis Data Firehose to write the data to Amazon S3. Use Amazon Athena to query the transformed data from Amazon S3.
B
Use Amazon Managed Streaming for Apache Kafka (Amazon MSK) to stream the data. Use AWS Glue to transform the data and to write the data to Amazon S3. Use Amazon Athena to query the transformed data from Amazon S3.
C
Use AWS Database Migration Service (AWS DMS) to ingest the data. Use Amazon EMR to transform the data and to write the data to Amazon S3. Use Amazon Athena to query the transformed data from Amazon S3.
D
Use Amazon Managed Streaming for Apache Kafka (Amazon MSK) to stream the data. Use Amazon Kinesis Data Analytics to transform the data and to write the data to Amazon S3. Use the Amazon RDS query editor to query the transformed data from Amazon S3.
E
Use Amazon Kinesis Data Streams to stream the data. Use AWS Glue to transform the data. Use Amazon Kinesis Data Firehose to write the data to Amazon S3. Use the Amazon RDS query editor to query the transformed data from Amazon S3.