A software company uses an Amazon RDS for MySQL Multi-AZ DB instance as a data store for its critical applications. During an application upgrade process, a database specialist runs a custom SQL script that accidentally removes some of the default permissions of the master user.
What is the MOST operationally efficient way to restore the default permissions of the master user?

A. Modify the DB instance and set a new master user password.

B. Use AWS Secrets Manager to modify the master user password and restart the DB instance.

C. Create a new master user for the DB instance.

D. Review the IAM user that owns the DB instance, and add missing permissions.








 

Suggested Answer: A

Community Answer: A

If you accidentally delete the permissions for the master user, you can restore them by modifying the DB instance and setting a new master user password.
Reference:
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/UsingWithRDS.MasterAccounts.html


This question is in DBS-C01 AWS Certified Database – Specialty Exam
For getting AWS Certified Database – Specialty Certificate


Disclaimers:
The 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.
The website does not contain actual questions and answers from Amazon's Certification Exam.