Answer-first summary for fast verification
Answer: Implement an Amazon Aurora PostgreSQL DB cluster with an Aurora Replica to offload report queries.
The correct answer is B. Using Amazon Aurora with a PostgreSQL-compatible DB cluster that includes an Aurora Replica is an ideal solution because it minimally changes the application code while optimizing read operations. Aurora Replicas are designed to handle high read traffic and can be used for reporting without affecting the primary database's performance. This approach offloads the reporting queries to the read replica, ensuring that the reporting process does not interfere with the regular updates or additions of documents.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
A company uses a PostgreSQL database in a three-tier web application to store document metadata, which is searched for key terms in monthly reports. The documents themselves are stored in Amazon S3, written once but frequently updated. The current reporting process, based on relational queries, is slow and must be optimized without hindering document updates or additions. Identify the solution requiring minimal changes to the application code to accelerate the reporting process.
A
Migrate to Amazon DocumentDB with MongoDB compatibility, leveraging a read replica for report generation.
B
Implement an Amazon Aurora PostgreSQL DB cluster with an Aurora Replica to offload report queries.
C
Adopt a Multi-AZ Amazon RDS for PostgreSQL instance, directing report queries to the secondary node to preserve primary node performance.
D
Create an Amazon DynamoDB table for document storage, with fixed write capacity and auto-scaling read capacity to manage reports.
No comments yet.