SAA-C03 Question #93: Real Exam Question with Answer & Explanation

Question

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?

Options

• ACreate an RDS manual snapshot. Upgrade to the new version of Amazon RDS for MySQL.
• BUse native backup and restore. Restore the data to the upgraded new version of Amazon RDS
• CUse AWS Database Migration Service (AWS DMS) to replicate the data to the upgraded new
• DUse Amazon RDS Blue/Green Deployments to deploy and test production changes.

Explanation

Amazon RDSBlue/Green Deploymentsis the ideal solution for upgrading the database version with minimal operational overhead and no data loss. Blue/Green Deployments allows you to create a separate, fully managed "green" environment with the upgraded database version. You can test the new version in the green environment while the "blue" environment continuesserving production traffic. Once testing is complete, you can seamlessly switch traffic to the green environment without downtime. This solution provides: Fast, non-disruptive upgrade: Traffic is only switched to the new environment after testing, ensuring zero data loss. Minimal operational overhead: AWS handles the infrastructure management, reducing manual Option A (Manual snapshot): This requires manual intervention and involves more operational Option B (Native backup/restore): This approach is more labor-intensive and slower than Blue/Green Deployments. Option C (DMS): AWS DMS adds unnecessary complexity for a simple version upgrade when Blue/Green Deployments can handle the task more efficiently.

No community discussion yet for this question.