review

Q1 — RDS read scaling

An RDS MySQL database is hitting CPU limits because heavy reporting queries run alongside transactional traffic. The team wants to offload the read-only reporting workload without affecting writes. What should they implement?

• A. Enable a Multi-AZ deployment
• B. Increase the backup retention period
• C. Create read replicas and point reporting queries at their endpoints
• D. Enable storage auto scaling
• Correct answer:

Q2 — RDS Multi-AZ behavior

Which statement accurately describes an RDS Multi-AZ deployment?

• A. The standby instance serves read traffic to improve performance
• B. The standby is a synchronous replica in another AZ that is promoted automatically during a failure
• C. Failover requires manually updating the application's connection string
• D. Multi-AZ replicates data asynchronously to reduce write latency
• Correct answer:

Q3 — Encrypting an existing RDS database

A company has a running unencrypted RDS instance and must now encrypt its data at rest for compliance. What is the correct approach?

• A. Enable encryption directly on the running instance in the console