70-450 · Question #56
Your organization has many servers that run SQL Server 2008. You define a rule to ensure that all database servers have Database Mail disabled. You need to be able to identify and resolve any…
The correct answer is D. Define a SQL Server policy and import it on each database server. "Policy-Based Management would be helpful in resolving the issues presented in the following A company policy prohibits enabling Database Mail or SQL Mail. A policy is created to check the server state of those two features. An administrator compares the server state to the…
Question
Your organization has many servers that run SQL Server 2008. You define a rule to ensure that all database servers have Database Mail disabled. You need to be able to identify and resolve any violation of the rule by using the minimum amount of administrative effort. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
Options
- ADefine a scheduled task on each server.
- BDefine a SQL job on each database server.
- CDefine a maintenance plan on each database server.
- DDefine a SQL Server policy and import it on each database server.
How the community answered
(24 responses)- A13% (3)
- B4% (1)
- C4% (1)
- D79% (19)
Explanation
"Policy-Based Management would be helpful in resolving the issues presented in the following A company policy prohibits enabling Database Mail or SQL Mail. A policy is created to check the server state of those two features. An administrator compares the server state to the policy. If the server state is out of compliance, the administrator chooses the Configure mode and the policy brings the server state into compliance.
Topics
Community Discussion
No community discussion yet for this question.