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 W
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.