Correct Answer: Multi-AZ with Always On Availability Groups
RDS for SQL Server uses Always On Availability Groups (AGs) to provide synchronous replication and automatic failover for high availability....
Correct Answer
Multi-AZ with Always On Availability Groups
Why This Answer Is Correct
RDS for SQL Server uses Always On Availability Groups (AGs) to provide synchronous replication and automatic failover for high availability.
This question evaluates your knowledge of Amazon RDS — a core concept tested in AWS Certified Solutions Architect – Associate (SAA-C03). Understanding Amazon RDS is essential for designing scalable, secure, and cost-effective cloud architectures. Mastery of this topic will help you answer scenario-based questions confidently on exam day.
A financial application requires a relational database that supports high availability and automated backups. The database must be fully managed to reduce operational overhead. Which service fits these requirements?
A company requires a relational database in AWS that can handle unpredictable traffic spikes while minimizing operational overhead. Which RDS feature or engine should the solutions architect recommend?
A solutions architect is designing a high-availability database for an application. The primary database should automatically fail over to a standby in another Availability Zone with zero data loss. Which feature is required?
An application has a read-heavy workload that is causing performance degradation on the primary RDS MySQL instance. How can the architect scale the read capacity globally for users in different regions?
A company needs to analyze audit logs stored in an RDS SQL Server database. They want to offload this analytical work from the production database. Which approach is most efficient for a SQL Server engine in RDS?