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 551 discussion

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

Question #: 551
Topic #: 1

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

A company needs to build a reporting solution on AWS. The solution must support SQL queries that data analysts run on the data. The data analysts will run fewer than 10 total queries each day. The company generates 3 GB of new data daily in an on-premises relational database. This data needs to be transferred to AWS to perform reporting tasks.
What should a solutions architect recommend to meet these requirements at the LOWEST cost?

A. Use AWS Database Migration Service (AWS DMS) to replicate the data from the on-premises database into Amazon S3. Use Amazon Athena to query the data.
B. Use an Amazon Kinesis Data Firehose delivery stream to deliver the data into an Amazon Elasticsearch Service (Amazon ES) cluster. Run the queries in Amazon ES.
C. Export a daily copy of the data from the on-premises database. Use an AWS Storage Gateway file gateway to store and copy the export into Amazon S3. Use an Amazon EMR cluster to query the data.
D. Use AWS Database Migration Service (AWS DMS) to replicate the data from the on-premises database and load it into an Amazon Redshift cluster. Use the Amazon Redshift cluster to query the data.

Show Suggested Answer

Suggested Answer: A 🗳️

by BlassArun at Dec. 29, 2021, 5:09 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

tdipen22

Highly Voted 3 years, 7 months ago

Selected Answer: A

It has to be A. S3 cheaper than Redshift anyday. And Redshift use case is generally for high data volume(Petabyte scales) of data. Here we are talking about few gigs only. Also, Athena is serverless and you don't pay for infrastructure. You only pay for the query that you do.

upvoted 23 times

ahaz

3 years ago

How would you put relational database data into S3?? The only possible answer seems to be D, even though it is more expensive than S3.

upvoted 3 times

enzomv

2 years, 4 months ago

https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Target.S3.html

upvoted 2 times

...

BrijMohan08

Highly Voted 3 years, 2 months ago

Selected Answer: D

A - No, you cannot migrate RDS DB to the S3 bucket. S3 is an object-store. B and C will not work D - Only option left, not the cheapest but I don't see any other feasible options.

upvoted 6 times

mr_jah

3 years, 1 month ago

https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Target.S3.html

upvoted 4 times

...

StacyY

Most Recent 2 years ago

It shall be A. Because AWS DMS supports database to S3 transfer.

upvoted 1 times

...

Mia2009687

2 years, 2 months ago

A: S3 with Amazon Athena can do simply queries. As they run fewer than 10 total queries each day, this is not a query intensive system. S3 with Amazon Athena is much cheaper than Amazon Redshift cluster.

upvoted 1 times

...

rac_sp

2 years, 10 months ago

Selected Answer: D

Dms is not even capable to transfer to S3. The a option is impossible to happen.

upvoted 1 times

...

jw1806

2 years, 10 months ago

Selected Answer: A

Athena seems to be a good choice for the cost saving.

upvoted 1 times

...

andersonneo

2 years, 12 months ago

Selected Answer: A

Any who thinks its not A .. should read this .. AWS Database Migration Service supports homogeneous migrations such as Oracle to Oracle, as well as heterogeneous migrations between different database platforms, such as Oracle or Microsoft SQL Server to Amazon Aurora. With AWS Database Migration Service, you can also continuously replicate data with low latency from any supported source to any supported target. For example, you can replicate from multiple sources to Amazon Simple Storage Service (Amazon S3) to build a highly available and scalable data lake solution. You can also consolidate databases into a petabyte-scale data warehouse by streaming data to Amazon Redshift. Learn more about the supported source and target databases. https://aws.amazon.com/dms/

upvoted 4 times

...

michaelbaib

3 years, 3 months ago

why not b

upvoted 1 times

derekurizar

3 years, 2 months ago

This is because near real-time data is not required, they will just run 10 queries per day so the solution will be overkill

upvoted 2 times

...

Ikenna198

3 years, 4 months ago

D is correct!!! S3 is cheap but its no SQL

upvoted 1 times

serdar55

3 years, 4 months ago

you can do sql query using Athena

upvoted 3 times

...

rvnz45

3 years, 4 months ago

S3 only to transfer SQL data from on-premises to AWS area. its cheaper than redshift. and Athena support SQL queries for data analyst to refine the data A is the answer

upvoted 2 times

derekurizar

3 years, 2 months ago

DMS doesn't have the feature to migrate from On-prem SQL to S3.... answer is D

upvoted 1 times

natnette

3 years, 2 months ago

S3 can be source or target for DMS

upvoted 1 times

...

naveenagurjara

3 years, 1 month ago

Please check this out https://aws.amazon.com/premiumsupport/knowledge-center/s3-bucket-dms-target/

upvoted 1 times

...

Load full discussion...

...

tin2022

3 years, 7 months ago

When it comes to day-to-day queries, complex joins, and bigger aggregations, Redshift is the preferred choice. https://blog.panoply.io/an-amazonian-battle-comparing-athena-and-redshift

upvoted 1 times

...