You are a professional level SQL Sever 2008 Database Administrator. Your company wants to enforce naming standards for the database objects. A solution should be designed by you to enforce naming…

Question

Options

• APolicy-Based Management policies should be created, and then the policies should be
• BEvent notifications should be utilized to handle the DDL events.
• CDDL triggers should be created for one of the instances, and then SQL Server
• DDDL triggers should be created for one of the instances, and then Microsoft SQL Server

• A
  72% (28)
• B
  8% (3)
• C
  5% (2)
• D
  15% (6)

Explanation

Policy-Based Management is a system for managing one or more instances of SOL Server 2008. When SQL Server policy administrators use Policy-Based Management, they use SOL Server Management Studio to create policies to manage entities on the server, such as the instance of SOL Server, databases, or other SOL Server objects. Policy-Based Management has three components: - Policy management - Policy administrators create policies. - Explicit administration Administrators select one or more managed targets and explicitly check that the targets comply with a specific policy, or explicitly make the targets comply with a policy. Evaluation modes There are four evaluation modes, three of which can be automated: On demand. This mode evaluates the policy when directly specified by the user. On change: prevent. This automated mode uses DDL triggers to prevent policy violations. It the nested triggers server configuration option is disabled, OI1 change: prevent will not work correctly. Policy-Based Management relies on DDL triggers to detect and roll back DDL operations that do not comply with policies that use this evaluation mode. Fiemoving the Policy- Based Management DDL triggers or disabling nest triggers, will cause this evaluation mode to fail or perform unexpectedly. On change: log only. This automated mode uses event notification to evaluate a policy when a relevant change is made. On schedule. This automated mode uses a SOL Server Agent job to periodically evaluate a When automated policies are not enabled, Policy-Based Management will not affect system

No community discussion yet for this question.