You work as the network database administrator at MiracleInfocom .com. The MiracleInfocom .com network consists of a single Active Directory domain named MiracleInfocom .com. All servers on the MiracleInfocom .com network run Windows Server 2003 and all client computers run Windows XP Professional. The MiracleInfocom .com network contains a Microsoft SQL Server 2005 database server named MiracleInfocom -DB01 which you administer. You have received instruction from the CIO to install and configure an additional database server named MiracleInfocom -DB02 which will be maintained using scheduled Maintenance Plans. You configure the settings so that if a Maintenance Plan fails the server will send you an e-mail. You are required to configure the surface area of MiracleInfocom -DB02 to support the required functionality whilst keeping your solution as secure as possible. What should you do?
A. Service Broker endpoints should be enabled.
B. The SQL Server Browser service must be configured to start automatically.
C. SQL Mail should be enabled.
D. The SQL Server Agent service must be configured to start automatically.
Answer:D
You work as the network database administrator at MiracleInfocom .com. The MiracleInfocom .com network consists of a single Active Directory domain named MiracleInfocom .com. All servers on the MiracleInfocom .com network run Windows Server 2003 and all client computers run Windows XP Professional. The MiracleInfocom .com network contains a Microsoft SQL Server 2005 database server named MiracleInfocom -DB01 which you administer. You have received instruction from the CIO to install and configure an additional database server named MiracleInfocom -DB02 which will be maintained using scheduled Maintenance Plans. You configure the settings so that if a Maintenance Plan fails the server will send you an e-mail. You are required to configure the surface area of MiracleInfocom -DB02 to support the required functionality whilst keeping your solution as secure as possible. What should you do?
A. Service Broker endpoints should be enabled. B. The SQL Server Browser service must be configured to start automatically. C. SQL Mail should be enabled. D. The SQL Server Agent service must be configured to start automatically.