1Z0-052 Question #249: Real Exam Question with Answer & Explanation

Question

Options

• Acreate baseline metrics for today's performance
• Bwrite the current database metrics to a database table and create a trigger to compare with future
• Cwrite the current database metrics to a flat file and create an operating script to compare with
• Dwrite the current database metrics to a database table and create a procedure to compare with
• Ewrite the current database metrics to a database table and submit a job using DBMS_JOB to

Explanation

Before any alerting or comparison mechanism can be configured, a performance baseline must be captured first to serve as the reference point for detecting future degradation.

Common mistakes.

• B. Writing metrics to a table and creating a trigger addresses the comparison mechanism but skips the prerequisite of formally establishing a named, time-stamped baseline.
• C. Writing metrics to a flat file is an informal approach that bypasses Oracle's built-in baseline management and is still not the first logical step.
• D. Creating a stored procedure to compare metrics is a subsequent automation step that presupposes a baseline has already been captured and stored.
• E. Scheduling a job via DBMS_JOB to perform comparisons is a later step that cannot function correctly without a baseline already defined as the reference.

Concept tested. Oracle AWR performance baseline creation

Reference. https://docs.oracle.com/en/database/oracle/oracle-database/19/tgdba/gathering-database-statistics.html

No community discussion yet for this question.