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

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