AWS Certified Database – Specialty — Question 203

A company migrated an on-premises Oracle database to Amazon RDS for Oracle. A database specialist needs to monitor the latency of the database.

Which solution will meet this requirement with the LEAST operational overhead?

Answer options

• A. Publish RDS Performance insights metrics to Amazon CloudWatch. Add AWS CloudTrail filters to monitor database performance
• B. Install Oracle Statspack. Enable the performance statistics feature to collect, store, and display performance data to monitor database performance.
• C. Enable RDS Performance Insights to visualize the database load. Enable Enhanced Monitoring to view how different threads use the CPU
• D. Create a new DB parameter group that includes the AllocatedStorage, DBInstanceClassMemory, and DBInstanceVCPU variables. Enable RDS Performance Insights

Correct answer: C

Explanation

The correct answer, C, is optimal because it utilizes RDS Performance Insights for a comprehensive view of database load while minimizing operational tasks. Option A requires additional configuration with CloudWatch and CloudTrail, which increases overhead. Option B involves installing and managing third-party tools, which adds complexity, while option D focuses on parameter settings without directly addressing performance monitoring.