Q12 — AWS SAA-C03 Ch.10

Question 12 of 100 | ← Chapter 10

Q612. A company has an on-premises server that uses an Oracle database to process and store customer information. The company wants to use an AWS database service to achieve higher availability and to improve application performance. The company also wants to offload reporting from its primary database system.Which solution will meet these requirements in the MOST operationally efficient way?

Correct Answer: C. Use Amazon RDS deployed in a Multi-AZ cluster deployment to create an Oracle database. Direct the reporting functions to use the reader instance in the cluster deployment.

Explanation

The solution that will meet the company's requirements in the most operationally efficient way is: C. Use Amazon RDS deployed in a Multi-AZ cluster deployment to create an Oracle database. Direct the reporting functions to use the reader instance in the cluster deployment. Explanation: Option C suggests using Amazon RDS deployed in a Multi-AZ cluster deployment to create an Oracle database and directing the reporting functions to use the reader instance in the cluster deployment. Advantages of this solution include: \1. Higher Availability: Amazon RDS Multi-AZ cluster deployment provides automatic failover to a standby instance in another Availability Zone in case of infrastructure issues or database maintenance. This ensures higher availability and reduces downtime. \2. Improved Application Performance: By using Amazon RDS, the company can leverage AWS's infrastructure and optimizations to improve application performance compared to an on-premises server. Amazon RDS manages database tasks such as backups, software patching, and scaling, allowing the company to focus on application development. \3. Offloading Reporting: By directing the reporting functions to the reader instance in the cluster deployment, the company can offload reporting workload from the primary database system. This helps improve the performance of the primary database and avoids resource contention. Compared to the other options, option C provides the most operationally efficient solution for meeting the requirements: A. Using AWS Database Migration Service (AWS DMS) to create an Amazon RDS DB instance in multiple AWS Regions: While this option offers higher availability by deploying in multiple regions, it may introduce additional complexity and cost. It may not be the most operationally efficient solution for offloading reporting functions. B. Using Amazon RDS in a Single-AZ deployment with a read replica: While this option provides a read replica for offloading reporting, it lacks the automatic failover capability of a Multi-AZ deployment. This may result in higher downtime during maintenance or infrastructure issues. D. Using Amazon RDS in a Multi-AZ instance deployment to create an Amazon Aurora database: This option suggests using Amazon Aurora instead of Oracle, which may not align with the company's requirement of using an Oracle database. While Amazon Aurora offers high availability and performance benefits, it may introduce additional complexity and cost if Oracle compatibility is specifically needed. In summary, to achieve higher availability, improve application performance, and offload reporting functions in the most operationally efficient way, the recommended solution is to use Amazon RDS deployed in a Multi-AZ cluster deployment to create an Oracle database and direct the reporting functions to use the reader instance in the cluster deployment (Option C). This provides automatic failover, improved performance, and offloading capabilities while leveraging the managed features of Amazon RDS.