Oracle Cloud Infrastructure 2019 Architect Associate — Question 49

The default eight-day retention period for Autonomous Database performance data can be modified using which DBMS_WORKLOAD_REPOSITORY subprogram procedure?

Answer options

• A. UPDATE_OBJECT_INFO
• B. MODIFY_SNAPSHOT_SETTINGS
• C. CREATE_BASELINE_TEMPLATE
• D. MODIFY_BASELINE_WINDOW_SIZE

Correct answer: B

Explanation

The correct answer is B, MODIFY_SNAPSHOT_SETTINGS, as it specifically allows for adjustments to the retention settings of performance data. The other options do not pertain to modifying retention periods; A is for updating object information, C is for creating baseline templates, and D is for changing the size of the baseline window.