DBS-C01 · Question #246
A company recently migrated its line-of-business (LOB) application to AWS. The application uses an Amazon RDS for SQL Server DB instance as its database engine. The company must set up cross-Region…
The correct answer is A. Create a cross-Region read replica of the DB instance. Promote the read replica at the time of. Amazon Relational Database Service (Amazon RDS) for SQL Server now supports Cross Region Read Replica. Cross Region Read Replica enables managed disaster recovery capability for mission critical databases by allowing a read replica in another region be "promoted" as a new…
Question
A company recently migrated its line-of-business (LOB) application to AWS. The application uses an Amazon RDS for SQL Server DB instance as its database engine. The company must set up cross-Region disaster recovery for the application. The company needs a solution with the lowest possible RPO and RTO. Which solution will meet these requirements?
Options
- ACreate a cross-Region read replica of the DB instance. Promote the read replica at the time of
- BSet up SQL replication from the DB instance to an Amazon EC2 instance in the disaster recovery
- CUse AWS Database Migration Service (AWS KMS) for ongoing replication of the DB instance in
- DTake manual snapshots of the DB instance in the primary Region. Copy the snapshots to the
How the community answered
(42 responses)- A79% (33)
- B2% (1)
- C7% (3)
- D12% (5)
Explanation
Amazon Relational Database Service (Amazon RDS) for SQL Server now supports Cross Region Read Replica. Cross Region Read Replica enables managed disaster recovery capability for mission critical databases by allowing a read replica in another region be "promoted" as a new standalone production database. https://aws.amazon.com/blogs/database/use-cross-region-read-replicas-with-amazon-relational- database-service-for-sql-server/
Topics
Community Discussion
No community discussion yet for this question.