You are employed as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. The Domain.com network uses a SQL Server 2005 database named CK_DATA, which is located on a server named Certkiller -DB01.
Domain.com also contains another SQL Server 2005 database server named Certkiller -DB02 on which a recent copy of CK_DATA exists. During routine monitoring you discover a high number of full scans on Certkiller -DB01. You come to a conclusion that extra indexes in CK_DATA are required. You have received instruction from the CIO to analyze the workload file by using DATA. You need to accomplish this without compromising the performance on Certkiller -DB01 during the analysis. You need to guarantee availability of any recommendations suggested by the DTA during implementation.
What should you do?
A.
You need to store the workload file on Certkiller -DB01 and start DTA on it.
Then you can connect to Certkiller -DB01 and specify all workload and tuning options as necessary.
Thereafter you can select the All recommendations are offline check box in the Advanced Tuning Options dialog box.
B.
You need store the workload file on Certkiller -DB02 and start DTA on it.
Then you will be able to connect to Certkiller -DB02 and specify all workload and tuning options as necessary.
Select the All recommendations are offline check box in the Advanced Tuning Options dialog box.
C.
You need to store the workload file on Certkiller -DB01.
Then you have to start DTA on Certkiller -DB02 and connect to Certkiller -DB01.
All workload and tuning options should be specified as necessary and in the Advanced Tuning Options dialog box you should select the Generate only online recommendations check box.
D.
You need to store the workload file on Certkiller -DBO2.
The next step will be to start DTA on Certkiller -DB02 and connect to Certkiller -DB02.
Then you should specify all workload and tuning options as needed.
Thereafter you need select the Generate only online recommendations check box in the Advanced Tuning Options dialog box.
Explanation:
One of the requirements is to guarantee 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; therefore you should choose the Generate only online recommendations.