Q39 — AWS SAA-C03 Ch.11

Question 39 of 100 | ← Chapter 11

Q739. A company runs a production database on Amazon RDS for MySQL. The company wants to upgrade the database version for security compliance reasons. Because the database contains critical data, the company wants a quick solution to upgrade and test functionality without losing any data.Which solution will meet these requirements with the LEAST operational overhead?

Correct Answer: D. Use Amazon RDS Blue/Green Deployments to deploy and test production changes.

Explanation

To meet the requirements of upgrading the Amazon RDS for MySQL database version for security compliance reasons, while ensuring a quick solution to upgrade and test functionality without losing any data and with the least operational overhead, the solution that would best fit these requirements is:D. Use Amazon RDS Blue/Green Deployments to deploy and test production changes.Option D, using Amazon RDS Blue/Green Deployments to deploy and test production changes, would meet the requirements with the least operational overhead.Amazon RDS Blue/Green Deployments allow you to create a new environment (green environment) with the upgraded version of Amazon RDS for MySQL, while keeping the existing production environment (blue environment) intact. This approach minimizes the downtime and risk associated with upgrading the database.Here's how the process works:\1. Create a replica of the production environment with the upgraded version of Amazon RDS for MySQL. This replica serves as the green environment for testing.\2. Configure the necessary settings, such as security groups and parameter groups, in the green environment to match the production environment.\3. Validate the functionality and test the upgraded database version in the green environment without impacting the production data.\4. Once the testing is successful, perform a DNS switch or other appropriate method to redirect the application traffic from the blue environment to the green environment.\5. Monitor the green environment and ensure that it is functioning correctly and meeting the security compliance requirements.By using Amazon RDS Blue/Green Deployments, you can quickly upgrade the database version, test the functionality, and ensure that critical data is not lost during the process. This approach provides a seamless transition from the old version to the new version, minimizing operational overhead and risks.Option A, creating an RDS manual snapshot and upgrading to the new version of Amazon RDS for MySQL, may involve more operational overhead compared to option D. It requires launching a new RDS instance, restoring the data from the manual snapshot, and potentially reconfiguring settings. While it preserves the data, it may involve additional steps and potential complexities.Option B, using native backup and restore to restore the data to the upgraded new version of Amazon RDS for MySQL, may also involve more operational overhead compared to option D. It requires backing up the data, launching a new RDS instance with the upgraded version, and restoring the data to the new instance. While it preserves the data, it may involve additional steps and potential complexities.Option C, using AWS Database Migration Service (AWS DMS) to replicate the data to the upgraded new version of Amazon RDS for MySQL, may introduce additional complexity and operational overhead compared to the straightforward upgrade process in option D. AWS DMS is typically used for database migration and replication scenarios, but it may not be the most suitable solution for a simple version upgrade.Therefore, the most suitable solution that meets the requirements with the least operational overhead is D: Use Amazon RDS Blue/Green Deployments to deploy and test production changes. This solution allows for a quick and seamless upgrade process while ensuring functionality testing and data preservation.