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

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

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

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

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

A company wants to migrate its MySQL database from on premises to AWS. The company recently experienced a database outage that significantly impacted the business. To ensure this does not happen again, the company wants a reliable database solution on AWS that minimizes data loss and stores every transaction on at least two nodes.
Which solution meets these requirements?

  • A. Create an Amazon RDS DB instance with synchronous replication to three nodes in three Availability Zones.
  • B. Create an Amazon RDS MySQL DB instance with Multi-AZ functionality enabled to synchronously replicate the data.
  • C. Create an Amazon RDS MySQL DB instance and then create a read replica in a separate AWS Region that synchronously replicates the data.
  • D. Create an Amazon EC2 instance with a MySQL engine installed that triggers an AWS Lambda function to synchronously replicate the data to an Amazon RDS MySQL DB instance.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by sadhou2004 at Nov. 2, 2020, 6:34 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

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
sadhou2004
Highly Voted 3 years, 8 months ago
Correct answer : B
upvoted 41 times
...
sctmp
Highly Voted 3 years, 8 months ago
A. Sounds wrong, you'll have to enable Multi-AZ deployment. B. Sounds about right. C. Read replicas don't help or make the DB reliable. D. Nop, EC2 is not recommended.
upvoted 23 times
...
naveenagurjara
Most Recent 2 years, 11 months ago
Selected Answer: B
RDS Multi AZ now supports two Standby Reads in two other AZs (in total 3 az including Master).
upvoted 2 times
...
Lakhsmi
3 years, 2 months ago
Selected Answer: B
Multi AZ for HA of database.
upvoted 1 times
...
osel
3 years, 4 months ago
Selected Answer: B
A incorrect bcos the 3 RDS DB instances will be independently separate running DB. B correct bcos RDS DB with Multi-AZ mode will launch a Standby Replica in another AZ for HA which performs Sync Repl with Pri DB. C incorrect bcos RDS Read Replica does Async Repl (not Sync Repl) with Pri DB. D incorrect bcos running RDS DB on EC2 is not scalable.
upvoted 2 times
...
Alexey79
3 years, 4 months ago
“at least two nodes” In Multi-AZ, one node / RDS replicated across AZs. With RDS replica, two nodes / RDS Instances.
upvoted 1 times
...
zesss24
3 years, 4 months ago
Selected Answer: B
B for sure
upvoted 1 times
...
Paul_101
3 years, 5 months ago
Selected Answer: B
Sorry I meant to say B -------------- Q: What does Amazon RDS manage on my behalf? Amazon RDS manages the work involved in setting up a relational database: from provisioning the infrastructure capacity you request to installing the database software. Once your database is up and running, Amazon RDS automates common administrative tasks such as performing backups and patching the software that powers your database. With optional Multi-AZ deployments, Amazon RDS also manages synchronous data replication across Availability Zones with automatic failover. https://aws.amazon.com/rds/faqs/
upvoted 1 times
...
Paul_101
3 years, 5 months ago
Selected Answer: C
I'm going with C: -------------- Q: What does Amazon RDS manage on my behalf? Amazon RDS manages the work involved in setting up a relational database: from provisioning the infrastructure capacity you request to installing the database software. Once your database is up and running, Amazon RDS automates common administrative tasks such as performing backups and patching the software that powers your database. With optional Multi-AZ deployments, Amazon RDS also manages synchronous data replication across Availability Zones with automatic failover. https://aws.amazon.com/rds/faqs/
upvoted 1 times
...
andras
3 years, 7 months ago
B does not protect against a regional outage. Read replicas could be promoted to "master" in the other region in case of a regional outage. It's C
upvoted 3 times
bodysnatcher
3 years, 7 months ago
i wish people didnt answer unless they are sure..Its B.
upvoted 4 times
...
ssSsEclipse
3 years, 7 months ago
the question is about database outage, not regional outage, so it is not the thing we should take care of. With Multi-AZ enabled, failover to a standby instance is fully automatic by AWS, while with read replicas, you will need to manually promote to master, so I think Multi-AZ is more suitable in this case
upvoted 7 times
Vizz5585
3 years, 7 months ago
Moreover the question states "stores every transaction on at least two nodes." which is satisfied by B.
upvoted 2 times
...
orbpig
2 years, 7 months ago
from "the company wants a reliable database solution on AWS that minimizes data loss and stores every transaction on at least two nodes" we can see that the question is about availability, so regional seperating the DB instance is a consideration.
upvoted 1 times
...
orbpig
2 years, 7 months ago
the question cares about availability, not care about the auto or manual restore of a DB.
upvoted 1 times
...
...
patriktre
3 years, 7 months ago
ans C is talking about synchronous replication to read replicas, but read replicas uses asynchronous replication. correct ans should be B
upvoted 13 times
orbpig
2 years, 7 months ago
asynchronous or synchronous can be set by config
upvoted 1 times
...
...
...
syu31svc
3 years, 7 months ago
100% is B
upvoted 5 times
...
KK_uniq
3 years, 7 months ago
B for sure
upvoted 3 times
...
Yogi
3 years, 7 months ago
Ans=B. Create an Amazon RDS MySQL DB instance with Multi-AZ functionality enabled to synchronously replicate the data.
upvoted 3 times
...
bleble00001
3 years, 7 months ago
"To ensure database outage does not happen again.." ~> If all the synchronous replicas are in a single region, the said goal cannot be achieved. Why? What if the entire region goes down?
upvoted 1 times
lehoang15tuoi
3 years, 7 months ago
For this exam "high availability" is multi-AZ and more. So multi-region is good but not absolutely required
upvoted 1 times
...
AVINASH_AWS
3 years, 7 months ago
what if entire universe sink in different galaxy .. don't over assume.
upvoted 15 times
...
...
anpt
3 years, 7 months ago
BBBBBBBBBBBBBB
upvoted 8 times
...
venh123
3 years, 7 months ago
B is correct
upvoted 1 times
...
aguy9
3 years, 8 months ago
Answer is B. RDS Multi AZ synchronously replicates the data
upvoted 1 times
...
Load full discussion...
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