You administer a SQL Server 2008 instance. You plan to deploy multiple databases to the instance. You design the security policy for the instance. A stored procedure verifies the partition…

Question

Options

• AEnable the nested triggers server configuration option.
• BGrant EXECUTE permissions on the stored procedure to the SQLAgent service account.
• CGrant EXECUTE permissions on the stored procedure to the
• DGrant EXECUTE permissions on the stored procedure to the

• A
  7% (4)
• B
  4% (2)
• C
  77% (43)
• D
  13% (7)

Explanation

The correct answer should be A or C because the two options are necessary to the policy be But as the question specifies the security policy context, the right answer would be C. "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." "The proxy account is called ##MS_PolicyTsqlExecutionLogin##. You'll find this login under the "Logins" folder in Management Studio and master.sys.syslogins. By default the login has very limited permissions. You will likely need to extend the privileges of this user to accommodate the SQL you need to run Note: Every permission you grant to ##MS_PolicyTsqlExecutionLogin## you are effectively granting that permission to all users in the Policy Administrator role."

No community discussion yet for this question.