Which actions should the database specialist take before creating the read replica? (Choose two.)

Last Updated on September 18, 2021 by Admin 3

An ecommerce company recently migrated one of its SQL Server databases to an Amazon RDS for SQL Server Enterprise Edition DB instance. The company expects a spike in read traffic due to an upcoming sale. A database specialist must create a read replica of the DB instance to serve the anticipated read traffic.

Which actions should the database specialist take before creating the read replica? (Choose two.)

  • Identify a potential downtime window and stop the application calls to the source DB instance.
  • Ensure that automatic backups are enabled for the source DB instance.
  • Ensure that the source DB instance is a Multi-AZ deployment with Always ON Availability Groups.
  • Ensure that the source DB instance is a Multi-AZ deployment with SQL Server Database Mirroring (DBM).
  • Modify the read replica parameter group setting and set the value to 1.
0 0 votes
Article Rating
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments