Q30 — AWS SAA-C03 Ch.15

Question 30 of 100 | ← Chapter 15

Q1130. A company runs complex workloads in Amazon RDS. The company frequently needs to create new Amazon RDS instances to perform tests.Some data is required to perform the tests.As the company has grown, the process to deploy testing instances has become time consuming. The company wants to automate the RDS deployment process.Which solution will meet this requirement with the LEAST operational overhead?

• A. Create a new RDS instance, import the required data,and take a snapshot of the new instance. Create an AWS CloudFormation template that builds a new RDS instance from the snapshot. Use the CloudFormation template to deploy new RDS instances. ✓
• B. Use the AWS Management Console to take a snapshot of an existing RDS instance. Restore the snapshot to a new RDS instance. Create a script to delete the data and schema from new instances.Run the script from an Amazon EC2 instance to reset new RDS tables.
• C. Create an AWS CloudFormation template that builds a new RDS instance. Create a Python script to load the required data into a new instance. Run the script from an Amazon EC2 instance each time a new RDS instance is created.
• D. Create an AWS Lambda function that loads the required data on a target RDS instance. When a new RDS instance is created, update the Lambda function to target the new instance, and invoke the function.

Correct Answer: A. Create a new RDS instance, import the required data,and take a snapshot of the new instance. Create an AWS CloudFormation template that builds a new RDS instance from the snapshot. Use the CloudFormation template to deploy new RDS instances.

Explanation

The solution that will meet the requirement to automate the RDS deployment process with the LEAST operational overhead is:A. Create a new RDS instance, import the required data, and take a snapshot of the new instance. Create an AWS CloudFormation template that builds a new RDS instance from the snapshot. Use the CloudFormation template to deploy new RDS instances.Explanation:Snapshot Automation: By creating a snapshot of a pre-configured RDS instance that already contains the required data, you can quickly restore new instances from this snapshot. This significantly speeds up the deployment process.CloudFormation Template: Using AWS CloudFormation allows you to automate the entire RDS deployment process, including the configuration settings. This minimizes manual intervention and reduces operational overhead.Why Other Options Are Not Suitable:B: While taking a snapshot and restoring it is a good approach, creating a script to delete data and schema introduces additional complexity and operational overhead that could be avoided with a snapshot of the desired state.C: This option requires creating a separate Python script to load data each time, which adds complexity and potential points of failure to the automation process.D: Using a Lambda function to load data introduces an additional step of updating the function each time a new instance is created, which can increase operational overhead and complexity.Thus, option A provides the best balance of automation, efficiency, and simplicity for deploying new RDS instances quickly.