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?
Choose an answer
Tap an option to check your answer.
Correct answer: Use Amazon RDS deployed in a Multi-AZ instance deployment to create an Amazon Aurora database. Direct the reporting functions to the reader instances..
Why this is the answer
The correct answer is to use Amazon RDS deployed in a Multi-AZ instance deployment to create an Amazon Aurora database and direct reporting functions to the reader instances. This solution offers high availability through Multi-AZ deployment and improved performance and scalability by leveraging Aurora's architecture with separate reader instances for reporting, offloading the primary database. Aurora is also highly compatible with MySQL/PostgreSQL, making migration from Oracle feasible with tools like AWS DMS if needed, though the question implies a direct move to an AWS database service. Incorrect options: Creating an Amazon RDS DB instance in multiple AWS Regions with AWS DMS is not the most operationally efficient for offloading reporting; it primarily addresses disaster recovery across regions, not internal reporting offload. Using Amazon RDS in a Single-AZ deployment with a read replica in the same zone does not provide high availability for the primary database, as a single AZ failure would impact both. Using Amazon RDS in a Multi-AZ cluster deployment for Oracle and directing reporting to the reader instance is a good option for Oracle, but Aurora generally offers superior performance, scalability, and operational efficiency for reporting workloads compared to RDS for Oracle.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed