PrepAway - Latest Free Exam Questions & Answers

What should you do to achieve this goal?

You are employed as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. Your duties at Domain.com are the administrating of the SQL Server 2005 computer named Certkiller -DBO1. Certkiller -DBO1 was installed with the default settings and on the server.
A database named CK_DATA is located on the Certkiller -DBO1. As administrator you noticed the recent failure of a hard disk controller and decide to check the integrity of CK_DATA. You need to create a maintenance task named Check CK_DATA that makes use of default settings.
You are then required to schedule the check to run over the weekend not to interfere with user transactions. You need to retrieve the outcome details of the Check CK_DATA maintenance plan the following Monday. What should you do to achieve this goal? (Choose all that apply)

PrepAway - Latest Free Exam Questions & Answers

A.
You need to right-click the Activity Monitor in the SQL Management Studio.
Then the View Processes should be clicked on the context menu.
Thereafter you should look for a record that has "CheckCK_DATA " in the Application column.

B.
You need to navigate the C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOG folder in Windows Explorer.
Thereafter you should view the text file that has a name that starts with "CheckCK_DATA _" followed by the execution year, date, and time.

C.
You need to right-click the CheckCK_DATA maintenance plan in the SQL Management Studio.
You should then click View History on the context menu.
This will enable you to see the record for the plan named CheckCK_DATA.

D.
You need to navigates the C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOG folder. View the SQLAgent.out text file in Windows Explorer.


Leave a Reply