SAP-C02 · Question #192
SAP-C02 Question #192: Real Exam Question with Answer & Explanation
The correct answer is D: Add a read-only replica to the RDS DB instance. Add an RDS Proxy database proxy.. RDS Proxy makes applications more resilient to database failures by automatically connecting to a standby DB instance while preserving application connections. Using RDS Proxy, you can handle unpredictable surges in database traffic that otherwise might cause issues due to oversu
Question
A gaming company created a game leaderboard by using a Multi-AZ deployment of an Amazon RDS database. The number of users is growing, and the queries to get individual player rankings are getting slower over time. The company expects a surge in users for an upcoming version and wants to optimize the design for scalability and performance. Which solution will meet these requirements?
Options
- AMigrate the database to Amazon DynamoDB. Store the leader different tables.
- BKeep the leaderboard data in the RDS DB instance.
- CStream the leaderboard data by using Amazon Kinesis Data Firehose with an Amazon S3 bucket
- DAdd a read-only replica to the RDS DB instance. Add an RDS Proxy database proxy.
Explanation
RDS Proxy makes applications more resilient to database failures by automatically connecting to a standby DB instance while preserving application connections. Using RDS Proxy, you can handle unpredictable surges in database traffic that otherwise might cause issues due to oversubscribing connections or creating new connections at a fast rate. https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/rds-proxy.html
Community Discussion
No community discussion yet for this question.