Exam AWS Certified Solutions Architect - Associate SAA-C03 topic 1 question 95 discussion

The solutions architect should recommend option D: Create read replicas for the database. Configure the read replicas with the same compute and storage resources as the source database. Creating read replicas allows the application to offload read traffic from the source database, improving its performance. The read replicas should be configured with the same compute and storage resources as the source database to ensure that they can handle the read workload effectively.

A. In a Multi-AZ deployment, a standby replica of the database is created in a different AZ for high availability and automatic failover purposes. However, serving read requests from the primary AZ alone would not effectively separate read and write traffic. Both read and write traffic would still be directed to the primary database instance, which might not fully optimize performance. B. The secondary instance in a Multi-AZ deployment is intended for failover and backup purposes, not for actively serving read traffic. It operates in a standby mode and is not optimized for handling read queries efficiently. C. Configuring the read replicas with half of the compute and storage resources as the source database might not be optimal. It's generally recommended to configure the read replicas with the same compute and storage resources as the source database to ensure they can handle the read workload effectively. D. Configuring the read replicas with the same compute and storage resources as the source database ensures that they can handle the read workload efficiently and provide the required performance boost.

A criação de réplicas de leitura com os mesmos recursos de computação e armazenamento que o banco de dados de origem resolve o problema de forma eficiente, pois: Tráfego de leitura separado: Direcionar o tráfego de leitura para as réplicas reduz a carga na instância primária, otimizando o desempenho geral. Manutenção da performance: Garantir que as réplicas tenham os mesmos recursos evita gargalos, mesmo sob tráfego intenso. Implementação rápida: A configuração de réplicas de leitura no Amazon RDS é rápida e gerenciada, permitindo uma solução quase imediata. Essa abordagem atende à necessidade da empresa de otimizar o desempenho do aplicativo de forma rápida e escalável.

Multi-AZ's offer availability but Read Replicas offers read performance.

Ans D - can't be C because we don't know how much CPU write/read respectively consumes; we'll have to monitor to find out...

D makes the most sense.

Keyword: "separate read traffic from write traffic" = Read Replica = Option A and B are not the correct answer. Option C: Why would you try to have half the resource for read replicas ?. It must be equal resources to ensure read load can be served consistently. Correct Answer is D: Read replica with same compute power as source database instance.

A: This will not have any change as you are still reading from same instance as you are writing to B: Not possible (https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Concepts.MultiAZSingleStandby.html) C: Why would you do that even if that was possible? No one asked to save on cost D: Read replicas are normally for handling read-only traffic

In a Multi-AZ deployment, the standby instance is kept in sync with the primary instance and is used for failover purposes only. You cannot read data from the standby instance in a Multi-AZ deployment. If you need to offload read traffic from the primary instance, you can create one or more Read Replicas. Read Replicas are read-only copies of your database that can be used to offload read traffic from the primary instance, which can help improve performance

D. Configuring the read replicas with the same compute and storage resources as the source database ensures that they can handle the read workload efficiently and provide the required performance boost.

Both B and D would work. Amazon RDS now offers Multi-AZ deployments with readable standby instances (also called Multi-AZ DB cluster deployments) . You should consider using Multi-AZ DB cluster deployments with two readable DB instances if you need additional read capacity in your Amazon RDS Multi-AZ deployment and if your application workload has strict transaction latency requirements such as single-digit milliseconds transactions. https://aws.amazon.com/blogs/database/readable-standby-instances-in-amazon-rds-multi-az-deployments-a-new-high-availability-option/#:~:text=read%20replicas.-,Amazon%20RDS,-now%20offers%20Multi

The best solution is to create read replicas for the database and configure them with the same compute and storage resources as the source database. The key requirements are to quickly optimize performance by isolating reads from writes. Read replicas allow read-only workloads to be directed to one or more replicas of the source RDS instance. This separates reporting or analytics queries from transactional workloads. The read replicas should have the same compute and storage as the source to provide equivalent performance for reads. Scaling down the replicas would limit read performance. Using Multi-AZ alone does not achieve read/write separation. The secondary AZ instance is for disaster recovery, not performance.

Read replica + Same resources as we may need to turn replica to primary in few cases

D meets the requiremets.

Option C suggests creating read replicas for the database and configuring them with half of the compute and storage resources as the source database. This is a better option as it allows read traffic to be offloaded from the primary database, separating read traffic from write traffic. Configuring the read replicas with half the resources will also save on costs.

Can anyone explain why B is not an option?

You can create up to 15 read replicas from one DB instance within the same Region. For replication to operate effectively, each read replica should have the same amount of compute and storage resources as the source DB instance. If you scale the source DB instance, also scale the read replicas.