Amazon Exam SAP-C02 Topic 10 Question 31 Discussion

Actual exam question for Amazon's SAP-C02 exam

Question #: 31
Topic #: 10

A company has deployed its database on an Amazon RDS for MySQL DB instance in the us-east-1 Region. The company needs to make its data available to customers in Europe. The customers in Europe must have access to the same data as customers in the United States (US) and will not tolerate high application latency or stale dat

a. The customers in Europe and the customers in the US need to write to the database. Both groups of customers need to see updates from the other group in real time.

Which solution will meet these requirements?

ACreate an Amazon Aurora MySQL replica of the RDS for MySQL DB instance. Pause application writes to the RDS DB instance. Promote the Aurora Replica to a standalone DB cluster. Reconfigure the application to use the Aurora database and resume writes. Add eu-west-1 as a secondary Region to the 06 cluster. Enable write forwarding on the DB cluster. Deploy the application in eu-west-1. Configure the application to use the Aurora MySQL endpoint in eu- west-1.

BAdd a cross-Region replica in eu-west-1 for the RDS for MySQL DB instance. Configure the replica to replicate write queries back to the primary DB instance. Deploy the application in eu-west-1. Configure the application to use the RDS for MySQL endpoint in eu-west-1.

CCopy the most recent snapshot from the RDS for MySQL DB instance to eu-west-1. Create a new RDS for MySQL DB instance in eu-west-1 from the snapshot. Configure MySQL logical replication from us-east-1 to eu-west-1. Enable write forwarding on the DB cluster. Deploy the application in eu-west-1. Configure the application to use the RDS for MySQL endpoint in eu-west-1.

DConvert the RDS for MySQL DB instance to an Amazon Aurora MySQL DB cluster. Add eu-west-1 as a secondary Region to the DB cluster. Enable write forwarding on the DB cluster. Deploy the application in eu-west-1. Configure the application to use the Aurora MySQL endpoint in eu-west-1.

Show Suggested Answer

Suggested Answer: A, E

Configuring read replicas for Amazon RDS MySQL and using the single reader endpoint in the web application can significantly reduce the load on the backend database tier, improving overall application performance. Additionally, implementing an Amazon ElastiCache cluster between the web application and RDS MySQL instances can further reduce database load by caching frequently accessed data, thereby enhancing the application's resilience and scalability. These changes address the root cause of the outage by alleviating the database tier's high load and preventing similar issues in the future.

by Malcolm at May 18, 2024, 12:48 PM

Limited Time Offer

25%

Off

Get Premium SAP-C02 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Mozelle

2 months ago

Wait, they need to write to the database in both regions? Looks like someone's trying to create a global data sync party over here. Time to break out the disco ball!

upvoted 0 times

Nu

3 days ago

C: I agree, Option A is the most efficient solution for keeping the data in sync between the US and Europe.

upvoted 0 times

...

Shawnda

5 days ago

C: I agree, A is the way to go. Copying the snapshot and setting up logical replication will ensure data consistency between the regions.

upvoted 0 times

...

Larue

7 days ago

B: Yeah, A seems like the most efficient solution. They can pause writes to the RDS instance and promote the Aurora replica for better performance.

upvoted 0 times

...

Teddy

7 days ago

B: Yeah, Option A sounds like the way to go. We need that global data sync party!

upvoted 0 times

...

Darell

8 days ago

A: A sounds like the best option. They need to create an Aurora MySQL replica and configure write forwarding for real-time updates.

upvoted 0 times

...

Scarlet

22 days ago

A: Option A seems like the best choice. It allows for real-time updates between both regions.

upvoted 0 times

...

Cheryl

2 months ago

Option A looks like overkill. Why bother with a full Aurora migration when a cross-Region replica should do the trick? Let's keep it simple!

upvoted 0 times

...

Alaine

2 months ago

This is a tricky one, but I think Option C is the way to go. Copying the snapshot and setting up logical replication gives us the best of both worlds - data availability and real-time updates.

upvoted 0 times

Nadine

28 days ago

It's important to consider all the options carefully to make sure we choose the best solution for our specific requirements.

upvoted 0 times

...

Penney

1 months ago

Copying the snapshot to create a new instance in eu-west-1 also provides a good backup plan in case of any issues.

upvoted 0 times

...

Magnolia

1 months ago

Logical replication definitely sounds like the way to go for real-time updates without sacrificing data availability.

upvoted 0 times

...

Kip

1 months ago

Logical replication can definitely help in keeping the data synchronized between the two regions.

upvoted 0 times

...

Rene

1 months ago

I agree, Option C seems like the most reliable solution for keeping data in sync between the US and Europe.

upvoted 0 times

...

Katina

2 months ago

I agree, Option C seems like the most reliable solution for ensuring data availability and real-time updates.

upvoted 0 times

...

Virgie

2 months ago

I'm leaning towards Option B. Adding a cross-Region replica and configuring replication back to the primary instance is a simpler approach that avoids the need for a full database migration.

upvoted 0 times

...

Macy

2 months ago

Option D seems like the best solution. Migrating to Aurora MySQL and enabling write forwarding will ensure real-time data availability across regions without sacrificing performance or data consistency.

upvoted 0 times

...

Jimmie

2 months ago

I'm not sure about option A. I think option D could also work well by converting the RDS for MySQL DB instance to an Aurora MySQL DB cluster.

upvoted 0 times

...

Teri

2 months ago

I agree with Fernanda. Option A seems to be the most efficient way to meet the requirements and ensure real-time updates for both US and European customers.

upvoted 0 times

...

Fernanda

2 months ago

I think option A is the best solution because it involves creating an Aurora MySQL replica and promoting it to a standalone DB cluster.

upvoted 0 times

...