Exam Microsoft 74-137 Demo

1.You develop XML solutions using Microsoft Office Professional Enterprise Edition 2003. Your company?? s sales data is contained in an XML file named Sales.xml. Users in the marketing, manufacturing, and accounting departments need to open the file and view only the data that pertains to them. Each department uses a separate Microsoft Office Word 2003 template to view the data.

You need to ensure that each template displays the appropriate data.

What should you do? Adobe 9A0-062 9A0-311 9A0-061 A: Configure the XML options on Sales.xml to ignore mixed content. B: Configure the XML options on each department??s template to ignore mixed content C: Create an XSD file for each department, and attach the file to the department's Word template. D: Create an XSLT file for each department, and apply the file to Sales.xml. Correct Answers: D

2.You develop XML solutions using Microsoft Office Professional Enterprise Edition 2003 for your company. You develop a smart document solution that uses an XML expansion pack.

A publicly accessible Web server is used as the distribution point to external users. You create a 

Microsoft Visual Studio .NET 2003 installer package. When users download and run the installer package it will install the solution to a local folder on the remote user??s computer.

You need to modify the solution files to support distribution to remote users.

What should you do?

Apple 9L0-612 9L0-929 9L0-611 9L0-610 A: In the existing manifest file, add a <file> element that contains a <type> element with a value of

filePath that points to the installation file.

B: In the existing manifest file, add a <file> element that contains a <type> element with a value of installPackage that points to the installation file. C: Create a second manifest file that includes a <file> element that contains a <type> element with a value of filePath that points to the installation file. D: Create a second manifest file that includes a <file> element that contains a <type> element with a value of installPackage that points to the installation file. Correct Answers: B

3.You develop XML solutions using Microsoft Office Professional Enterprise Edition 2003. You are creating a Microsoft Office Word 2003 template for expense reports. You attach an XML schema to the template, and you associate the schema with two transforms. The transforms are named Transform1 and Transform2.

You need to ensure that Transform1 is applied when users save documents that are based on the template as Word XML documents.

BEA 0B0-106 0B0-101 0B0-102 0B0-103

What should you do? (Each correct answer presents part of the solution. Choose two.)

A:Set the ArbitraryXMLSupportAvailable property of the Document object to True. B:Set the XMLSaveDataOnly property of the Document object to True. C:Set the IgnoreMixedContent property of the Document object to False. D:Set the XMLSaveThroughXSLT property of the Document object to Transform1. E:Set the XMLUseXSLTWhenSaving property of the Document object to True. Correct Answers: D, E

4.You develop XML solutions using Microsoft Office Professional Enterprise Edition 2003. The XML

Schema Definition (XSD) named Employees.xsd is shown below:

<?xml version="1.0"?>

<schema xmlns="http://www.w3.org/2001/XMLSchema">

 <element name="Employee">

   <complexType>

       <element name="Row" maxOccurs="unbounded">

         <complexType>

             <element name="EmployeeID" type="integer" />

         </complexType>

       </element>

   </complexType>

 </element>

</schema>

You are using the Microsoft Office Excel 2003 object model to create an XML map and import

an XML file. Your method includes the following code:

CIW 1D0-532 1D0-476 1D0-475 Dim xmp As XmlMap

Set xmp = _

   ActiveWorkbook.XmlMaps.Add("c:\SalesData\Employees.xsd")

'Insert code here

You need to map the column that contains the EmployeeID data to column B in the worksheet. The

column header should appear in cell B1.

9A0-036Adobe 9A0-036 9A0-031 9A0-046 9A0-045 9A0-044 9A0-061 What code should you add to the method?

A: Dim xp as XPath

Set xp = ActiveSheet.Range("B1").XPath

xp.Value= "@EmployeeID" B: Dim xp as XPath

Set xp = ActiveSheet.Range("B1").XPath

xp.SetValue xmp, "@EmployeeID", , True C: Dim xp as XPath

Set xp = ActiveSheet.Range("B1").XPath

xp.Value= "/Employee/Row/EmployeeID" D: Dim xp as XPath

Set xp = ActiveSheet.Range("B1").XPath

xp.SetValue xmp, "/Employee/Row/EmployeeID", , True Correct Answers: D