AWS Certified Solutions Architect - Associate
Get started today
Ultimate access to all questions.
Deep dive into the quiz with AI chat providers.
We prepare a focused prompt with your quiz and certificate details so each AI can offer a more tailored, in-depth explanation.
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?
Other
Community
UAnonymous
A
Use AWS Database Migration Service (AWS DMS) to create an Amazon RDS DB instance in multiple AWS Regions. Point the reporting functions toward a separate DB instance from the primary DB instance.
B
Use Amazon RDS in a Single-AZ deployment to create an Oracle database. Create a read replica in the same zone as the primary DB instance. Direct the reporting functions to the read replica.
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.
D
Use Amazon RDS deployed in a Multi-AZ instance deployment to create an Amazon Aurora database. Direct the reporting functions to the reader instances.
Explanation:
Explanation
Option C is the correct answer because it provides the most operationally efficient solution that meets all requirements:
-
Higher Availability: Multi-AZ cluster deployment provides high availability with automatic failover capabilities across multiple Availability Zones.
-
Improved Application Performance: The Multi-AZ cluster deployment includes reader instances that can handle read traffic, improving overall performance.
-
Offload Reporting: The reader instance in the cluster deployment can be used for reporting functions, separating read-intensive reporting workloads from the primary write instance.
-
Operational Efficiency: This solution uses a single database service (Amazon RDS for Oracle) with built-in high availability and read scaling capabilities, minimizing operational overhead.
Why other options are incorrect:
-
Option A: Using AWS DMS to create instances in multiple regions is overly complex and not the most operationally efficient approach for this scenario. It introduces unnecessary complexity for cross-region replication when the requirements can be met within a single region.
-
Option B: Single-AZ deployment does not provide high availability. Creating a read replica in the same zone doesn't improve availability and doesn't meet the requirement for higher availability.
-
Option D: While Amazon Aurora provides excellent performance and availability, the company currently uses Oracle database. Migrating to Aurora would require database migration and potentially application changes, which is not the most operationally efficient approach when they can use RDS for Oracle with Multi-AZ cluster deployment.
Comments
Loading comments...