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

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

Question #: 148
Topic #: 1

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

A company has migrated an on-premises Oracle database to an Amazon RDS for Oracle Multi-AZ DB instance in the us-east-l Region. A solutions architect is designing a disaster recovery strategy to have the database provisioned in the us-west-2 Region in case the database becomes unavailable in the us-east-1
Region. The design must ensure the database is provisioned in the us-west-2 Region in a maximum of 2 hours, with a data loss window of no more than 3 hours.
How can these requirements be met?

A. Edit the DB instance and create a read replica in us-west-2. Promote the read replica to master in us-west-2 in case the disaster recovery environment needs to be activated.
B. Select the multi-Region option to provision a standby instance in us-west-2. The standby instance will be automatically promoted to master in us-west-2 in case the disaster recovery environment needs to be created.
C. Take automated snapshots of the database instance and copy them to us-west-2 every 3 hours. Restore the latest snapshot to provision another database instance in us-west-2 in case the disaster recovery environment needs to be activated.
D. Create a multimaster read/write instances across multiple AWS Regions. Select VPCs in us-east-1 and us-west-2 to make that deployment. Keep the master read/write instance in us-west-2 available to avoid having to activate a disaster recovery environment.

Show Suggested Answer

Suggested Answer: A 🗳️

by Paitan at Aug. 11, 2020, 8:26 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

Submit Cancel

apeyrat

Highly Voted 3 years, 9 months ago

A: Amazon RDS for Oracle Now Supports Managed Disaster Recovery and Data Proximity with Cross-region Read Replicas. See: https://aws.amazon.com/about-aws/whats-new/2019/11/amazon-rds-for-oracle-now-supports-managed-disaster-recovery-and-data-proximity-with-cross-region-read-replicas/

upvoted 44 times

geekmichael

3 years, 9 months ago

I think a Read Replica cannot deal the write requests to DB in the event of the DB failure.

upvoted 4 times

dheerajg6

3 years, 9 months ago

but it will be up to date and has to be promoted to master if the primary has failed.

upvoted 11 times

...

IdrisAWS

3 years, 8 months ago

Based on your link shared - Amazon RDS for Oracle makes it easy to create physical standby DB instances in different AWS Regions from the primary DB instance So it should be B

upvoted 3 times

Alcpt

3 years, 6 months ago

read the link above. its A.

upvoted 1 times

...

noahsark

3 years, 8 months ago

Read replica for Multi Region https://aws.amazon.com/about-aws/whats-new/2019/11/amazon-rds-for-oracle-now-supports-managed-disaster-recovery-and-data-proximity-with-cross-region-read-replicas/ Standby instance is for Single Region - Multi AZ https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Concepts.MultiAZ.html

upvoted 6 times

...

JohnnyS20

Highly Voted 3 years, 9 months ago

ELIMINATING THE ANSWERS The easiest to remove is option C. Snapshots are only useful for backups but for a DR strategy, it is not ideal. If we use snapshots as DR strategy and the primary region goes down, we'll have to restore the DB on the second region. This is just too much effort. You should already have an established secondary database on a second region. The next one to eliminate is D. Amazon RDS doesn't support multimaster read/write instances across regions. The only database that has this feature is DynamoDB. This leaves us with options A and B.

upvoted 34 times

examtopicsHaru

3 years, 8 months ago

I believe the answer is A But letting you know that Aurora supports multi master read/write instance with fixed number 6 clusters. https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-multi-master.html

upvoted 1 times

...

Kopa

3 years, 8 months ago

It doesnt say with little amount of effort. Answer C works also with RTO and RPO required, anyway A looks more correct.

upvoted 3 times

...

JohnnyS20

3 years, 9 months ago

For option B: You'll notice that it has "STANDBY INSTANCE". Standby instance, by AWS's definition is an instance that is in a secondary AZ. Thus you only use standby instances in a Multi-AZ setup, not regional. If you'll read the question again, the requirement is for a secondary database in another region Now to verify that option A does solve the requirement - Read Replicas - RDS can have read replicas in other region. This read replica/s can be promoted to master DB when the primary region goes down. Correct answer: A

upvoted 99 times

kaush

3 years, 9 months ago

Precise explanation , HA RDS standby support within Region another AZ hence Answer is A

upvoted 2 times

...

Akogun

3 years, 8 months ago

Nice explanation

upvoted 1 times

...

noahsark

3 years, 8 months ago

Agree with A: Read only for Multi Region https://aws.amazon.com/about-aws/whats-new/2019/11/amazon-rds-for-oracle-now-supports-managed-disaster-recovery-and-data-proximity-with-cross-region-read-replicas/ Standby instance is for Single Region - Multi AZ https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Concepts.MultiAZ.html

