New Year Sale 2026! 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

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
3 months ago
C is interesting, but I doubt it can handle real-time needs.
upvoted 0 times
...
Crista
3 months ago
A looks complicated, not sure it's worth the hassle.
upvoted 0 times
...
Hailey
3 months ago
Wait, can you really replicate writes like that? Sounds risky.
upvoted 0 times
...
Beckie
4 months ago
I think D is the best choice for real-time updates.
upvoted 0 times
...
Camellia
4 months ago
Option B seems solid for cross-Region writes.
upvoted 0 times
...
Whitney
4 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
4 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
4 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
5 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
5 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
5 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
5 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
5 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
5 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
5 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
5 months ago
This question seems straightforward, but I want to double-check my understanding before submitting. Better safe than sorry!
upvoted 0 times
...
Mozelle
10 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
8 months 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
8 months 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
9 months 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
9 months ago
B: Yeah, Option A sounds like the way to go. We need that global data sync party!
upvoted 0 times
...
Darell
9 months 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
9 months ago
A: Option A seems like the best choice. It allows for real-time updates between both regions.
upvoted 0 times
...
...
Cheryl
10 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
10 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
9 months 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
9 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
9 months ago
Logical replication definitely sounds like the way to go for real-time updates without sacrificing data availability.
upvoted 0 times
...
Kip
10 months ago
Logical replication can definitely help in keeping the data synchronized between the two regions.
upvoted 0 times
...
Rene
10 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
10 months ago
I agree, Option C seems like the most reliable solution for ensuring data availability and real-time updates.
upvoted 0 times
...
...
Virgie
10 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
10 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
10 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
11 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
11 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
...

Save Cancel