Microsoft MCTS 70-543시험은 멋진 IT전문가로 거듭나는 길에서 반드시 넘어야할 높은 산입니다. Microsoft MCTS 70-543시험문제패스가 어렵다한들 Pass4Test덤프만 있으면 패스도 간단한 일로 변경됩니다. Pass4Test의 Microsoft MCTS 70-543덤프는 100%시험패스율을 보장합니다.Microsoft MCTS 70-543시험문제가 업데이트되면 Microsoft MCTS 70-543덤프도 바로 업데이트하여 무료 업데이트서비스를 제공해드리기에 덤프유효기간을 연장해는것으로 됩니다.

 

NO.1 You are creating an application by using Visual Studio Tools for the Microsoft Office System

(VSTO). The application edits a Microsoft Office Word 2007 document. The Word document contains

two XML parts. The second custom XML part is used to audit changes to the first custom XML part.

You need to ensure that the application adds a new element to the second XML part each time the

value of a text node in the first XML part is changed. What should you do?

A. Modify the StreamAfterAdd event for the CustomXMLParts collection.

B. Modify the StreamAfterLoad event for the CustomXMLParts collection.

C. Modify the NodeAfterInsert event for the first CustomXMLPart object.

D. Modify the NodeAfterReplace event for the first CustomXMLPart object.

Answer: D

 

NO.2 You are creating a custom template for Microsoft Office Word 2007 by using Visual Studio Tools

for the Microsoft Office System (VSTO).

The template contains a custom XML part that consumes data from an XML source. The XML source

contains the following XML fragment.

<Products> mother board, memory, hard drive,

floppy drive, DVD drive </Products>

You need to display the Products element as a comma-separated list within a paragraph of text.

Which code segment should you use?

A. Application.ActiveDocument.ContentControls.Add _

(WdContentControlType.wdContentControlRichText, range)

B. Application.ActiveDocument.ContentControls.Add _

(WdContentControlType.wdContentControlText, range)

C. Application.ActiveDocument.ContentControls.Add _

(WdContentControlType.wdContentControlDropdownList, range)

D. Application.ActiveDocument.ContentControls.Add _

(WdContentControlType.wdContentControlCombobox, range)

Answer: B

 

NO.3 You create a document-level solution for Microsoft Office Excel by using Visual Studio Tools for

the Microsoft Office System (VSTO). You manually deploy the customized Excel workbook and the

associated assembly to a network share named OfficeSolutions. The network share is located on a

server named LONDON. You need to remove the reference to the assembly from the copy of the

workbook. Which code segment should you use?

A. ServerDocument sd = new ServerDocument (@"\\LONDON\OfficeSolutions\Finance.xls");

sd.AppManifest.Clear ();

B. ServerDocument sd = new ServerDocument (@"\\LONDON\OfficeSolutions\Finance.xls");

sd.AppManifest.EntryPoints.Clear ();

C. ServerDocument sd = new ServerDocument (@"\\LONDON\OfficeSolutions\Finance.xls");

sd.AppManifest.DeployManifestPath.Remove (0);

D. ServerDocument sd = new ServerDocument (@"\\LONDON\OfficeSolutions\Finance.xls");

sd.AppManifest.Dependency.AssemblyIdentity.Name.Remove (0);

Answer: A

 

NO.4 You create an add-in for Microsoft Office Word by using Visual Studio Tools for the Microsoft

Office System (VSTO). You deploy the add-in to a folder on a network share. The folder hosts 20

assemblies. All the assemblies are signed and contain the same digital signature. The add-in runs

from a local computer. When the add-in is accessed from a network share by using th e same

computer, a security exception is raised. You need to ensure that the add-in can run from the

network share. You must achieve this goal without elevating permissions for the other assemblies.

What should you do?

A. Create a code group that is based on the file hash.

B. Create a code group that is based on the publisher.

C. Create a code group that is based on the network share URL.

D. Create a code group that is based on the public token that is used to sign the assembly.

Answer: A

 

NO.5 You develop an add-in for Microsoft Office Excel by using Visual Studio Tools for the

Microsoft Office System (VSTO). The add-in contains a class that uses the following method.

