Exam AWS Certified Database - Specialty topic 1 question 225 discussion

Exam question from Amazon's AWS Certified Database - Specialty

Question #: 225
Topic #: 1

[All AWS Certified Database - Specialty Questions]

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.)

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.

Show Suggested Answer

Suggested Answer: BD 🗳️

by mbar94 at Sept. 5, 2022, 9 a.m.

Disclaimers:

- ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
- Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Submit Cancel

Pranava_GCP

1 year, 9 months ago

Selected Answer: BD

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.SQLServer.CommonDBATasks.RenamingDB.html

upvoted 2 times

...

mbadioum

2 years, 1 month ago

BD is correct https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.SQLServer.CommonDBATasks.RenamingDB.html

upvoted 3 times

...

redman50

2 years, 2 months ago

Selected Answer: AD

Option B is incorrect because turning off Multi-AZ for the DB instance is not necessary to rename the database.

upvoted 1 times

...

cloudsunriser

2 years, 8 months ago

Selected Answer: BD

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.SQLServer.CommonDBATasks.RenamingDB.html

upvoted 4 times

...

SonamDhingra

2 years, 8 months ago

Selected Answer: BD

BD is correct https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.SQLServer.CommonDBATasks.RenamingDB.html https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.SQLServer.CommonDBATasks.RenamingDB.html

upvoted 2 times

...

SonamDhingra

2 years, 8 months ago

BD is correct https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.SQLServer.CommonDBATasks.RenamingDB.html

upvoted 3 times

...

mbar94

2 years, 9 months ago

Selected Answer: BD

Agree, it's B and D.

upvoted 3 times

...