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. this.Validate (); this.factResellerSalesBindingSource.EndEdit (); this.factResellerSalesTableAdapter.Update ( adventureWorksDWDataSet.FactResellerSales );
• B. this.Validate (); this.factResellerSalesBindingSource.EndEdit (); this.factResellerSalesBindingSource.Insert ( 0, adventureWorksDWDataSet.FactResellerSales );
• C. XLNRange.Merge ( this.Range ["A1", "B3"]);
• D. XLNRange.AutoFill ( this.Range ["A1", "B3"], Excel.XlAutoFillType.xlFillDefault );

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. Change the scope of the CommandBarButton button variable to a class-scoped variable.
• B. Change the scope of the ._CommandBarButtonEvents_ClickEventHandler delegate btnClick variable to a class-scoped variable.
• C. Set the Enabled property of the CommandBarButton button object to True.
• D. Set the OnAction property of the CommandBarButton button object to Click.

The solution document refers to the following bugs:
bug123
Bug514
BUG512
The solution document must provide more details about a bug whenever a reference to the bug is found in the document.
You need to create a smart tag that identifies each bug.
Which code segment should you use?

• A. Dim tag As SmartTag = New SmartTag _ ("http: / / MySmartTag/ST#BugRecognizer", "Bug Recognizer") tag.Terms.Add("bug\d\d\d")
• B. Dim tag As SmartTag = New SmartTag _ ("http: / / MySmartTag/ST#BugRecognizer", "Bug Recognizer") Dim regex As Regex = New Regex("[B|b][U|u][G|g]000") tag.Expressions.Add(regex)
• C. Dim tag As SmartTag = New SmartTag _ ("http: / / MySmartTag/ST#BugRecognizer", "Bug Recognizer") Dim regex As Regex = _ New Regex("bug\d\d\d", RegexOptions.IgnoreCase) tag.Expressions.Add(regex)
• D. Dim tag As SmartTag = New SmartTag _ ("http: / / MySmartTag/ST#BugRecognizer", "Bug Recognizer") tag.Terms.Add("[B|b][U|u][G|g]000")

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