DBS-C01 practice question 24 of 35

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?

Full set: 322 questions
Answer options
A: Modify the DB instance and set a new master user password. Correct answer
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.
Correct Answer:
A. Modify the DB instance and set a new master user password.
Explanation

:

Scroll to Top