nerdexam
Microsoft

70-450 · Question #15

You administer a SQL Server 2008 infrastructure. You plan to design a solution to obtain hardware configurations, such as the number of processors on a computer and the processor type of all SQL…

The correct answer is C. Define policies based on conditions by using the ExecuteWQL function. 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…

Design and implement an optimized monitoring strategy

Question

You administer a SQL Server 2008 infrastructure. You plan to design a solution to obtain hardware configurations, such as the number of processors on a computer and the processor type of all SQL Server 2008 computers. The solution must meet the following requirements:

  • It is hosted on the central computer.
  • It can verify hardware configurations for multiple servers.

You need to select a technology that meets the requirements by using the minimum amount of development effort. What should you do?

Options

  • AUse the Invoke-Sqlcmd cmdlet in SQL Server PowerShell cmdlet.
  • BDefine policies based on conditions by using the ExecuteSql function.
  • CDefine policies based on conditions by using the ExecuteWQL function.
  • DUse the Windows Management Instrumentation (WMI) provider for the server events.

How the community answered

(29 responses)
  • A
    3% (1)
  • B
    10% (3)
  • C
    83% (24)
  • D
    3% (1)

Explanation

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

Topics

#Policy-Based Management#ExecuteWQL function#WMI#hardware configuration

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-450 Practice