70-243 · Question #104
You have a System Center 2012 R2 Configuration Manager Service Pack 1 (SP1) deployment. You plan to create a Configuration Manager query. You need to identify which components can be included in the…
The correct answer is A. Criteria D. Omit duplicate rows E. Joins. WQL statements in Configuration Manager queries support three structural components: criteria, duplicate row filtering, and joins between WMI classes.
Question
You have a System Center 2012 R2 Configuration Manager Service Pack 1 (SP1) deployment. You plan to create a Configuration Manager query. You need to identify which components can be included in the WQL statement. Which three components should you identify? Each correct answer presents a complete solution.
Options
- ACriteria
- BCollection limiting
- CSecurity
- DOmit duplicate rows
- EJoins
How the community answered
(47 responses)- A89% (42)
- B9% (4)
- C2% (1)
Why each option
WQL statements in Configuration Manager queries support three structural components: criteria, duplicate row filtering, and joins between WMI classes.
Criteria maps to the WHERE clause in WQL, allowing you to filter returned instances based on attribute values - this is a core WQL statement component.
Collection limiting is a property of Configuration Manager collections themselves, not a component of the underlying WQL query statement.
Security is a Configuration Manager console concept applied to objects via role-based administration, not a component of a WQL query statement.
Omit duplicate rows maps to the DISTINCT keyword in WQL, which eliminates duplicate result rows returned by the query.
Joins allow a WQL statement to combine data from multiple WMI classes in a single query, which is a supported WQL construct in Configuration Manager.
Concept tested: WQL query statement components in SCCM
Source: https://learn.microsoft.com/en-us/mem/configmgr/core/servers/manage/introduction-to-queries
Topics
Community Discussion
No community discussion yet for this question.