Q79 — AWS SAA-C03 Ch.13

Question 79 of 100 | ← Chapter 13

Q979. A company stores a large volume of critical data in Amazon RDS for PostgreSQL tables. The company is developing several new features for an upcoming product launch. Some of the new features require many table alterations.The company needs a solution to test the altered tables for several days.After testing, the solution must make the new features available to customers in productionWhich solution will meet these requirements with the HIGHEST availability?

Correct Answer: D. Use an Amazon RDS blue/green deployment to deploy e new test instance of the database. Make database table updates in the test instance. When the testing is finished, promote the test instance to become the new production instance.

Explanation

The correct answer is:D. Use an Amazon RDS blue/green deployment to deploy a new test instance of the database. Make database table updates in the test instance. When the testing is finished, promote the test instance to become the new production instance.Explanation:A. Create a new instance of the database in RDS for PostgreSQL to test the new features. When the testing is finished, take a backup of the test database, and restore the test database to the production database.- This solution would require downtime to restore the test database to the production database, which would not meet the "highest availability" requirement.B. Create new database tables in the production database to test the new features. When the testing is finished, copy the data from the older tables to the new tables. Delete the older tables, and rename the new tables accordingly.- This solution would involve making changes directly in the production database, which could potentially disrupt the production environment and would not meet the "highest availability" requirement.C. Create an Amazon RDS read replica to deploy a new instance of the database. Make updates to the database tables in the replica instance. When the testing is finished, promote the replica instance to become the new production instance.- This solution is better than the previous two, as it allows for testing in a separate instance. However, promoting the replica to production would still involve some downtime, which may not meet the "highest availability" requirement.D. Use an Amazon RDS blue/green deployment to deploy a new test instance of the database. Make database table updates in the test instance. When the testing is finished, promote the test instance to become the new production instance.- This is the best solution as it leverages the blue/green deployment strategy, which allows for the creation of a new test environment (green) while maintaining the current production environment (blue). This ensures that the production environment remains available throughout the testing and deployment process, meeting the "highest availability" requirement.- When the testing is complete, the new test instance (green) can be promoted to become the new production instance, with minimal or no downtime for the end-users.Therefore, the solution that will meet the requirements with the highest availability is to use an Amazon RDS blue/green deployment.