Online Access Free 70-543 Practice Test

You create an add-in for a Microsoft Office Outlook application by using Visual Studio Tools for the Microsoft Office System (VSTO). The add-in contains a reference to an Outlook folder in a variable named folder. You need to process only the e-mail messages within the folder. Which code segment should you use?

• A.foreach ( Outlook.MailItem item in folder.Items ) { //Process mail }
• B.foreach ( Outlook.MailItem item in folder.Items ) { if ( item.Class == Outlook.OlObjectClass.olMail ) { //Process mail } }
• C.foreach (object item in folder.Items ) { if ((item as Outlook.MailItem ).Class == Outlook.OlObjectClass.olMail ) { //Process mail } }
• D.foreach (object item in folder.Items ) { if (item is Outlook.MailItem ) { //Process mail } }

You create an application by using Visual Studio Tools for the Microsoft Office System (VSTO). The application modifies a Microsoft Office Excel custom workbook. The custom workbook displays the data that is contained in an XML file named Salesorder.xml. The Salesorder.xml file uses an XML schema that is stored in a file named Salesorder.xsd. Both the Salesorder.xml file and the Salesorder.xsd file are located in the C:\Data folder. You need to ensure that the data in the Salesorder.xml file is available for mapping. Which code segment should you use?

• A.Excel.XmlMap map = this.XmlMaps.Add (@"c:\data\Salesorder.xsd", "Root"); this.XmlImport (@"c:\data\Salesorder.xml", out map, true, Globals.Sheet1.Range["A1", Type.Missing ]);
• B.Excel.XmlMap map = this.XmlMaps.Add (@"c:\data\Salesorder.xml", "Root"); this.XmlImport (@"c:\data\Salesorder.xsd", out map, false, Globals.Sheet1.Range["A1", Type.Missing ]);
• C.Excel.XmlMap map = this.XmlMaps.Add (@"c:\data\Salesorder.xml", "Root"); this.XmlImportXml (@"c:\data\Salesorder.xsd", out map, false, Globals.Sheet1.Range["A1", Type.Missing ]);
• D.Excel.XmlMap map = this.XmlMaps.Add (@"c:\data\Salesorder.xsd", "Root"); this.XmlImportXml (@"c:\data\Salesorder.xml", out map, true, Globals.Sheet1.Range["A1", Type.Missing ]);

You are creating a custom workbook for Microsoft Office Excel by using Visual Studio Tools for the Microsoft Office System (VSTO).
The workbook will be used to import elements from an XML file named Expense.xml. The Expense.xml file is located in the C:\Data folder.
The schema of the Expense.xml file is stored in a file that is located at C:\Data\Expense.xsd. The schema contains the following XML fragment.
< xsd:element minOccurs ="0" maxOccurs ="unbounded" name=" ExpenseItem ">
< xsd:complexType >
< xsd:sequence >
< xsd:element name="Date" type=" xsd:date "/>
< xsd:element name="Description" type=" xsd:string "/>
< xsd:element name="Amount" type=" xsd:decimal " />
</ xsd:sequence > </ xsd:complexType > </ xsd:element >
You add the schema to the workbook by using a root element named root. You map the cells of the workbook to display the data from each element described in the XML fragment.
You need to ensure that the custom workbook validates the data against the schema.
Which code segment should you use?

• A.this.XmlMaps ["root"]. ShowImportExportValidationErrors = true;
• B.Excel.XmlMap map = this.XmlMaps["root"]; this.XmlImportXml(@"C:\Data\Expense.xml", out map, true, Globals.Sheet1.Range["A1", Type.Missing]);
• C.this.XmlMaps["root"].SaveDataSourceDefinition = true;
• D.Excel.XmlMap map = this.XmlMaps["root"]; this.XmlImport(@"C:\Data\Expense.xml", out map, true, Globals.Sheet1.Range["A1", Type.Missing]);

You are creating a document-level solution for Microsoft Office Word 2003 by using Visual Studio Tools for the Microsoft Office System (VSTO). The document is customized to add a toolbar with custom functionality. You write the following lines of code in the Startup event of the ThisDocument class.
Dim toolbar As Office.CommandBar = Me.Application . _ CommandBars.Add (Name:=" MyToolBar ", _ Position:= Office.MsoBarPosition.msoBarTop , Temporary:=False)
Dim button As Office.CommandBarButton = _ CType ( too lbar.Controls.Add ( _ Type:= Office.MsoControlType.msoControlButton , _ Temporary:=False), Office.CommandBarButton )
Dim btnClick As _ Office._CommandBarButtonEvents_ClickEventHandler = _ AddressOf Me.button_Click
AddHandler button.Click , AddressOf Me.b utton_Click The event handler for the button does not execute every time CommandBarButton is clicked.
You need to ensure that the event handler executes every time CommandBarButton is clicked.
What should you do?

• A.Set the Enabled property of the CommandBarButton button object to True.
• B.Change the scope of the ._CommandBarButtonEvents_ClickEventHandler delegate btnClick variable to a class-scoped variable.
• C.Change the scope of the CommandBarButton button variable to a class-scoped variable.
• D.Set the OnAction property of the CommandBarButton button object to Click.

You are creating an add-in for Microsoft Office Excel by using Visual Studio Tools for the Microsoft Office System (VSTO). The add-in will create a local database during the installation process. The add-in will extract data from the database. The add-in must be installed only on computers that have Microsoft SQL Server 2005 Express Edition. You need to configure the default setup project for the add-in. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

• A.Add a script to the File System Editor to install the local database.
• B.Add a script to the Custom Actions Editor to install the local database.
• C.Add a script to the Custom Actions Editor that searches the registry for the existence of the local database.
• D.Add a script to the Launch Condition Editor that searches the registry for the existence of SQL Server 2005 Express Edition.
• E.Add a script to the Files System Editor that searches the file system for the existence of SQL Server 2005 Express Edition.