What should the database specialist do to meet these requirements?
Create a read replica of the DB instance. Configure the reports to connect to the replication instance endpoint.
Create a read replica of the DB instance. Configure the application and reports to connect to the cluster endpoint.
Enable Multi-AZ deployment. Configure the reports to connect to the standby replica.
Enable Multi-AZ deployment. Configure the application and reports to connect to the cluster endpoint.
Explanations:
Creating a read replica and configuring the reports to use the replica endpoint offloads read traffic, reducing the load on the primary DB instance.
The application should not be connected to the read replica; it should only be used for reporting purposes, which would create unnecessary load on the replica.
Multi-AZ deployment provides high availability and failover, but it does not improve performance for read-heavy workloads. The reports should use a read replica, not a standby instance.
The cluster endpoint is used for read-write access in a Multi-AZ deployment and would not offload reporting queries to improve performance. Reports should connect to a read replica.
I would say the answer is:
Create a read replica of the DB instance. Configure the reports to connect to the replication instance endpoint.
I reckon the answer is:
Create a read replica of the DB instance. Configure the reports to connect to the replication instance endpoint.