You are the network administrator for a company named Contoso, Ltd.
The network contains 1,000 desktop computers and 500 servers. The network contains a
System Center 2012 Configuration Manager environment.
The names of all the desktop computers in the human resources department start with the
letters HR, for example HR001 and HR023.
A device collection named All Server Devices contains all of the servers. A device collection
named All Desktop Devices contains all of the desktop computers.
You plan to create a new collection named All HR Computers and Servers.
The new collection must contain all of the human resources department computers and all of
the servers.
The collection must not contain any other computers.
You need to create a membership rule for the new collection.
Which rule should you include in the membership rule? (Choose all that Apply.)

A.
QUERY RULE: select * from SMS_R_System where SMS_R_system.NetbiosName like
“HR%”

B.
INCLUDE RULE: All Server Devices

C.
EXCLUDE RULE: All NON HR Computers

D.
EXCLUDE RULE: All Desktop Devices

E.
QUERY RULE- select * from SMS_R_System where
SMS_R_system.OperatingSystemNameandVersion like. *%Workstation*

F.
QUERY RULE- select * from SMS_R_System where
SMS_R_system.OperatingSystemNameandVersion not like. *%Server*

Explanation:
answer QUERY RULE: select * from SMS_R_System where
SMS_R_system.NetbiosName like “HR%”
INCLUDE RULE: All Server Devices
Select * from SMS_R_System where SMS_R_system.NetbiosName like “HR%”
SQL command to select all Systems whose names begin with HR
INCLUDE RULE: All Server Devices Selects all the Server Devices as asked in the question.
Further information:
http://technet.microsoft.com/en-us/library/gg682177.aspx
Introduction to Collections in Configuration Manager
Collections in System Center 2012 Configuration Manager represent logical groupings of
resources, such as users and devices. You can use collections to help you perform many
tasks, such as managing applications, deploying compliance settings, or installing software
updates. You can also use collections to manage groups of client settings.
Additionally, System Center 2012 Configuration Manager uses collections with role-based
administration to specify the collections that an administrative user can access.
Collection Rules
Direct Rule
Query Rule
Query rules dynamically update the membership of a collection based on a query that
Configuration
Manager runs on a schedule.
Unlike direct rule collections, this collection membership automatically updates when you
add or remove new users to the Human Resources organizational unit.
Include Collections Rule The include collections rule lets you include the members of
another collection in a Configuration Manager collection. Configuration Manager updates the
membership of the current collection on a schedule if the membership of the included
collection changes.
Exclude Collections Rule
The exclude collections rule lets you exclude the members of another collection from a
Configuration Manager collection. Configuration Manager updates the membership of the
current collection on a schedule if the membership of the excluded collection changes.
Note: If a collection includes both include collection and exclude collection rules and there is
a conflict, the exclude rule takes priority over the include rule.
Default Collections in Configuration Manager
All User Groups
All Users
All Users and User Groups
All Mobile Devices
All Systems
All Unknown Computers