YOU ARE TASKED TO IDENTIFY ALL SQL SERVERS THAT ARE RUNNING SQL SE...

17. You are tasked to identify all SQL servers that are running SQL Server 2005 or earlier within your organization. What is the best way to accomplish this task with minimum administrative effort?A. Use Policy-Based Management to create a policy condition for the Server Information facet, VersionMajor >= 9. Create a policy linking this condition with a target set of all servers. Evaluate the policy to identify servers that don’t comply with this policy.B. Use Policy-Based Management to create a policy condition for the Server Information facet, VersionMajor <= 9. Create a policy linking this condi-tion with a target set of all servers. Evaluate the policy to identify servers that don’t comply with this policy.C. Run the SELECT @@Version statement against every SQL Server in the organization.D. Run the SELECT Version from sys.ServerInfo.