Actual 70-243 Exam Questions Offered By PassLeader [PDF & VCE] (31-40)

Vendor: Microsoft

 

Exam Code: 70-243

 

Exam Name: Administering and Deploying System Center 2012 Configuration Manager

 

Question 31 — Question 40

 

Visit PassLeader and Download Full Version 70-243 Exam Dumps – http://www.passleader.com/70-243.html

 

QUESTION 31

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. Your company develops a custom hardware device and installs the device on all of the client computers in the research department. You discover that information about the device fails to appear in any inventory queries or reports. Information about other hardware devices appears in the inventory queries and reports. You need to ensure that Configuration Manager Data includes information about the custom hardware device. What should you do?

 

A.    Enable a default WMI class in the Hardware Inventory Classes list.

B.    Modify the Enable hardware inventory on clients setting.

C.    Add a WMI class to the Hardware inventory Classes list.

D.    Add a file name to the Software Inventory configuration.

E.    Select Collect NOIDMIF files in Hardware Inventory.

F.    Add a file name to the Hardware inventory configuration.

G.    Add a file name to Software Metering.

H.    Add a WMI class to the Sms_def.mof file.

I.     Modify the Enable software inventory on clients setting.

Answer: C

 

QUESTION 32

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. Your company deploys a custom Application to 2,000 client computers by using Configuration Manager. The Application is not listed in Add Remove Programs. You discover that information about the Application fails to appear in the inventory queries and inventory reports. You verify that information about other Applications appear in the inventory reports. You need to ensure that Configuration Manager Data includes installation information about the custom Application. What should you do?

 

A.    Add a file name to Software Metering.

B.    Add a WMI class to the Hardware Inventory Classes fat

C.    Add a file name to the Hardware Inventory configuration.

D.    Enable a default WMI Cass in the Hardware Inventory Classes list.

E.    Select Collect NOIDMIF files .n Hardware Inventory.

F.    Add a file name to the Software Inventory configuration.

G.    Modify the Enable hardware inventory on Cents setting.

H.    Add a WMI class to the Sms_def.mof file.

 

Answer: F

Explanation:

http://technet.microsoft.com/en-us/library/cc180952.aspx#EBAA

 

QUESTION 33

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. Your company deploys a third-party Application to 10,000 client computers. You need to ensure that you can run a report that lists all of the client computers that ran the Application last month. What should you do?

 

A.    Modify the Enable hardware inventory on clients setting.

B.    Enable a default WMI class in the Hardware Inventory Classes list.

C.    Modify the Enable software inventory on clients setting.

D.    Add a file name to the Hardware Inventory configuration.

E.    Add a WMI class to the Hardware Inventory Classes list.

F.    Add a file name to the Software Inventory configuration.

G.    Add a file name to Software Metering.

H.    Add a WMI class to the Sms_def.mof file.

I.     Select Collect NOIDMIF files in Hardware Inventory.

 

Answer: G

Explanation:

http://technet.microsoft.com/en-us/library/gg682005.aspx

Introduction to Software Metering in Configuration Manager

Use software metering in System Center 2012 Configuration Manager to monitor and collect software usage data from Configuration Manager Clients. To collect this usage data, configure software metering rules or use the Configuration Manager inventory to generate these rules automatically. Client computers evaluate these rules and collect metering data to send to the site.

 

QUESTION 34

Your network contains a System Center 2012 Configuration Manager environment. You need to create a report that lists all of the client computers that do not have an Application named App1 instated. Which query should you use to create the report?

 

A.    SELECT SYS.Netbios_Name0, ARP.DisplayName0

FROM v_R_System AS SYS INNER JOIN

v_GS_ADD_REMOVE_PROGRAMS AS ARP ON SYS.ResourceID = ARP.

ResourceID WHERE ARP.DisplayName0 NOT IN (‘App1’)

B.    SELECT SYS.Netbios_Name0 from v_R_System SYS

WHERE SYS.ResourceID IN

