Q38 — AWS SAA-C03 Ch.16

Question 38 of 100 | ← Chapter 16

Q1238. 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?

Correct Answer: A. Create RDS resources by using AWS CloudFormation. Share the CloudFormation template with each account.

Explanation

To meet the company's requirements of deploying Amazon RDS instances across more than 100 AWS accounts with specific compliance parameters in the most operationally efficient way, the following analysis can be made:Key Requirements:Automated Solution: The solution must be automated to deploy RDS instances efficiently across multiple accounts.Specific Compliance Parameters: The RDS instances must be deployed with specific compliance settings. No Data Replication: The data does not need to be replicated between accounts. Rapid Deployment: The databases must be created within 1 day.Solution Analysis:AWS CloudFormation:Purpose: AWS CloudFormation is a service that helps you model and set up your AWS resources so that you can spend less time managing those resources and more time focusing on your applications that run in AWS. It allows you to create a template that defines the AWS resources you want to provision, and then use that template to create, update, or delete a stack of resources. Efficiency: CloudFormation templates can be shared and reused across multiple accounts, making it an efficient way to deploy RDS instances with specific compliance parameters. The template can include all the necessary configurations, such as instance type, storage, security groups, and parameter groups, ensuring consistency across deployments.Automation: CloudFormation can be integrated with AWS services like AWS Systems Manager or AWS CodePipeline to automate the deployment process further.RDS Snapshot:Purpose: RDS snapshots are used for backing up and restoring RDS instances. They capture the state of the database at a specific point in time and can be used to create new instances. Limitations: Snapshots are not suitable for deploying RDS instances with specific compliance parameters across multiple accounts, as they do not allow for customization of the instance configuration during deployment. Additionally, snapshots would require data replication, which is not needed in this scenario.AWS Database Migration Service (AWS DMS):Purpose: AWS DMS is used for migrating databases to AWS. It can be used to replicate data between databases, including RDS instances.Limitations: AWS DMS is not designed for deploying new RDS instances with specific compliance parameters. It is more suited for data migration and replication tasks.AWS CLI Script:Purpose: The AWS CLI can be used to automate AWS tasks by scripting commands. Limitations: While it is possible to create a script to deploy RDS instances across multiple accounts using the AWS CLI, this approach would require significant custom development and maintenance. It would also be less efficient and more error-prone compared to using CloudFormation templates.Evaluating the Options:Option A: Create RDS resources by using AWS CloudFormation. Share the CloudFormation template with each account.Correct: This option meets all the requirements. CloudFormation templates can be shared and reused across multiple accounts, ensuring consistency and efficiency in deploying RDS instances with specific compliance parameters. The deployment process can be automated, and the databases can be created within 1 day.Option B: Create an RDS snapshot. Share the snapshot with each account. Deploy the snapshot into each account.Incorrect: Snapshots are not suitable for deploying RDS instances with specific compliance parameters across multiple accounts, as they do not allow for customization of the instance configuration during deployment.Option 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. Incorrect: AWS DMS is not needed for this scenario, as the data does not need to be replicated between accounts. This option would introduce unnecessary complexity and cost. Option D: Create a script by using the AWS CLI to copy the RDS instance into the other accounts from a template account.Incorrect: This approach would require significant custom development and maintenance, making it less efficient and more error-prone compared to using CloudFormation templates.Final Answer:A. Create RDS resources by using AWS CloudFormation. Share the CloudFormation template with each account.This solution provides the most operationally efficient way to deploy RDS instances with specific compliance parameters across more than 100 AWS accounts.