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

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

Question #: 343
Topic #: 1

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

A solutions architect is designing a company’s disaster recovery (DR) architecture. The company has a MySQL database that runs on an Amazon EC2 instance in a private subnet with scheduled backup. The DR design needs to include multiple AWS Regions.

Which solution will meet these requirements with the LEAST operational overhead?

A. Migrate the MySQL database to multiple EC2 instances. Configure a standby EC2 instance in the DR Region. Turn on replication.
B. Migrate the MySQL database to Amazon RDS. Use a Multi-AZ deployment. Turn on read replication for the primary DB instance in the different Availability Zones.
C. Migrate the MySQL database to an Amazon Aurora global database. Host the primary DB cluster in the primary Region. Host the secondary DB cluster in the DR Region.
D. Store the scheduled backup of the MySQL database in an Amazon S3 bucket that is configured for S3 Cross-Region Replication (CRR). Use the data backup to restore the database in the DR Region.

Show Suggested Answer

Suggested Answer: C 🗳️

by jennyka76 at Feb. 21, 2023, 7:56 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

LuckyAro

Highly Voted 1 year, 12 months ago

C: Migrate MySQL database to an Amazon Aurora global database is the best solution because it requires minimal operational overhead. Aurora is a managed service that provides automatic failover, so standby instances do not need to be manually configured. The primary DB cluster can be hosted in the primary Region, and the secondary DB cluster can be hosted in the DR Region. This approach ensures that the data is always available and up-to-date in multiple Regions, without requiring significant manual intervention.

upvoted 11 times

...

AlessandraSAA

Highly Voted 1 year, 11 months ago

Selected Answer: C

A. Multiple EC2 instances to be configured and updated manually in case of DR. B. Amazon RDS=Multi-AZ while it asks to be multi-region C. correct, see comment from LuckyAro D. Manual process to start the DR, therefore same limitation as answer A

upvoted 11 times

...

gulmichamagaun5

Most Recent 1 year, 1 month ago

hello friends, question required: The DR design needs to include multiple AWS Regions, but the correct answer is B, how it comes, because the DR here is on AZ not Different Region so the i would go with D

upvoted 1 times

...

TariqKipkemei

1 year, 4 months ago

Selected Answer: C

LEAST operational overhead = Serverless = Amazon Aurora global database

upvoted 3 times

...

Guru4Cloud

1 year, 5 months ago

Selected Answer: C

Amazon Aurora global database can span and replicate DB Servers between multiple AWS Regions. And also compatible with MySQL.

upvoted 2 times

...

GalileoEC2

1 year, 10 months ago

C, Why B? B is multi zone in one region, C is multi region as it was requested

upvoted 2 times

lucdt4

1 year, 9 months ago

" The DR design needs to include multiple AWS Regions." with the requirement "DR SITE multiple AWS region" -> B is wrong, because it deploy multy AZ (this is not multi region)

upvoted 2 times

...

KZM

1 year, 12 months ago

Amazon Aurora global database can span and replicate DB Servers between multiple AWS Regions. And also compatible with MySQL.

upvoted 4 times

...

LuckyAro

1 year, 12 months ago

With dynamic scaling, the Auto Scaling group will automatically adjust the number of instances based on the actual workload. The target value for the CPU utilization metric is set to 60%, which is the baseline CPU utilization that is noted on each run, indicating that this is a reasonable level of utilization for the workload. This solution does not require any scheduling or forecasting, reducing the operational overhead.

upvoted 1 times