70-450 · Question #23
You administer a SQL Server 2008 instance. Your company security policy is designed to prevent changes to the server to the server configuration. You plan to use Policy-Based Management Framework to…
The correct answer is C. Enable the nested triggers server configuration option. "If the nested triggers server configuration option is disabled, On 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. Removing the…
Question
You administer a SQL Server 2008 instance. Your company security policy is designed to prevent changes to the server to the server configuration. You plan to use Policy-Based Management Framework to implement the security policy. You need to ensure that the policy is configured to meet the security requirement. What should you do?
Options
- AUse a domain account for the SQLAgent service.
- BUse the Local Service account for the SQLAgent service.
- CEnable the nested triggers server configuration option.
- DDisable the nested triggers server configuration.
How the community answered
(45 responses)- A13% (6)
- B4% (2)
- C78% (35)
- D4% (2)
Explanation
"If the nested triggers server configuration option is disabled, On 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. Removing the Policy-Based Management DDL triggers or disabling nest triggers, will cause this evaluation mode to fail or perform unexpectedly."
Topics
Community Discussion
No community discussion yet for this question.