Microsoft
70-432 · Question #134
You are mastering the company database, with SQL Server 2008 computer named SQLDB. The function of the SQLDB is to perform transaction log backups and so on. SQL1 should be reset by another…
The correct answer is B. You should reset the server so that the SQL Server Agent service starts automatically. See the full explanation below for the reasoning.
Question
You are mastering the company database, with SQL Server 2008 computer named SQLDB. The function of the SQLDB is to perform transaction log backups and so on. SQL1 should be reset by another administrator using the tool of SQL Server Surface Area Configuration. You should see that SQL1 no longer runs the maintenance tasks automatically. On SQLDB, You should make sure the tasks of the maintenance are finished without men Which is the correct answer?
Options
- AYou should reset the Web service to log on by using the role of administrator.
- BYou should reset the server so that the SQL Server Agent service starts automatically.
- CYou should reset operate a full backup of the master database by hand.
- DYou should reset SQLDB to use Windows Integrated authentication.
How the community answered
(29 responses)- A14% (4)
- B76% (22)
- C7% (2)
- D3% (1)
Community Discussion
No community discussion yet for this question.