1Z0-062 Question #290: Real Exam Question with Answer & Explanation

Question

Options

• AIt measures database performance by analyzing the wait time and CPU time of all non-idle user
• BIt always compares the latest snapshot with the baseline snapshot for analysis.
• CIt runs after each AWR snapshot is created and it requires at least two snapshots for analysis.
• DIt requires at least four AWR snapshots for analysis.
• EIt calls other advisors if required, but does not provide recommendations about the advisors to be used.

Explanation

ADDM analyzes database performance by examining wait time and CPU time for non-idle sessions, and it automatically runs after each AWR snapshot is generated, requiring at least two snapshots to compare a time interval.

Common mistakes.

• B. ADDM typically analyzes the interval between the two most recent AWR snapshots, not necessarily always comparing the latest snapshot with a baseline snapshot unless specifically configured to do so.
• D. ADDM requires only two AWR snapshots (a start and an end snapshot) to define an analysis period, not four.
• E. ADDM provides recommendations for performance improvements and often suggests using other advisors, such as the SQL Tuning Advisor or Memory Advisors, for deeper analysis of specific problems.

Concept tested. ADDM functionality and requirements

Reference. https://docs.oracle.com/en/database/oracle/oracle-database/19/tgsql/using-automatic-database-diagnostic-monitor.html#GUID-E138E662-7934-4C3D-882E-2D13A465B2B8

No community discussion yet for this question.