AWS Certified Solutions Architect - Associate
Get started today
Ultimate access to all questions.
Deep dive into the quiz with AI chat providers.
We prepare a focused prompt with your quiz and certificate details so each AI can offer a more tailored, in-depth explanation.
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.)
Other
Community
UAnonymous
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.
Explanation:
Explanation
Correct Answers: A and B
Why A is correct:
- Amazon Kinesis Data Streams is designed for real-time streaming data ingestion
- Amazon Kinesis Data Analytics can transform streaming data in real-time using SQL
- Amazon Kinesis Data Firehose can deliver the transformed data to Amazon S3
- Amazon Athena can query data in S3 using SQL
Why B is correct:
- Amazon MSK is a managed Apache Kafka service for real-time streaming data
- AWS Glue can transform data (using ETL jobs) and write to S3
- 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
Comments
Loading comments...