You create an add-in for Microsoft Office Excel 2007 by using Visual Studio Tools for the Microsoft Office System (VSTO). The add-in must be installed on 100 computers that run Windows Vista and Microsoft Office 2007 Professional Edition. You need to configure the computers to run the add-in. What should you install on the computers?

• A. Microsoft .NET Framework 2.0
• B. Microsoft .NET Framework 1.1
• C. Microsoft VSTO Runtime
• D. Microsoft Office Primary Interop Assemblies

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 Launch Condition Editor that searches the registry for the existence of SQL Server 2005 Express Edition.
• C. Add a script to the Custom Actions Editor to install the local database.
• D. Add a script to the Files System Editor that searches the file system for the existence of SQL Server 2005 Express Edition.
• E. Add a script to the Custom Actions Editor that searches the registry for the existence of the local database.

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;Initial Catalog= AdventureWorks ;" + "Integrated Security=True")]
• B. [ global::System.Configuration.DefaultSettingValueAttribute ( "Data S ource=EXCELSQL;" + " InitialCatalog = AdventureWorks.Production.Product ;" + "Integrated Security=True")]
• C. [ global::System.Configuration.DefaultSettingValueAttribute ( "Data Source= EXCELSQL.AdventureWorks ;" + "Initial Catalog=Production;" + "Integrated Security=True")]
• D. [ global::System.Configuration.DefaultSettingValueAttribute ( "Data Source= EXCELSQL.AdventureWorks ;" + "Initial Catalog=Product;" + "Integrated Security=True")]

You create a document-level solution by using Visual Studio Tools for the Microsoft Office System (VSTO). The solution uses an assembly named MyAssembly. MyAssembly is located in the C:\Assemblies\ folder. A Microsoft Office Word 2003 document named MyWordDocument is located in the C:\Documents\ folder. You need to associate MyAssembly with MyWordDocument if managed extensions are enabled in MyWordDocument. Which code segment should you use?

• A. Dim document As String = "C:\Documents\MyWordDocument.doc" Dim assembly As String = "C:\Assemblies\MyAssembly.dll" If ServerDocument.IsCacheEnabled (assembly) Then 'Add document customization End If
• B. Dim document As String = "C:\Documents\MyWordDocument.doc" Dim assembly As String = "C:\Assemblies\MyAssembly.dll" If ServerDocument.IsCacheEnabled (document) Then 'Add document customization End If
• C. Dim document As String = "C:\Documents\MyWordDocument.doc" Dim assembly As String = "C:\Assemblies\MyAssembly.dll" If ServerDocument.IsCustomized (assembly) Then 'Add document customization End If
• D. Dim document As String = "C:\Documents\MyWordDocument.doc" Dim assembly As String = "C:\Assemblies\MyAssembly.dll" If ServerDocument.IsCustomized (document) Then 'Add document customization End If