Lead2pass New Microsoft 70-243 exam materials provided eliminates the tacky and laborious process of studying and memorization as it provides direct 70-243 questions and answers that will help you feel confident.

QUESTION 51
Your network contains a System Center 2012 Configuration Manger environment.
You need to create a collection that contains all of the virtual machines.
Which query should you use?

A.    select * from SMS_R_System
where SMS_R_System.ResourceID not in
(select ResourceID from SMS_R_System
where SMS_R_System.IsVirtualMachine != 1)
B.    select * from SMS_R_System
where SMS_R_System.IsVirtualMachine != 1
C.    select * from SMS_R_System
where SMS_R_System.IsVirtualMachine = 1
D.    select * from SMS_R_System
where SMS_R_System.ResourceID not in
(select ResourceID from|SMS_R_System
where SMS_R_System.IsVirtualMachine = 1)

Answer: C
Explanation:
SELECT all FROM Systems Table
WHERE System property IsVirtualMachine = TRUE

QUESTION 52
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 Site Repair Wizard.
B.    From Server1, run the Configuration Manager 2012 Setup Wizard.
C.    From Server2, run Microsoft SQL Server Management Studio, and then attach the backed up SQL Server database and log files.
D.    From Server2, run Microsoft SQL Server Management Studio, and then restore the backed up SQL Server database and log files.

Answer: B

QUESTION 53
Your network contains a System Center 2012 Configuration Manger environment.
You need to create a report that list 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 is IN
Add Remove Programs WHERE  DisplayName0 = ‘App1’
http://www.w3schools.com/sql/sql_join_inner.asp
SQL INNER JOIN Keyword
The INNER JOIN keyword returns rows when there is at least one match in both tables.

QUESTION 54
Your network contains a System Center 2012 Configuration Manager environment.
You create a report that lists compliance information.
You schedule the report to run every day at 20:00.
You need to ensure that on Friday, you can review the results of the report created on the previous Monday.
What should you configure the report to do?

A.    Use snapshots.
B.    Use caching.
C.    Render on Friday.
D.    Use a shared schedule.

Answer: A
Explanation:
http://technet.microsoft.com/en-us/library/ms156325.aspx
Creating, Modifying, and Deleting Snapshots in Report History
Report history is a collection of report snapshots.
You can maintain report history by adding and deleting snapshots, or by modifying properties that affect report history storage.
You can create report history manually or on a schedule.
Further information:
http://technet.microsoft.com/en-us/library/ms157447.aspx
Cache a Report (Report Manager)
One way to improve performance is to configure caching properties for a report. When a report is cached, a copy of the rendered report is saved for a short period of time. The first user who requests the report must wait for all processing to complete before viewing the report. Subsequent users who request the report within the caching period can view it right away because processing has already occurred.

QUESTION 55
Your company uses System Center 2012 Configuration Manager to distribute operating system images.
You receive 300 new client computers. All of the client computers have the same hardware configuration. When you attempt to deploy a Windows 7 image to one of the client computers, you receive an error message indicating that a storage device cannot be found during the pre-boot deployment phase.
You need to ensure that you can deploy Windows 7 to the new client computers by using an image.
What should you do?

A.    Import the storage drivers to the Drivers container and update the task sequence.
B.    Create a new driver package and update the task sequence.
C.    Update the existing boot image to include the storage drivers.
D.    Clear the contents of the Drivers container and update the task sequence.

Answer: C
Explanation:
http://technet.microsoft.com/en-us/library/gg712674.aspx
Planning a Device Driver Strategy in Configuration Manager
…
Planning a Device Driver Strategy in Configuration Manager
You can add Windows device drivers that have been imported into the driver catalog to boot images. Use the following guidelines when you add device drivers to a boot image:
* Add only mass storage and network adapter device drivers to boot images because other types of drivers are not generally required. Drivers that are not required increase the size of the boot image unnecessarily.
* Add only device drivers for Windows 7 to a boot image because the required version of Windows PE is based on Windows 7.
* Ensure that you use the correct device driver for the architecture of the boot image. Do not add an x86 device driver to an x64 boot image.

QUESTION 56
Note: This question is part of a series of questions that use the same set of answer choices.
An answer choice may be correct for more than one question in the series.
Your network contains a System Center 2012 Configuration Manager environment as shown in the exhibit. (Click the Exhibit button.)

The network contains six servers. The servers are configured as shown in the following table.

You need to ensure that mobile device information is available in the hardware inventory.
What should you do?

A.    Install a management point on Server5.
B.    Configure IIS to support only HTTPS on Server5.
C.    Install a management point on Server2.
D.    Install Network Load Balancing (NLB) on Server3.
E.    Install an enrollment proxy point on Server6.
F.    Configure IIS to support only HTTP on Server3.
G.    Configure the Exchange connector on Server3.
H.    Install Network Load Balancing (NLB) on Server6.
I.    Install a PXE-enabled protected distribution point on Server5.
J.    Install the Windows Cluster service on Server3.
K.    Install a PXE-enabled protected distribution point on Server4.
L.    Install the Windows Cluster service on Server6.
M.    Install Windows Server Update Services (WSUS) on Server3.
N.    Install a protected distribution point on Server1.
O.     Install a software update point on Server3.

Answer: G

QUESTION 57
Your network contains a System Center 2012 Configuration Manager environment.
You create two custom client agent settings named ClientSettings1 and ClientSettings2.
You apply ClientSettings1 to all of the client computers in the sales department.
You apply ClientSettings2 to all of the client computers in the marketing department.
The client computers in the marketing department contain several custom registry settings.
You need to collect the custom registry settings from the marketing department computers.
What should you do?

A.    Edit the default client agent settings and include the custom registry information.
B.    Edit ClientSettings2 and include the custom registry information.
C.    Create a new set of custom client agent settings for the marketing department and include the custom registry information.
D.    Edit ClientSettings2 and exclude the custom registry information.

Answer: C
Explanation:
http://technet.microsoft.com/en-us/library/gg682109#BKMK_CustomClientSettings
– Create a new set of custom client agent settings for the marketing department and include the custom registry information.
– Edit ClientSettings2 and include the custom registry information. <— probably not
Because editing isn’t that easy.
It is common sense, that you just add another client setting and deploy it to the collection.
Why? All settings can be separately deleted and especially named. Easier to handle.

QUESTION 58
Drag and Drop Question
Your network contains a System Center 2012 Configuration Manager environment.
You create a collection named All Marketing Users.
You need to inventory the desktop settings of the All Marketing Users collection.
What should you do?
To answer, move the four appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Answer:

QUESTION 59
Your network contains a System Center 2012 Configuration Manager environment.
You create a report named Report1. Report1 is used by multiple users.
Users report that it takes too long to load Report1.
You need to reduce the amount of time it takes to load Report1.
What should you do?

A.    Enable caching for the report.
B.    Decrease the Size of the ReportServer database.
C.    Decrease the session timeout value for the Reports website.
D.    Increase the size of the ReportServerTempDB database.

Answer: A
Explanation:
Report caching can shorten the time it takes for a user to retrieve a report, particularly if the
report is large or accessed frequently. When a report is requested, a query is sent to the database, an intermediate form of the report is cached on the report server, and the final
report is rendered to the end user. Report caching forces the intermediate version of the
report to be cached on the report server and provides a more consistent user experience
with a reduced load on the database.

QUESTION 60
Your company uses System Center 2012 Configuration Manager to deploy applications.
The company purchases a new application named Appl. App1 can be installed only on client computers that run Windows 7.
You need to ensure that App1 is installed only on Windows 7 computers that have at least 2 GB of memory and 300 GB of free disk space.
What should you create?

A.    a Query object
B.    custom client device settings
C.    requirement rules
D.    custom client user settings

Answer: C

Lead2pass Microsoft 70-243 exam pack will raise your capability to understand exam basics and fundamentals in a more organized and flexible way. Once you have prepared effectively through Microsoft 70-243 exam pack you can predict about exam difficulty level, accordingly you can take several measures to cope with such difficulties and pass your exam easily.

http://www.lead2pass.com/70-243.html