What should you do to select a technology that meets the requirements?

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?

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.



Leave a Reply 0

Your email address will not be published. Required fields are marked *