AWS Certified Database – Specialty — Question 277

A company has more than 100 AWS accounts that need Amazon RDS instances. The company wants to build an automated solution to deploy the RDS instances with specific compliance parameters. The data does not need to be replicated. The company needs to create the databases within 1 day.

Which solution will meet these requirements in the MOST operationally efficient way?

Answer options

• A. Create RDS resources by using AWS CloudFormation. Share the CloudFormation template with each account.
• B. Create an RDS snapshot. Share the snapshot with each account. Deploy the snapshot into each account.
• C. Use AWS CloudFormation to create RDS instances in each account. Run AWS Database Migration Service (AWS DMS) replication to each of the created instances.
• D. Create a script by using the AWS CLI to copy the RDS instance into the other accounts from a template account.

Correct answer: A

Explanation

AWS CloudFormation is the most operationally efficient tool for deploying standardized infrastructure as code across multiple accounts, ensuring compliance configurations are consistently met. Using AWS DMS (Option C) is unnecessary since data replication is not required, while managing custom AWS CLI scripts (Option D) or manual snapshot sharing (Option B) introduces operational overhead and complexity.