Exam AWS Certified Solutions Architect - Associate SAA-C02 All Questions

View all questions & answers for the AWS Certified Solutions Architect - Associate SAA-C02 exam

Exam AWS Certified Solutions Architect - Associate SAA-C02 topic 1 question 821 discussion

Exam question from Amazon's AWS Certified Solutions Architect - Associate SAA-C02

Question #: 821
Topic #: 1

[All AWS Certified Solutions Architect - Associate SAA-C02 Questions]

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.

Show Suggested Answer

Suggested Answer: AB 🗳️

by stanleyjos at Sept. 27, 2022, 3:06 p.m.

Disclaimers:

- ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
- Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Submit Cancel

stanleyjos

Highly Voted 2 years, 8 months ago

Selected Answer: AB

I think A and B are correct. The AWS Database Migration Service (AWS DMS) cannot read the data in real-time.

upvoted 5 times

...

Michael_Li

Most Recent 1 year, 5 months ago

Answer A & B For big data analysis, especially with large volumes of unstructured or semi-structured data RDS is not suitable, so rule out D & E C is not correct because AWS Database Migration Service is not suitable for real-time streaming

upvoted 1 times

...

BECAUSE

1 year, 11 months ago

Selected Answer: AB

A and B are the answers

upvoted 1 times

...

yama234

2 years, 1 month ago

AB are correct E is wrong. Amazon RDS query editor can not query data from Amazon S3

upvoted 2 times

...

TECHNOWARRIOR

2 years, 3 months ago

I think A and B are correct. The AWS Database Migration Service (AWS DMS) cannot read the data in real-time. EMR do not handle load with SQL query

upvoted 2 times

...

sundubu

2 years, 7 months ago

Selected Answer: BE

I think B,E. AWS Kinesis Analytics doesn't transforming data. Glue do it.

upvoted 2 times

sassy2023

2 years, 4 months ago

ok BE. my head hurts

upvoted 1 times

...

TungPham

2 years, 2 months ago

https://docs.aws.amazon.com/kinesisanalytics/latest/dev/examples-transforming.html AWS Kinesis Analytics can transforming data

upvoted 1 times

...

envest

2 years, 7 months ago

agree, although KDA is a bit unsure (might need an transform app) & might therefore tend towards near real-time. RDS query doesnt work with S3 & DMS isnt suitable.

upvoted 2 times

...