1Z0-1067-25 Question 58
Single answerYou are the Cloud Ops Professional for a mission-critical analytics application running on an Autonomous Database (Shared Exadata Infrastructure) in Oracle Cloud Infrastructure. Over the past month, users have reported increasing query latency, particularly for complex reporting queries that scan large tables with common WHERE clauses. You want to enhance query performance with minimal operational overhead or downtime. Which strategy would best help you achieve this goal?
- A
Use Oracle Data Safe to audit and generate performance-related reports for all user queries
- B
Enable Automatic Indexing on the Autonomous Database to systematically create and maintain optimal indexes
- C
Implement a full-scale upgrade to a larger Exadata shape to boost compute resources
- D
Create a manual read replica of the database using Oracle GoldenGate to offload reporting queries
Show answer and explanation
Correct answer: B
Explanation
Automatic Indexing in Autonomous Database is a robust performance optimization feature that continuously evaluates and modifies indexes to improve SQL query execution plans. It aligns with best practices in Oracle Cloud Infrastructure for maintaining high performance in production environments without significant manual intervention. Refer to Oracle documentation on 'Autonomous Database Automatic Indexing' for guidance on enabling and monitoring the feature and for detailed best practices in performance tuning.
- A. Incorrect.
Incorrect. Oracle Data Safe primarily focuses on security-related activities, such as user auditing, sensitive data discovery, and data masking. It does provide some activity and security insights, but it is not designed to automatically optimize queries or restructure your database for better performance. While it may help identify potential areas of concern, it does not directly address the query-latency issue caused by missing or suboptimal indexes.
- B. Correct.
Correct. Enabling Automatic Indexing on an Autonomous Database is a best-practice approach for optimizing query performance. It continuously evaluates SQL workloads, automatically creates new indexes when beneficial, and drops those that are no longer needed. This feature reduces the need for manual SQL tuning and can significantly improve read performance with minimal operational overhead.
- C. Incorrect.
Incorrect. Scaling up to a larger Exadata shape can certainly provide more compute and storage resources, but it is not always the most cost-effective or precise solution, especially if the performance issue is attributable to inefficient query paths related to indexing. Simply adding more hardware without addressing the root cause of query inefficiencies may not yield optimal results.
- D. Incorrect.
Incorrect. Creating a manual read replica with Oracle GoldenGate could offload some workload, but it adds complexity in setup and maintenance. It also doesn�t directly resolve the root cause of slow queries if they are inefficiently executed. While read replicas are useful at scale, it is not the most straightforward solution when Automatic Indexing can directly address query inefficiencies with less overhead.