Which of the following is true about the Database Engine Tuning Advisor?
A)the administrator must have detailed knowledge of the database schema to use it
B)performance gains of less than 25% should be discounted
C)it quantifies the expected performance gains for each recommendation
D)it uses a different set of data than the query optimizer

Question

Quizplus · Accepted Answer

The Database Engine Tuning Advisor quantifies the expected performance gains for each recommendation, which helps the administrator evaluate the potential benefits of implementing the suggested changes. Options A, B, and D are incorrect as the tool does not require detailed knowledge of the database schema, performance gains of any magnitude should be considered, and it uses the same set of data as the query optimizer.

Which of the Following Is True About the Database Engine