70-243 Question #172: Real Exam Question with Answer & Explanation

The correct answer is A: Not in. To find computers that do NOT have a specific application installed, the WQL subquery must use 'Not in' to exclude resources that appear in a subquery matching the installed software.

Question

You have a System Center 2012 R2 Configuration Manager Service Pack 1 (SP1) deployment. You need to create a Configuration Manager solution to retrieve only the client computers that do not have Microsoft Office 2013 installed. You create a query. What should you include in the subquery?

Options

ANot in
BNot like
C< =
D!=

Explanation

To find computers that do NOT have a specific application installed, the WQL subquery must use 'Not in' to exclude resources that appear in a subquery matching the installed software.

Common mistakes.

B. 'Not like' is a pattern-matching operator used for string exclusion on a direct column value, not for excluding results returned by a subquery.
C. '<=' is a numeric comparison operator and has no logical relationship to excluding a set of results produced by a subquery.
D. '!=' compares a single value against another single value and cannot be used to exclude an entire result set produced by a subquery.

Concept tested. SCCM WQL subquery negation with Not in operator

Reference. https://learn.microsoft.com/en-us/mem/configmgr/core/servers/manage/create-queries

Community Discussion

No community discussion yet for this question.

Full 70-243 Practice