You are a professional level SQL Sever 2008 Database Administrator. A solution will be implemented to have hardware configurations obtained. The hardware configuration obtained should include the…

Question

Options

• ATo finish the task, you should utilize the Invoke-Sqlcmd cmdlet in SQL Server PowerShell
• BTo finish the task, you should utilize the ExecuteWQL function to define policies based on
• CTo finish the task, you should utilize the Windows Management Instrumentation (WMI)
• DTo finish the task, you should utilize the ExecuteSql function to define policies based on

• A
  4% (1)
• B
  73% (19)
• C
  8% (2)
• D
  15% (4)

Explanation

Policy-Based Management is a system for managing one or more instances of SOL Server 2008. When SOL 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, OI'! change: pI'BV6I`Il 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. 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 altect system ExecuteWQL is a relatively straightforward way to query operating system data from SQL server. It can then be stored in a database for analysis. The Invoke-Sqlcmd cmdlet is a powershell cmdlet for executing sql commands. It doesn't apply well to the question. WMI is a driver extension with scripting language and could theoretically be used to accomplish the goal, but with a much more complex development process. EXECUTESQL is a SQL command for running a pre-built SQL statement

No community discussion yet for this question.