Identify the situation in which you would use the Automatic Workload Repository (AWR) baseline
template.
A.
when creating AWR snapshots based on a repeating time schedule
B.
when creating and dropping AWR baselines based on a repeating time schedule
C.
when computing statistics for all moving window baselines based on a repeating time schedule
in the future
D.
when resetting the threshold values for the SYSTEM_MOVING_WINDOW baseline based on a
repeating time schedule in the future
B)
You can also create baselines for a contiguous time period in the future using baseline templates. There are two types of baseline templates: single and repeating.
A single baseline template can be used to create a baseline for a single contiguous time period in the future. This is useful if you know beforehand of a time period that you want to capture in the future. For example, you may want to capture the AWR data during a system test that is scheduled for the upcoming weekend. In this case, you can create a single baseline template to automatically capture the time period when the test will take place.
A repeating baseline template can be used to create and drop baselines based on a repeating time schedule. This is useful if you want Oracle Database to automatically capture a contiguous time period on an ongoing basis. For example, you may want to capture the AWR data during every Monday morning for a month. In this case, you can create a repeating baseline template to automatically create baselines on a repeating schedule for every Monday, and automatically remove older baselines after a specified expiration interval such as one month.
AWR baseline template (repeating): create and drop baseline based on a repeating time schedule
B is right