(SELECT SYS.ResourceID

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 from v_R_System SYS

WHERE SYS.ResourceID NOT IN

(SELECT SYS.ResourceID

FROM v_R_System AS SYS INNER JOIN

v_GS_ADD_REMOVE_PROGRAMS AS ARP ON SYS.ResourceID = ARP.

ResourceID WHERE ARP.

DisplayName0 = ‘App1’)

D.    SELECT SYS.Netbios_Name0, ARP.DisplayName0

FROM v_R_System AS SYS INNER JOIN

V_GS_ADD_REMOVE_PROGRAMS AS ARP ON SYS.ResourceID – ARP.

ResourceID WHERE ARP.

DisplayName0 NOT LIKE ‘App1’

 

Answer: C

Explanation:

SELECT computer name FROM table v_R_System (SQL Syntax)

WHERE resource ResourceID is NOT 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 35

Network contains a System Center 2012 Configuration Manager environment. You have the following query:

Select

R.Name,

U.UserName

from

SMS_R_System R

join SMS_R_User U

on R.LastLogonUserName = U.UserName

You need to ensure that all of the client computers are listed in the query results. Which join type should you use?

 

A.    LEFT

B.    FULL

C.    INNER

D.    RIGHT

 

Answer: A

Explanation:

http://www.w3schools.com/sql/sql_join_left.asp

SQL LEFT JOIN Keyword

The LEFT JOIN keyword returns all rows from the left table (table_name1), even if there are no matches in the right table (table_name2).

Further information:

http://www.w3schools.com/sql/sql_join_full.asp

SQL FULL JOIN Keyword

The FULL JOIN keyword return rows when there is a match in one of the tables.

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.

http://www.w3schools.com/sql/sql_join_right.asp

SQL RIGHT JOIN Keyword

The RIGHT JOIN keyword returns all the rows from the right table (table_name2), even if there are no matches in the left table (table_name1).

 

QUESTION 36

Your network contains a System Center 2012 Configuration Manager environment. You write the following query:

select SYS.Name from SMS_R_System SYS

join SMS_G_Syatem_ADD_REMOVE_PROGRAMS ARP

on ARP.ResourceId = SYS.ResourceId

You need to create a list of all the client computers that have a version of Visual Studio installed. What should you add to the query?

 

A.    where ARP.DisplayName like “Visual Studio*”

B.    where ARP.DisplayName = “*Visual Studio*”

C.    where ARP.DisplayNarae = “%%Visual Studio”

D.    where ARP.DisplayName like “Visual studio%”

 

Answer: D

Explanation:

You need to use “Like” not “=” otherwise the WildCard “%” is seen as a real identifier. Better to use % compared to *. With % you would only get different versions of Visual Studio and no other applications with names starting with Visual Studio.

 

QUESTION 37

Your network contains a System Center 2012 Configuration Manager environment. You need to receive an email message every day that lists all non-compliant clients. What should you do?

 

A.    Create an alert subscription.

B.    Configure a Microsoft SQL Server Reporting Services (SSRS) report.

C.    Configure an in-console alert.

D.    Create a ConfigMgr query.

 

Answer: C

Explanation:

http://myitforum.com/myitforumwp/2012/06/26/client-health-check-in-configmgr-2012in-actionpart-2/

http://technet.microsoft.com/en-us/library/hh427334.aspx

 

QUESTION 38

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: ABD

Explanation:

A: http://technet.microsoft.com/en-us/library/hh213578.aspx

B: http://en.wikipedia.org/wiki/Business_Intelligence_Development_Studio

D: http://technet.microsoft.com/en-us/library/ms156305.aspx

 

QUESTION 39

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 40

Your network contains a System center 2012 Configuration Manager environment. You are creating a configuration item that contains application settings for Microsoft Office 2010. You need to detect whether Office 2010 is installed before validating the configuration item. What should you do?

 

A.    Create a report to display all installed software.

B.    Enable Use a custom script to detect this application.

C.    Create a direct membership collection.

D.    Create an automatic deployment rule.

 

Answer: B

 

Visit PassLeader and Download Full Version 70-243 Exam Dumps – http://www.passleader.com/70-243.html