DBS-C01 · Question #220
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…
The correct answer is A. Modify the DB instance and set a new master user password. 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. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/UsingWithRDS.MasterAccounts.ht
Question
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?
Options
- AModify the DB instance and set a new master user password.
- BUse AWS Secrets Manager to modify the master user password and restart the DB instance.
- CCreate a new master user for the DB instance.
- DReview the IAM user that owns the DB instance, and add missing permissions.
How the community answered
(27 responses)- A78% (21)
- B4% (1)
- C11% (3)
- D7% (2)
Explanation
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. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/UsingWithRDS.MasterAccounts.ht
Topics
Community Discussion
No community discussion yet for this question.