Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
AWS Certified Solutions Architect - Associate · AWS
Select 2 answers.
This question asks for 2 answers, but our data marks only 1. Compare with the community discussion below for the full answer.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
A: Enable binlog replication on RDS primary,this is essential for MySQL read replicas: C: Allow long-running transactions to complete,this is a critical best practice
C. Allow long-running transactions to complete on the source DB instance. Active long-running transactions can delay read replica creation. AWS recommends resolving these first to avoid replication delays or failures . E. Enable automatic backups on the source instance by setting the backup retention period to a value other than 0. Automatic backups are mandatory for read replica creation. Enabling backups activates binary logging (binlog) on the source, which is required for replication
To create a read replica for Amazon RDS for MySQL, the following prerequisites must be met: A. Enable binlog replication on the RDS primary node Required. RDS read replicas rely on MySQL binary log (binlog) replication. This setting is not enabled by default. You must set the DB parameter binlog_format to ROW and enable binary logging by modifying the parameter group. E. Enable automatic backups Required. Enabling automatic backups by setting backup retention > 0 is necessary to support point-in-time recovery and to allow the creation of read replicas. RDS uses the backup snapshot as a baseline to create the initial read replica. Why not "C. Allow long-running transactions to complete"? Not a prerequisite for creating a read replica. Might improve performance temporarily, but it’s unrelated to read replica setup.