Multiple Choice
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
Correct Answer:

Verified
Correct Answer:
Verified
Q31: _ improves the integrity of the database
Q32: Which counter measures the data being transferred
Q33: The % Processor Time performance counter displays
Q34: Only one user or client application at
Q35: Describe two SQL Server procedures that can
Q36: Index _ is a routine task that
Q37: Which of the following is a suggested
Q38: What are the two types of system
Q39: Which of the following is NOT a
Q41: Which of the following is a database