Microsoft TS: Visual Studio Tools for 2007 MS Office System (VTSO) Sample Questions:

1. You are creating an add-in for Microsoft Office Word by using Visual Studio Tools for the Microsoft Office System (VSTO). The add-in will display data from a Web service named Service1. Service1 runs on a server named LONDON. The Web service contains a method named GetCustomers that returns a DataSet object. You need to bind the data returned by the GetCustomers method to a DataSet object named ds. Which code segment should you use?

A) LONDON.Service1 lh = new LONDON.Service1(); DataSet ds = new DataSet(); ds.GetXml();
B) LONDON.Service1 lh = new LONDON.Service1(); DataSet ds = new DataSet(); ds.DataSetName = lh.GetCustomers (). GetXml ();
C) DataSet ds = new DataSet(); ArrayList mappings = new ArrayList(); LONDON.Service1.GenerateXmlMappings( ds.GetType(), mappings);
D) LONDON.Service1 lh = new LONDON.Service1(); DataSet ds = lh.GetCustomers ();

2. You create an add-in for Microsoft Office PowerPoint by using Visual Studio Tools for the Microsoft Office System (VSTO). You publish the add-in by using Microsoft Visual Studio. Users report that the add-in is unavailable in PowerPoint. Users do not receive any error message. You need to ensure that the add-in is available in PowerPoint. What should you do?

A) Edit the application manifest to point to the add-in assembly.
B) Modify the registry to include the appropriate entries.
C) Copy the add-in assembly to the Microsoft Office folder.
D) Add the add-in assembly to the global assembly cache.

3. You are creating an add-in by using Visual Studio Tools for the Microsoft Office System (VSTO).
You write the following method. (Line numbers are included for reference only.)
01 Private Sub ExportDocumentCache ( ByVal path As String)
02 ...
03 End Sub
You need to ensure that the add-in saves each item in the document cache of a document to an independent XML file that is named for the item.
Which code segment should you insert at line 02?

A) Dim sd As ServerDocument = New ServerDocument (path) For i As Integer = 1 To sd.CachedData.HostItems.Count Dim sw As StreamWriter = _ File.CreateText (path & sd.CachedData.HostItems ( i ).Id & _ ".xml") sw.WriteLine ( sd.CachedData.HostItems ( i ). _ CachedData ( i ). DataType.ToString ()) sw.Close () Next
B) Dim sd As ServerDocument = New ServerDocument (path) Dim D As CachedDataHostItem = _ sd.CachedData.HostItems (" DocumentCache ") For Each CDI As CachedDataItem In D.CachedData Dim sw As StreamWriter = _ File.CreateText (path & CDI.Id & ".xml") sw.WriteLine ( CDI.DataType.ToString ()) sw.Close () Next
C) Dim sd As ServerDocument = New ServerDocument (path) Dim D As CachedDataHostItem = _ sd.CachedData.HostItems (" DocumentCache ") For Each CDI As CachedDataItem In D.CachedData Dim sw As StreamWriter = _ File.CreateText (path & CDI.Id & ".xml") sw.WriteLine ( CDI.Xml ) sw.Close () Next
D) Dim sd As ServerDocument = New ServerDocument (path) For i As Integer = 1 To sd.CachedData.HostItems.Count Dim sw As StreamWriter = _ File.CreateText (path & sd.CachedData.HostItems ( i ).Id & _ ".xml") sw.WriteLine ( sd.CachedData.HostItems ( i ). CachedData ( i ).Xml) sw.Close () Next

4. You are creating an add-in project for Microsoft Office by using Visual Studio Tools for the Microsoft Office System (VSTO). You create a data source named ContactRef from a class in an assembly. The author digitally signs a new version of the assembly. You need to ensure that the add-in can load a new version of the assembly. What should you do?

A) Add the public key token to the TypeInfo element in the ContactRef.datasource file.
B) Add a PublicKeyToken element to the ContactRef.datasource file.
C) Add the public key token to the GenericObjectDataSource element in the ContactRef.datasource file.
D) Add a PublicKeyToken attribute to the ContactRef.datasource file.

5. You create an add-in for Microsoft Office Outlook by using Visual Studio Tools for the Microsoft Office System (VSTO). The add-in must set up a WindowSelectionChange event for the Outlook e-mail messages by using Microsoft Office Word as the editor.
You write the following lines of code. (Line numbers are included for reference only.)
01 Imports Word = Microsoft.Office.Interop.Word
02 Private Sub WindowSelectionChange ( ByVal Sel As _ Word.Selection )
03 Dim ins As Outlook.Inspector = Application.ActiveInspector
04 If ins.EditorType = Outlook.OlEditorType.olEditorWord Then
05 ...
06 AddHandler app.WindowSelectionChange , AddressOf _
Me.WindowSelectionChange 07 End If 08 End Sub
You need to bind the event to the Word application object.
Which code segment should you insert at line 05

A) Dim app As Word.Application = _ CType ( ins.CurrentItem , Word.Document ).Application
B) Dim app As Word.Application = _ CType ( ins.WordEditor , Word.Document ).Application
C) Dim app As Word.Application = _ CType ( ins.CurrentItem , Word.Application )
D) Dim app As Word.Application = _ CType ( ins.WordEditor , Word.Application )

Solutions: