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.