Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Amazon SAP-C02 Exam - Topic 10 Question 31 Discussion

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 data. 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?
A) Create 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.
B) Add 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.
C) Copy 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.
D) Convert 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.

Amazon SAP-C02 Exam - Topic 10 Question 31 Discussion

Actual exam question for Amazon's SAP-C02 exam
Question #: 31
Topic #: 10
[All SAP-C02 Questions]

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?

Show Suggested Answer Hide 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:

0/2000 characters
Submit Cancel
Karan
9 months ago
C is interesting, but I doubt it can handle real-time needs.
upvoted 0 times
...
Crista
9 months ago
A looks complicated, not sure it's worth the hassle.
upvoted 0 times
...
Hailey
10 months ago
Wait, can you really replicate writes like that? Sounds risky.
upvoted 0 times
...
Beckie
10 months ago
I think D is the best choice for real-time updates.
upvoted 0 times
...
Camellia
10 months ago
Option B seems solid for cross-Region writes.
upvoted 0 times
...
Whitney
10 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.
upvoted 0 times
...
Ty
11 months 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.
upvoted 0 times
...
Bettina
11 months 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.
upvoted 0 times
...
Shawnee
11 months 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.
upvoted 0 times
...
Oliva
11 months 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.
upvoted 0 times
...
Casie
11 months 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.
upvoted 0 times
...
Alpha
11 months ago
Option D seems like the most straightforward solution to me. Converting to Aurora and enabling write forwarding should meet all the requirements.
upvoted 0 times
...
Jerry
11 months 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.
upvoted 0 times
...
Cyndy
11 months 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.
upvoted 0 times
...
Christiane
11 months 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.
upvoted 0 times
...
Hollis
11 months ago
This question seems straightforward, but I want to double-check my understanding before submitting. Better safe than sorry!
upvoted 0 times
...
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!
upvoted 0 times
Nu
1 year 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
1 year 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
1 year 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
1 year ago
B: Yeah, Option A sounds like the way to go. We need that global data sync party!
upvoted 0 times
...
Darell
1 year 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
1 year ago
A: Option A seems like the best choice. It allows for real-time updates between both regions.
upvoted 0 times
...
...
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!
upvoted 0 times
...
Alaine
1 year 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
1 year 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 year 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 year ago
Logical replication definitely sounds like the way to go for real-time updates without sacrificing data availability.
upvoted 0 times
...
Kip
1 year ago
Logical replication can definitely help in keeping the data synchronized between the two regions.
upvoted 0 times
...
Rene
1 year 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
1 year ago
I agree, Option C seems like the most reliable solution for ensuring data availability and real-time updates.
upvoted 0 times
...
...
Virgie
1 year 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
1 year 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
1 year 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
1 year 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
1 year 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
...

Save Cancel