public void ProcessCells() {

Excel.Worksheet ws = Application.ActiveSheet as

Excel.Worksheet;

List<object> values = new List<object>();

//Your code goes here

}

The add-in must retrieve the values for the cells in the range A1 through E3.

You need to exclude empty cell values when you retrieve cell values from the range.

Which code segment should you use?

A. Excel.Range rng = ws.get_Range("A1", "E3"); foreach (Excel.Range r in rng.Cells) { if (r != null)

values.Add(r.Value2); }

B. Excel.Range rng = ws.get_Range("A1", "E3"); foreach (Excel.Range r in rng.Cells) { if (r.Value2 !=

null) values.Add(r.Value2); }

C. Excel.Range rng = ws.get_Range("A1", "E3"); for (int x = 0; x < 3; x++) { for (int y = 0; y < 5; y++) {

Excel.Range r = rng.Cells[x, y] as Excel.Range; if (r.Value2 != null) values.Add(r.Value2); } }

D. Excel.Range rng = ws.get_Range("A1", "E3"); for (int x = 1; x < 4; x++) { for (int y = 1; y < 6; y++) {

Excel.Range r = rng.Cells[x, y] as Excel.Range; if (r != null) values.Add(r.Value2); } }

Answer: B

 

NO.6 You create a document-level solution for a Microsoft Office Word document by using a Visual

Studio Tools for the Microsoft Office System (VSTO) project. The solution project is named

HRSolution. The solution document is named HRSolution.doc. You deploy a copy of the solution

document to the C:\OfficeSolutions folder on client computers. You deploy the assembly to a shared

folder named OfficeSolutions. The shared folder is located on a server named LONDON. You need to

ensure that the solution document loads the assembly from the correct location. Which code

segment should you use?

A. Dim sd As ServerDocument sd = New ServerDocument ("C:\OfficeSolutions\HRSolution.doc") Dim

path As String = "\\LONDON\OfficeSolutions" sd.AppManifest.Dependency.AssemblyPath = path

sd.Save ()

B. Dim sd As ServerDocument sd = New ServerDocument ("C:\OfficeSolutions\HRSolution.doc") Dim

name As String = " LONDON.OfficeSolutions.HRSolution " sd.AppManifest.Identity.Name = name

sd.Save ()

C. Dim sd As ServerDocument sd = New ServerDocument ("C:\OfficeSolutions\HRSolution.doc ") Dim

path As String = "\\LONDON\OfficeSolutions" sd.AppManifest.DeployManifestPath = path sd.Save ()

D. Dim sd As ServerDocument sd = New ServerDocument ("C:\OfficeSolutions\HRSolution.doc") Dim

name As String = " LONDON.OfficeSolutions.HRSolution " sd.AppManifest.EntryPoints.Add (name)

sd.Save ()

Answer: A

 

NO.7 You create a document-level solution for Microsoft Office Excel 2003 by using Visual Studio

Tools for the Microsoft Office System (VSTO). The solution is frequently updated. You need to deploy

the solution. You also need to ensure that users have access to previous versions of the solution.

What should you do?

A. Publish the solution to a shared folder. As changes are made, republish the solution to the shared

folder.

B. Copy the solution to a shared folder on the local network. As changes are made, copy the updated

files to the shared folder.

C. Copy the solution to a local folder on each client computer. As changes are made, copy the

updated files to the local folder.

D. Create a setup project and build a Microsoft Windows Installer file. Run the Windows Installer file

to install the solution to a shared folder. As changes are made, rebuild the Windows Installer file and

reinstall the solution.

Answer: A

 

NO.8 You create a Microsoft Office Word 2007 document.

The OpenXML package for the document is shown in the exhibit. (Click the Exhibit button.)

You create an XML file named item2.xml. The item2.xml file uses the same schema as the item1.xml

file. You add the item2.xml file to the OpenXML package.

You need to ensure that the document uses data from the item2.xml file instead of the item1.xml

file.

What should you do?

A. Delete the item1.xml file.

B. Delete the itemProps1.xml file.

C. Create a file named itemProps2.xml that marks the item2.xml file as a data store.

D. Create a file named item2.xml.rels that creates a relationship between the item2.xml file and the

itemProps1.xml file.

Answer: D