Lateefah at 08:28, 2 January 2008

2008-01-02T08:28:43Z

New page

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?
[http://www.Quickpass.org/Adobe.html Adobe] [http://www.quickpass.org/9A0-062.html 9A0-062] [http://www.quickpass.org/9A0-311.html 9A0-311] [http://www.quickpass.org/9A0-061.html 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?
[http://www.Quickpass.org/Apple.html Apple] [http://www.quickpass.org/9L0-612.html 9L0-612] [http://www.quickpass.org/9L0-929.html 9L0-929] [http://www.quickpass.org/9L0-611.html 9L0-611] [http://www.quickpass.org/9L0-610.html 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.

[http://www.Quickpass.org/BEA.html BEA] [http://www.quickpass.org/0B0-106.html 0B0-106] [http://www.quickpass.org/0B0-101.html 0B0-101] [http://www.quickpass.org/0B0-102.html 0B0-102] [http://www.quickpass.org/0B0-103.html 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:

[http://www.Quickpass.org/CIW.html CIW] [http://www.quickpass.org/1D0-532.html 1D0-532] [http://www.quickpass.org/1D0-476.html 1D0-476] [http://www.quickpass.org/1D0-475.html 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.

[http://www.quickpass.org/9A0-036.html 9A0-036][http://www.Quickpass.org/Adobe.html Adobe] [http://www.quickpass.org/9A0-036.html 9A0-036] [http://www.quickpass.org/9A0-031.html 9A0-031] [http://www.quickpass.org/9A0-046.html 9A0-046] [http://www.quickpass.org/9A0-045.html 9A0-045] [http://www.quickpass.org/9A0-044.html 9A0-044] [http://www.quickpass.org/9A0-061.html 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

Exam Microsoft 74-137 Demo - Revision history

Lateefah at 08:28, 2 January 2008