You are the administrator of your company network. And you’re in charge of a SQL Server 2008 infrastructure. Now you want to obtain hardware configurations, such as the processor type of all SQL Server 2008 computers. So you have to develop a solution to achieve this. The solution you develop must be hosted on the central computer and can verify hardware configurations for multiple servers. You have to choose a technology that satisfy the two requirements above, while using as little development effort as possible. So what should you do?
A.
You should use the Invoke-Sqlcmd cmdlet in SQL Server PowerShell cmdlet.
B.
You should use the ExecuteWQL function to define policies based on conditions.
C.
You should use the ExecuteSql function to define policies based on conditions.
D.
You should use the Windows Management Instrumentation (WMI) provider for the server events.