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?
Explanation:
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.