A company hosts a three-tier web application with a PostgreSQL database that stores document metadata. Documents are stored in Amazon S3. Documents are usually written only once but updated frequently. A monthly reporting process searches metadata using relational queries and takes several hours; the reporting must not block document modifications or additions. Implement a solution to speed up reporting with the least change to application code. Which solution meets these requirements?

The correct solution is to set up a new Amazon Aurora PostgreSQL DB cluster with an Aurora Replica and direct reporting queries to the replica. Aurora Replicas are designed for high-performance read scaling and are fully crash-consistent with the primary instance, making them ideal for offloading read-heavy workloads like reporting without impacting the primary database's write performance. This approach requires minimal application code changes as it uses the same PostgreSQL compatibility. Incorrect options: Amazon DocumentDB (with MongoDB compatibility) is a NoSQL database and would require significant application code changes to migrate the existing PostgreSQL metadata. An