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

1. You are creating an application by using Visual Studio Tools for the Microsoft Office System (VSTO). The application contains the following objects:
a DataSet object named OrderData
a ServerDocument object named sd1
You write the following lines of code. (Line numbers are included for reference only.)
01 Dim stringIn As System.Text.StringBuilder = _
New System.Text.StringBuilder ()
02 Dim stringOut As System.IO.StringWriter = _
New System.IO.StringWriter ( stringIn )
03 ...
04 sd1.Save()
You need to store the contents of the OrderData object in the document cache for offline use.
Which code segment should you insert at line 03?

A) OrderData.WriteXml ( stringOut , XmlWriteMode.IgnoreSchema ) orderdataitem.Schema = stringIn.ToString ()
B) OrderData.WriteXml ( stringOut , XmlWriteMode.WriteSchema ) orderdataitem.Schema = stringIn.ToString ()
C) OrderData.WriteXml ( stringOut , XmlWriteMode.IgnoreSchema ) orderdataitem.Xml = stringIn.ToString ()
D) OrderData.WriteXml ( stringOut , XmlWriteMode.WriteSchema ) orderdataitem.Xml = stringIn.ToString ()

2. You are creating an add-in for Microsoft Office Excel by using Visual Studio Tools for the Microsoft Office System (VSTO). The add-in must connect to a remote database to retrieve data. The structure of the remote database is shown in the exhibit. (Click the Exhibit button.)
You write the following lines of code. (Line numbers are included for reference only.)
01 internal sealed partial class Settings : 02 global::System.Configuration.ApplicationSettingsBase { 03 [ global::System.Configuration.SpecialSettingAttribute ( 04 global::System.Configuration.SpecialSetting.ConnectionString )]
05 ...
06 public string ExcelSQLConnectionString {
07 get {
08 return (string)(this[" ExcelSQLConnectionString "]);
09 }
10 }
You need to connect to the remote database by using the security context of the current user.
Which code segment should you insert at line 05?

A) [ global::System.Configuration.DefaultSettingValueAttribute ( "Data Source= EXCELSQL.AdventureWorks ;" + "Initial Catalog=Product;" + "Integrated Security=True")]
B) [ global::System.Configuration.DefaultSettingValueAttribute ( "Data Source= EXCELSQL;Initial Catalog= AdventureWorks ;" + "Integrated Security=True")]
C) [ global::System.Configuration.DefaultSettingValueAttribute ( "Data Source= EXCELSQL.AdventureWorks ;" + "Initial Catalog=Production;" + "Integrated Security=True")]
D) [ global::System.Configuration.DefaultSettingValueAttribute ( "Data S ource=EXCELSQL;" + " InitialCatalog = AdventureWorks.Production.Product ;" + "Integrated Security=True")]

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.EntryPoints.Clear ();
B) ServerDocument sd = new ServerDocument (@"\\LONDON\OfficeSolutions\Finance.xls"); sd.AppManifest.DeployManifestPath.Remove (0);
C) ServerDocument sd = new ServerDocument (@"\\LONDON\OfficeSolutions\Finance.xls"); sd.AppManifest.Clear ();
D) ServerDocument sd = new ServerDocument (@"\\LONDON\OfficeSolutions\Finance.xls"); sd.AppManifest.Dependency.AssemblyIdentity.Name.Remove (0);

4. You create a document-level solution for Microsoft Office Excel 2003 by using Visual Studio Tools for the Microsoft Office System (VSTO). The solution creates a NamedRange control named XLNRange in an Excel worksheet. The range contains cells A1 through B3. You bind the XLNRange control to a data table named FactResellerSales by using the Data Source Configuration Wizard. You need to synchronize the FactResellerSales table with the changes that are made to the data in the XLNRange control. Which code segment should you use?

A) Me.Validate () Me.FactResellerSalesBindingSource.EndEdit () Me.FactResellerSalesTableAdapter.Update _ ( AdventureWorksDWDataSet.FactResellerSales )
B) XLNRange.AutoFill ( Me.Range ("A1", "B3"), _ Excel.XlAutoFillType.xlFillDefault )
C) Me.Validate () Me.FactResellerSalesBindingSource.EndEdit () Me.FactResellerSalesBindingSource.Insert _ ( 0, AdventureWorksDWDataSet.FactResellerSales )
D) XLNRange.Merge ( Me.Range ("A1", "B3"))

5. 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 network share URL.
B) Create a code group that is based on the publisher.
C) Create a code group that is based on the public token that is used to sign the assembly.
D) Create a code group that is based on the file hash.

Solutions: