Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
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

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

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 🗳️

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Guru4Cloud
Highly Voted 1 year, 3 months 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 8 times
...
awsgeek75
Most Recent 10 months, 2 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 2 times
...
TariqKipkemei
1 year 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 1 times
...
potomac
1 year ago
Selected Answer: C
Aurora is a MySQL-compatible relational database service
upvoted 1 times
...
mrsoa
1 year, 3 months ago
Selected Answer: C
Aurora is better in autoscaling then RDS
upvoted 1 times
...
Bmaster
1 year, 3 months 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 1 times
Eminenza22
1 year, 3 months 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
Loading ...