
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.