PrepAway - Latest Free Exam Questions & Answers

What are two possible ways to achieve this goal?

You use a SQL Server 2005 computer that was installed with the default settings. A database named DB1 is located on the server. Due to the recent failure of a hard disk controller, you decide to check the integrity of DB1.
You create a maintenance task named CheckDB1 that uses default settings. Because this check must not interfere with user transactions, you schedule it to run over the weekend.
The following Monday, you need to retrieve the outcome details of the CheckDB1 maintenance plan.
What are two possible ways to achieve this goal? (Each correct answer presents a complete solution. Choose two.)

PrepAway - Latest Free Exam Questions & Answers

A.
In SQL Management Studio, right-click the CheckDB1 maintenance plan. On the context menu, click View History. See the record for the plan named CheckDB1.

B.
In SQL Management Studio, right-click the Activity Monitor. On the context menu, click View Processes. Look for a record that has ‘CheckDB1" in the Application column.

C.
In Windows Explorer, navigate to the C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOG folder. View the SQLAgent.out text file.

D.
In Windows Explorer, navigate to the C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOG folder. View the text file that has a name that starts with "CheckDB1_" followed by the execution year, date, and time.


Leave a Reply