PrepAway - Latest Free Exam Questions & Answers

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?

PrepAway - Latest Free Exam Questions & Answers

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