AWS Certified Solutions Architect - Associate
Get started today
Ultimate access to all questions.
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.
Explanation:
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.