AWS Certified Database – Specialty — Question 326

A company uses Microsoft SQL Server on Amazon RDS in a Multi-AZ deployment as the database engine for its application. The company was recently acquired by another company. A database specialist must rename the database to follow a new naming standard.
Which combination of steps should the database specialist take to rename the database? (Choose two.)

Answer options

• A. Turn off automatic snapshots for the DB instance. Rename the database with the rdsadmin.dbo.rds_modify_db_name stored procedure. Turn on the automatic snapshots.
• B. Turn off Multi-AZ for the DB instance. Rename the database with the rdsadmin.dbo.rds_modify_db_name stored procedure. Turn on Multi-AZ Mirroring.
• C. Delete all existing snapshots for the DB instance. Use the rdsadmin.dbo.rds_modify_db_name stored procedure.
• D. Update the application with the new database connection string.
• E. Update the DNS record for the DB instance.

Correct answer: B, D

Explanation

To rename a Microsoft SQL Server database on Amazon RDS in a Multi-AZ deployment, you must first disable Multi-AZ because renaming is not supported while mirroring is active. After using the rdsadmin.dbo.rds_modify_db_name stored procedure to change the name, you can safely re-enable Multi-AZ. Finally, the application's connection string must be updated to reference the new database name to ensure successful connectivity.