QuestionQ18

VerifiedDesign Resilient Architectures

A company uses a 100 GB Amazon RDS for Microsoft SQL Server Single-AZ DB instance in the us-east-1 Region to store customer transactions. The company requires high availability and automatic recovery for the DB instance.

The company must also run reports on the RDS database several times each year. The reporting process causes transactions to take longer than normal to post to customers’ accounts. The company needs a solution that will improve the performance of the reporting process.

Which combination of steps will meet these requirements?

Choose two
Explanation

A Multi-AZ deployment is the Amazon RDS feature that provides high availability and automatic failover for Microsoft SQL Server by maintaining a synchronized standby in another Availability Zone. To improve reporting performance, the reporting workload should be offloaded from the primary DB instance to a read replica, with report requests directed to that replica. This combination satisfies both the HA/automatic recovery requirement and the need to reduce reporting impact on transactional workloads.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!