exam questions

Exam 1z0-064 All Questions

View all questions & answers for the 1z0-064 exam

Exam 1z0-064 topic 1 question 4 discussion

Actual exam question from Oracle's 1z0-064
Question #: 4
Topic #: 1
[All 1z0-064 Questions]

You want to capture AWR data to monitor performance variation every Monday between 9:00 AM and 12:00 PM for three months and automatically remove the older AWR data every fortnight.
How would you achieve this? (Choose the best answer.)

  • A. Create AWR baselines.
  • B. Create SQL plan baselines.
  • C. Create repeating baseline templates.
  • D. Create database services and make sure that user connections use them to connect to the database instance.
  • E. Create a single baseline template.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Jatindra
4 years, 11 months ago
Correct Ans: C Baseline Templates Baseline templates enable you to create baselines for a contiguous time period in the future. There are two types of baseline templates: Single Baseline Templates Use a single baseline template 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 intend to capture in the future. For example, you may want to capture 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 occurs. Repeating Baseline Templates Use a repeating baseline template 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 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.
upvoted 3 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago