Introducing The New!
Surepassexam Collection
Get Unlimited Access to all
Surepassexam's PREMIUM files
Q1. Your network contains a System Center 2012 Configuration Manager environment.
The environment contains a primary site server named Server1 and a server named
Server2 that runs Microsoft SQL Server 2008 R2.
Server2 contains the Configuration Manager database.
Server2 fails.
You install SQL Server 2008 R2 on a new server.
You name the server Server2.
You need to restore the Configuration Manager database to the new server.
What should you do?
A. From Server1, run the Configuration Manager 2012 Setup Wizard.
B. From Server2, run Microsoft SQL Server Management Studio, and then attach the backed up SQL Server database and log files.
C. From Server2, run Microsoft SQL Server Management Studio, and then restore the backed up SQL Server database and log files.
D. From Server1, run the Site Repair Wizard.
Answer: A
Explanation:
Answer is From Server1, run the Configuration Manager 2012 Setup Wizard. Recover a Configuration Manager Site
A Configuration Manager site recovery is required whenever a Configuration Manager site
fails or data loss occurs in the site database. Repairing and resynchronizing data are the
core tasks of a site recovery and are required to prevent interruption of operations. Site
recovery is started by running the Configuration Manager Setup Wizard from installation
media or by configuring the unattended installation script and then using the Setup
command /script option. Your recovery options vary depending on whether you have a
backup of the Configuration Manager site database.
Site Database Recovery Options
When you run Setup, you have the following recovery options for the site database:
* Recover the site database using a backup set: Use this option when you have a backup of the Configuration Manager site database that was created as part of the Backup Site Server maintenance task run on the site before the site database failure. When you have a hierarchy, the changes that were made to the site database after the last site database backup are retrieved from the central administration site for a primary site, or from a reference primary site for a central administration site. When you recover the site database for a stand-alone primary site, you lose site changes after the last backup. When you recover the site database for a site in a hierarchy, the recovery behavior is different for a central administration site and primary site, and when the last backup is inside or outside of the SQL Server change tracking retention period.
Reference: http://technet.microsoft.com/en-us/library/gg712697.aspx
Backup and Recovery in Configuration Manager
Q2. 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*
Answer: A,B
Explanation:
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.
Reference: Introduction to Collections in Configuration Manager
http://technet.microsoft.com/en-us/library/gg682177.aspx
Q3. Your network contains a single Active Directory domain.
You plan to deploy System Center 2012 Configuration Manager.
The hierarchy will have a Central Administration Site and five Primary Sites.
You need to ensure that you can target user groups for software distribution.
The solution must minimize network traffic.
Which Configuration Manager discovery method should you use?
A. Active Directory User Discovery and Active Directory Group Discovery on the primary sites
B. Active Directory User Discovery and Active Directory Group Discovery on the Central Administration site
C. Active Directory User Discovery on the Central Administration site and Active Directory Group Discovery on the primary sites
D. Active Directory User Discovery on the primary sites and Active Directory Group Discovery on every site
Answer: A
Reference: Planning for Discovery in Configuration Manager
https://technet.microsoft.com/en-us/library/gg712308.aspx
Q4. You deploy Windows 7 by using Operating System Deployment (OSD).
The development task sequence contains steps to install software updates and Applications.
The amount of time required to deploy the Windows 7 image has increased significantly during the last six months.
You need to recommend a solution to reduce the amount of time it takes to deploy the image.
What should you recommend?
A. Synchronize software updates before deploying the image.
B. Use offline servicing for the image.
C. Create a new automatic deployment rule.
D. Add an additional Install Software Updates step to the deployment task sequence.
E. Upgrade the image to Windows 7 SP1.
Answer: B,E
Explanation:
http://blogs.technet.com/b/inside_osd/archive/2011/04/18/configuration-manager-2012-offline-servicing-foroperating-system-images.aspx Configuration Manager 2012: Offline Servicing for Operating System Images In Configuration Manager 2012 there is a new feature for applying updates to operating system images while they are in the Configuration Manager library. This means any operating system image you see in the Operating Systems > Operating Systems Images node from the Software Library wunderbar can be updated with Component Based Servicing (CBS) updates. By updating an image in the Software Library instead of performing a new build and capture of the operating system image you will gain a few distinct advantages. You will be able to reduce the risk of vulnerabilities during operating system deployments and reduce the overall operating system deployment to the end user. You will also reduce the administrative effort to maintain your operating system images.
The feature is applicable for Component Based Servicing (CBS) updates and for the following operating systems: Microsoft Windows Vista SP2 and later Microsoft Windows Server 2008 SP2 and later Microsoft Windows 7 RTM Microsoft Windows 2008 R2 Further information: http://www.windows-noob.com/forums/index.php?/topic/4683-using-sccm-2012-rc-in-a-lab-part-12-updatingan-operating-system-image-using-offline-servicing/
Using SCCM 2012 RC in a LAB - Part 12. Updating an Operating System image using Offline Servicing.
Q5. Your network contains a System Center 2012 Configuration Manager environment.
You need to create a report that lists all of the client computers that have an application named App1 installed.
Which query should you use to create the report?
A. SELECT SYS.Netbios_Name0, ARP.DisplayName0 FROM v_R_Sytem AS SYS INNER JOIN v_GS_ADD_REMOVE_PROGRAMS AS ARP ON SYS.ResourceID = ARP.ResourceID WHERE ARP.DisplayName0 NOT LIKE 'App1'
B. SELECT SYS.Netbios_Name0 from v_R_System SYS WHERE SYS.ResourceID NOT IN (SELECT SYS.ResouceID FROM v_R_System AS SYS INNER JOIN v_GS_ADD_REMOVE_PROGRAMS AS ARP ON SYS.ResourceID = ARP.ResourceID WHERE ARP.DisplayName0 = 'App1')
C. SELECT SYS.Netbios_Name0, ARP.DisplayName0 FROM v_R_Sytem AS SYS INNER JOIN v_GS_ADD_REMOVE_PROGRAMS AS ARP ON SYS.ResourceID = ARP.ResourceID WHERE ARP.DisplayName0 NOT IN ('App1')
D. SELECT SYS.Netbios_Name0 from v_R_System SYS WHERE SYS.ResourceID IN (SELECT SYS.ResouceID FROM v_R_System AS SYS INNER JOIN v_GS_ADD_REMOVE_PROGRAMS AS ARP ON SYS.ResourceID = ARP.ResourceID WHERE ARP.DisplayName0 = 'App1')
Answer: D
Explanation:
SELECT computer name FROM table v_R_System (SQL Syntax)
WHERE resource ResourceID IN
Add Remove Programs WHERE DisplayName0 = 'App1'
SQL INNER JOIN Keyword
The INNER JOIN keyword returns rows when there is at least one match in both tables.
Reference: http://www.w3schools.com/sql/sql_join_inner.asp
Q6. Your network contains a System Center 2012 Configuration Manager environment.
You add a software update point to the environment.
You receive a message indicating that SMS WSUS Synchronization failed.
You need to retrieve additional information about the message.
Which log file should you review?
A. Locationservices.log
B. Smsexec.log
C. Ccm.log
D. Sdmagent.log
E. Dcmagent.log
F. Rcmctrl.log
G. Wsyncmgr.log
H. Ciagent.log
I. Hman.log
J. Contenttransfermanager.log
K. Sitestat.log
Answer: G
Explanation:
wsyncmgr.log Site server log file Records details about the software updates synchronization process.
Reference: http://technet.microsoft.com/en-us/library/hh427342.aspx
Technical Reference for Log Files in Configuration Manager
Q7. Your network contains a System Center 2012 Configuration Manager environment that contains six servers configured as shown in the following table:
Server5 and Server6 are in the perimeter network, while Server1, Server2, Server3, and Server4 are in the internal network.
A corporate security policy states that remote computers are forbidden to communicate directly with servers on the internal network.
You need to ensure that you collect inventory data from the remote computers.
What should you do?
A. Install Windows Server Update Services (WSUS) on Server3.
B. Configure the Exchange connector on Server3.
C. Install a management point on Server2.
D. Install a PXE-enabled protected distribution point on Server6.
E. Install a software update point on Server3.
F. Install Network Load Balancing (NLB) on Server6.
G. Install an enrollment proxy point on Server6.
H. Install the Windows Cluster service on Server3.
I. Install a protected distribution point on Server1.
J. Configure IIS to support only HTTPS on Server3.
K. Install a management point on Server5.
L. Install the Windows Cluster service on Server6.
M. Configure IIS to support only HTTP on Server5.
N. Install Network Load Balancing (NLB) on Server3.
O. Install a PXE-enabled protected distribution point on Server4.
Answer: K
Explanation:
The Management Point will collect all Client data and forward it to the Primary Site Server.
Reference: Planning for Communications in Configuration Manager
http://technet.microsoft.com/en-us/library/gg712701.aspx
Q8. You manage a System Center 2012 R2 Configuration Manager Service Pack 1 (SP1) stand-alone primary site.
You have a configuration item named Item1 that has two revisions. The current revision is not referenced by any configuration baselines.
You need to reconfigure Item1 to use the previous settings, and then you must modify the detection method of Item1.
What should you do?
A. Restore the previous version. Modify revision 2.
B. Restore the previous version. Modify revision 1.
C. Delete the current version. Modify revision 1.
D. Copy the previous version. Modify revision 2.
Answer: B
Q9. HOTSPOT
You manage a System Center 2012 R2 Configuration Manager Service Pack 1 (SP1) site.
You plan to create two collections named Collection1 and Collection2 that have dynamic membership rules. Collection1 will contain all of the servers in the domain. Collection2 will contain only the domain controllers.
You have a Configuration Manager query that you will use as the basis for creating the collection. The query has the following WQL statement.
You need to complete the statement that will be used for each collection.
Which class and attribute should you add in the where clause for each collection? To answer, select the appropriate options in the answer area.
Answer:
Q10. You deploy Windows 7 by using Operating System Deployment (OSD).
The development task sequence contains steps to install software updates and Applications.
The amount of time required to deploy the Windows 7 image has increased significantly during the last six months.
You need to recommend a solution to reduce the amount of time it takes to deploy the image.
What should you recommend?
A. Synchronize software updates before deploying the image.
B. Use offline servicing for the image.
C. Create a new automatic deployment rule.
D. Add an additional Install Software Updates step to the deployment task sequence.
Answer: B
Explanation:
http://blogs.technet.com/b/inside_osd/archive/2011/04/18/configuration-manager-2012-offline-servicing-foroperating-system-images.aspx
Configuration Manager 2012: Offline Servicing for Operating System Images In Configuration Manager 2012 there is a new feature for applying updates to operating system images while they are in the Configuration Manager library. This means any operating system image you see in the Operating Systems > Operating Systems Images node from the Software Library wunderbar can be updated with Component Based Servicing (CBS) updates. By updating an image in the Software Library instead of performing a new build and capture of the operating system image you will gain a few distinct advantages. You will be able to reduce the risk of vulnerabilities during operating system deployments and reduce the overall operating system deployment to the end user. You will also reduce the administrative effort to maintain your operating system images.
The feature is applicable for Component Based Servicing (CBS) updates and for the following operating systems: Microsoft Windows Vista SP2 and later Microsoft Windows Server 2008 SP2 and later Microsoft Windows 7 RTM Microsoft Windows 2008 R2 Further information: http://www.windows-noob.com/forums/index.php?/topic/4683-using-sccm-2012-rc-in-a-lab-part-12-updatingan-operating-system-image-using-offline-servicing/using SCCM 2012 RC in a LAB - Part 12. Updating an Operating System image using Offline Servicing.
Q11. Your network contains a System Center 2012 Configuration Management environment.
The network contains 10 database servers that run Microsoft SQL Server 2008.
You have a configuration baseline that is used to monitor database servers.
You confirm that all of the database servers downloaded the configuration baseline.
You discover that a database server named Server1 fails to report any data for the configuration baseline.
You need to identify whether Server 1 evaluates the configuration items that are part of the configuration baseline.
Which log file should you review?
A. Locationservices.log
B. Smsexec.log
C. Ccm.log
D. Sdmagent.log
E. Dcmagent.log
F. Rcmctrl.log
G. Wsyncmgr.log
H. Ciagent.log
I. Hman.log
J. Contenttransfermanager.log
K. Sitestat.log
Answer: E
Explanation:
DCMAgent.log Client log file Records high-level information about the evaluation, conflict reporting, and remediation of configuration items and applications.
Reference: http://technet.microsoft.com/en-us/library/hh427342.aspx
Technical Reference for Log Files in Configuration Manager
Q12. Your network contains a System Center 2012 Configuration Manager environment.
The hierarchy contains a Central Administration Site named Site1 and a primary site named Site2.
You discover that none of the collections created on Site1 are displayed on Site2.
You need to identify whether there is replication issue between the sites.
What should you review?
A. the Colleval.log file.
B. the Despool.log file
C. the Rcmctrl.log file
D. the Sender.log file
Answer: C
Explanation:
Technical Reference for Log Files in Configuration Manager - Site Server and Site System
Server Logs rcmctrl.log:
Site server log file Records the activities of database replication between sites in the
hierarchy.
Reference: Technical Reference for Log Files in Configuration Manager - Site Server and
Site System
http://technet.microsoft.com/en-us/library/hh427342.aspx#BKMK_SiteSiteServerLog
Q13. HOTSPOT
Your network contains a System Center 2012 Configuration Manager environment.
You deploy an application to 1,000 client computers.
You need to identify which client computers are in the process of installing the application.
Which node should you select in the Configuration Manager console?
To answer, select the appropriate node in the answer area.
Answer:
Q14. DRAG DROP
Your company has two offices named Office1 and Office2.
You plan to deploy a System Center 2012 R2 Configuration Manager Service Pack 1 (SP1) Central Administrative site to Office1 and a primary site to Office2.
You need to identify which firewall ports you must allow between Office1 and Office2 for inter-site communication.
Which firewall ports should you identify? To answer, drag the appropriate ports to the correct locations. Each port may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
Answer:
Q15. Your network contains a System Center 2012 R2 Configuration Manager Service Pack 1 (SP1) environment.
You are creating a configuration item that contains application settings for Microsoft Office 2013.
You need to detect whether Office 2013 is installed before validating the configuration item.
What should you do?
A. Set Software Inventory to True.
B. Create a report to display all installed software.
C. Set Hardware Inventory to False.
D. Enable Use a custom script to detect this application.
Answer: D
Explanation: A detection method in Configuration Manager contains rules that check whether an application is already installed on a device. This detection occurs before the application is installed, immediately after the application is installed, and at regular intervals afterward. This detection can prevent Configuration Manager from needlessly reinstalling the application and can also determine whether the user has already uninstalled the application. A custom script can be used to determine the presence of a deployment type.
Note: A System Center 2012 Configuration Manager application contains the files and information that are required to deploy software to a device. An application contains one or more deployment types that comprise the installation files and information that are required to install software. A deployment type also contains rules that specify when and how the software is deployed.
Reference: How to Create Applications in Configuration Manager
https://technet.microsoft.com/library/gg682159.aspx#BKMK_Step4
Q16. Your network contains a System Center 2012 Configuration Manager environment. The environment contains a reporting services point.
A group of users is responsible for creating custom reports. The custom reports will be published.
You need to identify which tools can be used to create and publish custom reports to Microsoft SQL Server Reporting Services (SSRS).
Which tools should you identify? (Choose all that apply.)
A. Report Builder
B. Microsoft SQL Server Business Intelligence Development Studio
C. Microsoft Access 2010
D. Reporting Services Configuration Manager
E. Microsoft SQL Server Management Studio
Answer: A,B
Explanation:
Overview of Custom Reports Custom reports are intended for advanced users who are comfortable creating their own reports by using Microsoft SQL Server Reporting Services and SQL Server Business Intelligence Development Studio, SQL Server Reporting Services Report Builder, or Microsoft Visual Studio Report Designer.
Reference: Overview of Custom Reports
http://technet.microsoft.com/en-us/library/gg508710.aspx