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 number of processors on a computer and the processor type of
all SQL Server 2008 computers. The requirements listed below should be satisfied by the
solution. The solution should be hosted on the central computer. And the hardware
configurations for multiple servers should be verified by the solution. A technology should be
selected to satisfy the requirements, and the least amount of development effort should be
utilized. Which action should you perform to finish the task?
A.
To finish the task, you should utilize the ExecuteWQL function to define policies based on
conditions.
B.
To finish the task, you should utilize the Windows Management Instrumentation (WMI)
provider for the server events.
C.
To finish the task, you should utilize the Invoke-Sqlcmd cmdlet in SQL Server PowerShell
cmdlet.
D.
To finish the task, you should utilize the ExecuteSql function to define policies based on
conditions.