PrepAway - Latest Free Exam Questions & Answers

What should you do?

You work as a database administrator at Domain.com. Domain.com is using a SQL Server 2008 instance.
Domain.com contains two SQL Server 2008 servers named CERTKILLER-DB1 and CERTKILLER-DB2.
CERTKILLER-DB1 does the transaction log backups and CERTKILLER-DB2 is to reset by using the SQL Server Surface Area Configuration.
However one morning you notice that the CERTKILLER-DB2 did not run the maintenance tasks automatically.

What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
You should consider resetting a full backup of the master database manually.

B.
You should consider resetting the Web service to only grant access to an administrator.

C.
You should consider resetting CERTKILLER-DB1 to use Windows Integrated authentication exclusively.

D.
You should consider resetting CERTKILLER-DB2 so that the SQL Server Agent service starts automatically.


Leave a Reply