Microsoft TS: Visual Studio Tools for 2007 MS Office System (VTSO) : 070-543

You create a document-level solution for Microsoft Office Excel 2003 by using Visual Studio Tools for the Microsoft Office System (VSTO). The solution is frequently updated. You need to deploy the solution. You also need to ensure that users have access to previous versions of the solution. What should you do?

• A. Copy the solution to a shared folder on the local network. As changes are made, copy the updated files to the shared folder.
• B. Copy the solution to a local folder on each client computer. As changes are made, copy the updated files to the local folder.
• C. Publish the solution to a shared folder. As changes are made, republish the solution to the shared folder.
• D. Create a setup project and build a Microsoft Windows Installer file. Run the Windows Installer file to install the solution to a shared folder. As changes are made, rebuild the Windows Installer file and reinstall the solution.

You create a custom template for Microsoft Office Word 2007 by using Visual Studio Tools for the Microsoft Office System (VSTO). You add a content control to the custom template. The content control is a placeholder for the first paragraph in the documents that use the custom template. You need to ensure that the users can edit the first paragraph but cannot delete it. Which code segment should you use?

• A. control.LockContentControl = false; control.LockContents = false;
• B. control.LockContentControl = true; control.LockContents = false;
• C. control.LockContentControl = true; control.LockContents = true;
• D. control.LockContentControl = false; control.LockContents = true;

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 Partial Friend NotInheritable Class Settings
02 Inherits System.Configuration.ApplicationSettingsBase
03 < System.Configuration.SpecialSettingAttribute ( _
04 System.Configuration.SpecialSetting.ConnectionString )>
05 ...
06 Public ReadOnly Property ExcelSQLConnectionString () _
As String 07 Get 08 Return Convert.ToString (Me(" ExcelSQLConnectionString ")) 09 End Get 10 End Property 11 End Class
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. < System.Configuration.DefaultSettingValueAttribute ( _ "Data Source= EXCELSQL.AdventureWorks ;" & _ "Initial Catalog= Production;Integrated Security=True")> _
• B. < System.Configuration.DefaultSettingValueAttribute ( _ "Data Source= EXCELSQL;Initial Catalog= AdventureWorks ;" & _ "Integrated Security=True")> _
• C. < System.Configuration.DefaultSettingValueAttribute ( _ "Data Source= EXCELSQL ;InitialCatalog = AdventureWorks ." & _ " Production.Product;Integrated Security=True")> _
• D. < System.Configuration.DefaultSettingValueAttribute ( _ "Data Source= EXCELSQL.AdventureWorks ;" & _ "Initial Catalog= Product;Integrated Security=True")> _

You are creating a custom template for Microsoft Office Word 2007 by using Visual Studio Tools for the Microsoft Office System (VSTO).
The template contains a custom XML part that consumes data from an XML source. The XML source contains the following XML fragment.
<Products> mother board, memory, hard drive,
floppy drive, DVD drive </Products>
You need to display the Products element as a comma-separated list within a paragraph of text.
Which code segment should you use?

• A. Application.ActiveDocument.ContentControls.Add ( WdContentControlType.wdContentControlText , ref range);
• B. Application.ActiveDocument.ContentControls.Add ( WdContentControlType.wdContentControlRichText , ref range);
• C. Application.ActiveDocument.ContentControls.Add ( WdContentControlType.wdContentControlDropdownList , ref range);
• D. Application.ActiveDocument.ContentControls.Add ( WdContentControlType.wdContentControlComboBox , ref range);

You create an add-in for Microsoft Office Word 2007 by using Visual Studio Tools for the Microsoft Office System (VSTO). The add-in customizes the Ribbon user interface (UI). The add-in contains a file named Ribbon1.xml that has the following markup for two buttons.
<button id="Btn1" onAction =" DoOperation " />
<button id="Btn2" onAction =" DoOperation " />
You need to create a callback function that runs different code for the buttons.
Which code segment should you use?

• A. public void DoOperation (Control control ) { if ( control.Text == "Btn1") { //Btn1 click } else { //Btn2 click } }
• B. public void DoOperation ( Office.IRibbonControl control) { if ( control.Id == "Btn1") { //Btn1 click } else { //Btn2 click } }
• C. public void DoOperation (Control control ) { if ( control.ProductName.Equals ("Btn1")) { //Btn1 click } else { //Btn2 click } }
• D. public void DoOperation ( Office.IRibbonControl control) { if ( control.Tag == "Btn1") { //Btn1 click } else { //Btn2 click } }