You are a professional level SQL Sever 2008 Database Administrator in an international corporation
named Wiikigo. You are experienced in managing databases in an enterprise-level organization,optimizing
and sustaining the database life cycle.
In the company, your job is to implement solutions on security, troubleshooting, deployment and optimization.
A SQL Server 2008 infrastructure is managed by you. 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 Invoke-Sqlcmd cmdlet in SQL Server PowerShell cmdlet.
B.
To finish the task, you should utilize the ExecuteWQL function to define policies based on conditions.
C.
To finish the task, you should utilize the Windows Management Instrumentation (WMI) provider for the server events.
D.
To finish the task, you should utilize the ExecuteSql function to define policies based on conditions.