Your network contains a System Center 2012 Configuration Manager environment.
You write the following query:
select SYS.Name from SMS_R_System SYS
join SMS_G_Syatem_ADD_REMOVE_PROGRAMS ARP
on ARP.ResourceId = SYS.ResourceId
You need to create a list of all the client computers that have a version of Visual Studio installed.
What should you add to the query?
A.
where ARP.DisplayName like “Visual Studio*”
B.
where ARP.DisplayName = “*Visual Studio*”
C.
where ARP.DisplayName = “%%Visual Studio”
D.
where ARP.DisplayName like “Visual studio%”
http://technet.microsoft.com/en-us/library/bb694123
For relational operators that perform LIKE comparisons (“is like” or “is not like”), you can use wildcard characters within the string. You can use the following wildcards.
Wildcard Description
%
Any string of zero or more characters
_ (underscore)
Any single character
[]
Any single character within the range or set (for example [a-f] or [abcdef])
[^]
Any single character not within the specified range (for example [^a-f] or [^abcdef])
so answer is D
D