DBS-C01 · Question #235
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…
The correct answer is B. Turn off Multi-AZ for the DB instance. Rename the database with the D. Update the application with the new database connection string. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.SQLServer.CommonDBA Tasks.RenamingDB.html
Question
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.)
Options
- ATurn off automatic snapshots for the DB instance. Rename the database with the
- BTurn off Multi-AZ for the DB instance. Rename the database with the
- CDelete all existing snapshots for the DB instance. Use the rdsadmin.dbo.rds_modify_db_name
- DUpdate the application with the new database connection string.
- EUpdate the DNS record for the DB instance.
How the community answered
(31 responses)- A3% (1)
- B71% (22)
- C16% (5)
- E10% (3)
Explanation
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.SQLServer.CommonDBA Tasks.RenamingDB.html
Topics
Community Discussion
No community discussion yet for this question.