You are employed as a database administrator at Domain.com. All servers on the Domain.com network run Windows 2000 Server and all client computers run Windows 2000 Professional.
Domain.com contains a SQL Server 2005 database server named Certkiller -DB01 that hosts a database named CK_Data. Domain.com also contains another SQL Server 2005 database server named Certkiller -DB02, which has the latest copy of CK_Data. The database CK_Data on Certkiller _DB01 runs 24/7.
During routine monitoring you detect a high number of full scans on Certkiller -DB01. You then come to the conclusion that extra indexes are needed on CK_Data. A workload file that is suitable for Database Engine Tuning Advisor (DTA) already exists.
You need to analyze the workload file by using DTA without compromising the performance on Certkiller -DB01 during the analysis. You also need to make sure that availability during the implementation of any recommendations suggested by the DTA is maintained.
What actions should you take?
A.
On Certkiller -DB01, you need to store the workload file.
Start DTA on Certkiller -DB02 and connect to Certkiller -DB01.
Specify all workload and tuning options as necessary.
In the Advanced Tuning Options dialog box, select the Generate only online recommendations check box.
B.
On Certkiller -DB02, you need to store the workload file.
Start DTA on Certkiller -DB02 and connect to Certkiller -DB02.
Specify all workload and tuning options as necessary.
In the Advanced Tuning Options dialog box, select the Generate only online recommendations check box.
C.
On Certkiller -DB01, you need to store the workload file.
Start DTA on Certkiller -DB01 and connect to Certkiller -DB01.
Specify all workload and tuning options as necessary.
In the Advanced Tuning Options dialog box, select the All recommendations are offline check box.
D.
On Certkiller -DB02, you need to store the workload file.
Start DTA on Certkiller -DB02 and connect to Certkiller -DB02.
Specify all workload and tuning options as necessary.
In the Advanced Tuning Options dialog box, select the All recommendations are offline check box.
Explanation:
One of the requirements is to ensure maximum performance on Certkiller -DB01 during analysis, therefore storing the workload file on Certkiller -DB01 when running DTA is out of the question. You only want suggestions from the DTA that can be implemented while the database is online and therefore you should choose the Generate only online recommendations.