Answer-first summary for fast verification
Answer: Employ a CloudFormation template with a custom resource for user creation within the database, deploying this template in each account.
The most operationally efficient solution is to use a CloudFormation template with a custom resource to create users within the database. This approach allows the automation of user creation and ensures consistency across all three accounts by using a declarative infrastructure-as-code methodology. CloudFormation by itself does not natively manage database users within RDS, so a custom resource is necessary to achieve this functionality. This solution avoids the need for manual scripting or server management, such as deploying EC2 instances to run scripts or configuring Lambda functions with cross-account access.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
A developer is managing three AWS accounts, each with an Amazon RDS DB instance in a private subnet. The task is to consistently define and update the same set of users across all three databases. What is the most operationally efficient solution for this requirement?
A
Utilize an AWS CloudFormation template to declare and attach users to the database, then deploy the template across all accounts.
B
Employ a CloudFormation template with a custom resource for user creation within the database, deploying this template in each account.
C
Develop a script for user creation and execute it on Amazon EC2 instances in each account, targeting the respective databases.
D
Use an AWS Lambda function configured with access to all three accounts to create the necessary users in the databases.
No comments yet.