Microsoft
70-243 · Question #69
70-243 Question #69: Real Exam Question with Answer & Explanation
Sign in or unlock 70-243 to reveal the answer and full explanation for question #69. The question stem and answer options stay visible for context.
Managing Sites and Clients
Question
Your network contains a System Center 2012 Configuration Manger environment. You wirte the following query: select SYS.Name from SMS_R_System SYS join SMS_G_System_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 Microsoft Office installed. What should you add to the query?
Options
- Awhere ARP.DisplayName like "Microsoft Office*"
- Bwhere ARP.DisplayName = "Microsoft Office*"
- Cwhere ARP.DisplayName like "Microsoft Office%"
- Dwhere ARP.DisplayName = "%Microsoft Office"
Unlock 70-243 to see the answer
You've previewed enough free 70-243 questions. Unlock 70-243 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#WQL query#SMS_G_System_ADD_REMOVE_PROGRAMS#LIKE wildcard#software inventory query