upvoted 5 times

...

Load full discussion...

...

Uzbekistan

Most Recent 1 year, 3 months ago

Selected Answer: C

C. Take automated snapshots of the database instance and copy them to us-west-2 every 3 hours. Restore the latest snapshot to provision another database instance in us-west-2 in case the disaster recovery environment needs to be activated. Explanation: Automated snapshots can be scheduled to capture the database state regularly, ensuring minimal data loss in case of a disaster. By copying snapshots to the us-west-2 Region every 3 hours, the latest data can be quickly restored in the alternate Region. Restoring from a snapshot is a relatively fast process, and it allows for provisioning a new database instance in the us-west-2 Region within the required 2-hour timeframe. This approach also provides flexibility in managing costs, as resources are only provisioned in the backup Region when needed during a disaster recovery scenario.

upvoted 1 times

...

BECAUSE

2 years, 1 month ago

Selected Answer: A

A is the answer

upvoted 1 times

...

Jesuisleon

2 years, 1 month ago

Selected Answer: A

C is WRONG because automated snapshot of db instance just occurred daily although you can specify time windows. You can't specify 3 hours per days.

upvoted 1 times

...

Curious76

2 years, 9 months ago

Selected Answer: B

https://aws.amazon.com/blogs/database/readable-standby-instances-in-amazon-rds-multi-az-deployments-a-new-high-availability-option/

upvoted 2 times

...

Fyssy

2 years, 10 months ago

Selected Answer: A

Standby instance cannot be multi-region

upvoted 2 times

...

manngupta007

2 years, 10 months ago

https://aws.amazon.com/blogs/database/managed-disaster-recovery-with-amazon-rds-for-oracle-cross-region-automated-backups-part-1/

upvoted 1 times

...

envest

2 years, 10 months ago

IMO: A; all methods satisfy time restrains, it's about technial feasibilty: A: not designed for (async) but feasible with manual failover and some minutes B: false: right design, but env (region, VPC, SG, endpoints,...) creation before replicas C: false: Auto snapshot not feasible for sharing & cross region. D: false

upvoted 1 times

...

naveenagurjara

3 years ago

Selected Answer: A

https://aws.amazon.com/about-aws/whats-new/2019/11/amazon-rds-for-oracle-now-supports-managed-disaster-recovery-and-data-proximity-with-cross-region-read-replicas/

upvoted 1 times

...

Fcpoultry

3 years, 2 months ago

The Oracle DB engine supports replica databases in mounted mode. A mounted replica doesn't accept user connections and so can't serve a read-only workload. The primary use for mounted replicas is cross-Region disaster recovery. For more information, see Working with Oracle replicas for Amazon RDS. So, B is correct.

upvoted 1 times

...

Karthikeyan_nick

3 years, 2 months ago

CORRECT A WRONG B: RDS Multi AZ always replicate to a standby instance in different AZ, not in a different region. In case of infra failure AWS RDS performs auto failover to the standby instance. So that you can resume database operation as soon as the failover is completed. WRONG C: Snapshots are only useful for backups but for a DR strategy, it is not ideal. WRONG D: Amazon RDS doesn't support multimaster read/write instances across regions.The only database that has this feature is DynamoDB.

upvoted 2 times

...

examJack

3 years, 3 months ago

Selected Answer: A

Creating a read replica in a different AWS Region https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ReadRepl.XRgn.html With Amazon RDS, you can create a MariaDB, MySQL, Oracle, or PostgreSQL read replica in a different AWS Region from the source DB instance. Creating a cross-Region read replica isn't supported for SQL Server on Amazon RDS. You create a read replica in a different AWS Region to do the following: - Improve your disaster recovery capabilities. - Scale read operations into an AWS Region closer to your users. - Make it easier to migrate from a data center in one AWS Region to a data center in another AWS Region.

upvoted 1 times

...

mgari

3 years, 3 months ago

Selected Answer: A

aaaaaa

upvoted 1 times

...

done7

3 years, 4 months ago

Selected Answer: A

RDS+multi region --> RR

upvoted 1 times

...

SuhasH

3 years, 5 months ago

Selected Answer: C

Oracle DB is licensed so Organization is Ok with delayed recovery as per question , this makes C a good choice.

upvoted 1 times

...

Rob_q

3 years, 5 months ago

Selected Answer: C

Ans=C As the question leads to 2 hours of recovery and 3 hours of data loss, and only asks to be replaced in a specific region, it seems they are detailing characteristics of dr with automated backups: https://aws.amazon.com/blogs/database/implementing-a-disaster-recovery-strategy-with-amazon-rds/

upvoted 4 times

...

Load full discussion...