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?
A.
Use the Invoke-Sqlcmd cmdlet in SQL Server PowerShell cmdlet.
B.
Define policies based on conditions by using the ExecuteSql function.
C.
Define policies based on conditions by using the ExecuteWQL function.
D.
Use the Windows Management Instrumentation (WMI) provider for the server events.
Explanation: