Discuss Amazon SAP-C02 Exam Topic 10 Question 31

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.

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.

Get Premium SAP-C02 Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test

36 comments · newest first

Karan 11 months ago

C is interesting, but I doubt it can handle real-time needs.

Crista 11 months ago

A looks complicated, not sure it's worth the hassle.

Hailey 11 months ago

Wait, can you really replicate writes like that? Sounds risky.

Beckie 11 months ago

I think D is the best choice for real-time updates.

Camellia 12 months ago

Option B seems solid for cross-Region writes.

Whitney 12 months ago

I vaguely recall something about enabling write forwarding in Aurora clusters. Option D might be the right choice, but I need to double-check how that impacts latency.

Ty 1 year ago

I practiced a similar question about Aurora replicas, and I feel like option A could work, but pausing writes seems risky for real-time access.

Bettina 1 year ago

I think option B sounds familiar; it mentions configuring a replica to replicate write queries back. That might help with real-time updates, but I'm not completely confident.

Shawnee 1 year ago

I remember discussing cross-Region replication in class, but I'm not sure if it applies directly here since both regions need to write simultaneously.

Oliva 1 year ago

Option B with a cross-region replica could work, but I'm not sure it would provide the real-time updates the question is asking for. I'll have to think that one through more.

Casie 1 year ago

I'm leaning towards Option A. Creating an Aurora replica and promoting it to a standalone cluster seems like a robust way to handle the cross-region replication.

Alpha 1 year ago

Option D seems like the most straightforward solution to me. Converting to Aurora and enabling write forwarding should meet all the requirements.

Jerry 1 year ago

Hmm, I'm a bit confused by the different options. I'll need to read through them carefully and think through the pros and cons of each approach.

Cyndy 1 year ago

This looks like a tricky database replication question. I'll need to carefully consider the requirements around low latency, real-time updates, and write access from both regions.

Christiane 1 year ago

I'm a little confused about the difference between Bulk API 1.0 and 2.0. I know 2.0 is the newer version, but I'm not sure how the performance and capabilities compare. Maybe I should review the documentation on the two versions before deciding.

Hollis 1 year ago

This question seems straightforward, but I want to double-check my understanding before submitting. Better safe than sorry!

Mozelle 1 year 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!

Nu 1 year ago

↳ replying to Mozelle

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

Shawnda 1 year ago

↳ replying to Mozelle

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

Larue 1 year ago

↳ replying to Mozelle

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.

Teddy 1 year ago

↳ replying to Mozelle

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

Darell 1 year ago

↳ replying to Mozelle

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

Scarlet 1 year ago

↳ replying to Mozelle

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

Cheryl 1 year 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!

Alaine 2 years 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.

Nadine 1 year ago

↳ replying to Alaine

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

Penney 1 year ago

↳ replying to Alaine

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

Magnolia 1 year ago

↳ replying to Alaine

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

Kip 1 year ago

↳ replying to Alaine

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

Rene 1 year ago

↳ replying to Alaine

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

Katina 1 year ago

↳ replying to Alaine

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

Virgie 2 years 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.

Macy 2 years 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.

Jimmie 2 years 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.

Teri 2 years 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.

Fernanda 2 years 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.

Amazon SAP-C02 Exam - Topic 10 Question 31 Discussion