Q8 — AWS SAA-C03 Ch.10

Question 8 of 100 | ← Chapter 10

Q608. A company wants to provide data scientists with near real-time read-only access to the company's production Amazon RDS for PostgreSQL database. The database is currently configured as a Single-AZ database. The data scientists use complex queries that will not affect the production database. The company needs a solution that is highly available.Which solution will meet these requirements MOST cost-effectively?

Correct Answer: D. Change the setup from a Single-AZ to a Multi-AZ cluster deployment with two readable standby instances. Provide read endpoints to the data scientists.

Explanation

The correct answer to this question is: D. Change the setup from a Single-AZ to a Multi-AZ cluster deployment with two readable standby instances. Provide read endpoints to the data scientists. Explanation: Option D suggests changing the setup from a Single-AZ to a Multi-AZ cluster deployment with two readable standby instances and providing read endpoints to the data scientists. Advantages of this solution include: \1. High Availability: By changing the deployment to a Multi-AZ cluster, the database will have synchronous replication to a standby instance in a different Availability Zone. This ensures automatic failover in the event of an infrastructure or Availability Zone issue, providing high availability for both production and the readable standby instances. \2. Readable Standby Instances: Adding two readable standby instances allows the data scientists to perform complex queries on the replicas without impacting the performance of the production database. The readable standby instances can handle the read workload, distributing the read traffic and reducing the load on the primary database. \3. Near Real-Time Access: The readable standby instances are continuously updated through synchronous replication, providing near real-time data for the data scientists' analysis and queries. \4. Cost-Effectiveness: Readable standby instances can be a cost-effective solution as they use the same underlying storage as the primary database and have their own compute resources. This allows the data scientists to perform their analysis without the need to scale the primary database, which could be more expensive. Compared to the other options, option D provides the most cost-effective solution while meeting the requirements: A. Scaling the existing production database: Scaling the production database to provide enough power for the data scientists may be costly, as it would involve increasing the resources of the primary database. It may also introduce performance impacts on the production workload. B. Changing to a Multi-AZ instance deployment with a larger secondary standby instance: While this option provides high availability, it does not directly address the requirement of providing read-only access to the data scientists. The secondary standby instance is not explicitly meant for read-only usage. C. Changing to a Multi-AZ instance deployment with read replicas: This option provides high availability and read replicas, but a Multi-AZ cluster deployment with readable standby instances (Option D) offers a more robust and scalable solution for read-only access. In summary, to provide data scientists with near real-time read-only access to the production Amazon RDS for PostgreSQL database while ensuring high availability and cost-effectiveness, the recommended solution is to change the setup to a Multi-AZ cluster deployment with two readable standby instances and provide read endpoints to the data scientists (Option D). This allows for distributed read traffic, near real-time access to data, automatic failover capabilities, and cost-effective utilization of readable standby instances for the data scientists' workload.