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.)
A) Identify a potential downtime window and stop the application calls to the source DB instance.
B) Ensure that automatic backups are enabled for the source DB instance.
C) Ensure that the source DB instance is a Multi-AZ deployment with Always ON Availability Groups.
D) Ensure that the source DB instance is a Multi-AZ deployment with SQL Server Database Mirroring (DBM) .
E) Modify the read replica parameter group setting and set the value to 1.
Correct Answer:
Verified
Q145: A database specialist manages a critical Amazon
Q146: A database specialist must load 25 GB
Q147: A company is releasing a new mobile
Q148: A financial company recently launched a portfolio
Q149: After restoring an Amazon RDS snapshot from
Q151: A company wants to automate the creation
Q152: An Amazon RDS EBS-optimized instance with Provisioned
Q153: A database specialist must create nightly backups
Q154: A media company is using Amazon RDS
Q155: A company has two separate AWS accounts:
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents