Microsoft
70-243 · Question #42
70-243 Question #42: Real Exam Question with Answer & Explanation
The correct answer is D: where ARP.DisplayName like "Visual studio%". You need to use "Like" not "=" otherwise the WildCard "%" is seen as a real identifier. Better to use % compared to *. With % you would only get different versions of Visual Studio and not other applications with names starting with Visual Studio.
Question
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?
Options
- Awhere ARP.DisplayName like "Visual Studio*"
- Bwhere ARP.DisplayName = "Visual Studio"
- Cwhere ARP.DisplayNarae = "%%Visual Studio"
- Dwhere ARP.DisplayName like "Visual studio%"
Explanation
You need to use "Like" not "=" otherwise the WildCard "%" is seen as a real identifier. Better to use % compared to *. With % you would only get different versions of Visual Studio and not other applications with names starting with Visual Studio.
Community Discussion
No community discussion yet for this question.