1Z0-062 · Question #7
Your database supports a DSS workload that involves the execution of complex queries: Currently, the library cache contains the ideal workload for analysis. You want to analyze some of the queries for
Sign in or unlock 1Z0-062 to reveal the answer and full explanation for question #7. The question stem and answer options stay visible for context.
Question
Your database supports a DSS workload that involves the execution of complex queries:
Currently, the library cache contains the ideal workload for analysis. You want to analyze some of the queries for an application that are cached in the library cache. What must you do to receive recommendations about the efficient use of indexes and materialized views to improve query performance?
Options
- ACreate a SQL Tuning Set (STS) that contains the queries cached in the library cache and run the
- BRun the Automatic Workload Repository Monitor (ADDM).
- CCreate an STS that contains the queries cached in the library cache and run the SQL
- DCreate an STS that contains the queries cached in the library cache and run the SQL Access
Unlock 1Z0-062 to see the answer
You've previewed enough free 1Z0-062 questions. Unlock 1Z0-062 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.