Microsoft SQL Server 2008, Implementation and Maintenance

These practice test questions from MeasureUp are based on Microsoft’s exam 70-432: TS: Microsoft SQL Server 2008, Implementation and Maintenance .

The audience for this exam includes individuals who are responsible for installing, configuring and managing SQL Server. Experience using the management tools for SQL Server to configure and manage SQL Server instances, databases, services and components will help you prepare for this exam.

By passing exam 70-432, you earn the Microsoft Certified Technology Specialist (MCTS) SQL Server 2008 – Implementation and Maintenance certification.

You also earn credit toward the Microsoft Certified IT Professional (MCITP) Database Administrator certification.

Objective: Maintain SQL Server instances.
Sub-objective: Manage SQL Server Agent operators.

Single answer, multiple-choice

You manage a default instance of Microsoft SQL Server 2008. SQL Server Agent Mail is currently configured to use SQL Mail for sending e-mail notifications. SQL Server Agent is configured to start automatically any time you start the SQL Server Database Engine service.

You create a private database mail profile. You use sp_send_dbmail to test the profile and verify that it can be used to send mail. You configure SQL Server Agent Mail to use Database Mail and enable and select the profile you created. After configuring SQL Server Agent Mail to use Database Mail, the SQL Server Agent no longer sends notifications to any operators.

You need to correct the problem so that alert and job completion notification e-mails are sent to the designated…



Posted in Uncategorized|


Powered by WebDesk