ExamTopics Logo
Mail Us[email protected]
Menu
Amazon Discussions
exam questions

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

View all questions & answers for the AWS Certified Solutions Architect - Associate SAA-C03 exam
Go to Exam

Exam AWS Certified Solutions Architect - Associate SAA-C03 topic 1 question 565 discussion

Exam question from Amazon's AWS Certified Solutions Architect - Associate SAA-C03
Question #: 565
Topic #: 1
[All AWS Certified Solutions Architect - Associate SAA-C03 Questions]

A company has an on-premises MySQL database that handles transactional data. The company is migrating the database to the AWS Cloud. The migrated database must maintain compatibility with the company's applications that use the database. The migrated database also must scale automatically during periods of increased demand.

Which migration solution will meet these requirements?

  • A. Use native MySQL tools to migrate the database to Amazon RDS for MySQL. Configure elastic storage scaling.
  • B. Migrate the database to Amazon Redshift by using the mysqldump utility. Turn on Auto Scaling for the Amazon Redshift cluster.
  • C. Use AWS Database Migration Service (AWS DMS) to migrate the database to Amazon Aurora. Turn on Aurora Auto Scaling.
  • D. Use AWS Database Migration Service (AWS DMS) to migrate the database to Amazon DynamoDB. Configure an Auto Scaling policy.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by Bmaster at Aug. 2, 2023, 2:39 a.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

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Guru4Cloud
Highly Voted 1 year, 1 month ago
Selected Answer: C
The key reasons are: DMS provides an easy migration path from MySQL to Aurora while minimizing downtime. Aurora is a MySQL-compatible relational database service that will maintain compatibility with the company's applications. Aurora Auto Scaling allows the database to automatically scale up and down based on demand to handle increased workloads. RDS MySQL (Option A) does not scale as well as the Aurora architecture. Redshift (Option B) is for analytics, not transactional data, and may not be compatible. DynamoDB (Option D) is a NoSQL datastore and lacks MySQL compatibility.
upvoted 9 times
...
awsgeek75
Most Recent 8 months, 3 weeks ago
Selected Answer: C
A is wrong as you cannot use native MySQL tools for migration. Happy to be corrected though! B Redshift is not compatible with MySQL D is DynamoDB C Aurora MySQL is compatible and supports auto scaling
upvoted 3 times
...
TariqKipkemei
10 months, 2 weeks ago
Selected Answer: C
on-premises MySQL database, transactional data, maintain compatibility, scale automatically = Amazon Aurora migrating the database to the AWS Cloud = AWS Database Migration Service
upvoted 2 times
...
potomac
10 months, 4 weeks ago
Selected Answer: C
Aurora is a MySQL-compatible relational database service
upvoted 2 times
...
mrsoa
1 year, 1 month ago
Selected Answer: C
Aurora is better in autoscaling then RDS
upvoted 2 times
...
Bmaster
1 year, 1 month ago
C is correct A is incorrect. RDS for MySQL does not scale automatically during periods of increased demand. B is incorrect. Redshift is used for data sharing purposes. D is incorrect. you muse change application codes.
upvoted 2 times
Eminenza22
1 year, 1 month ago
Amazon RDS now supports Storage Auto Scaling
upvoted 2 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago