070-543 試験問題を無料オンラインアクセス

You create an add-in for Microsoft Office Outlook 2007 by using Visual Studio Tools for the Microsoft Office System (VSTO). You deploy the add-in to a network share named OfficeSolutions. The OfficeSolutions network share is located on a server named LONDON. You need to grant permission for the add-in to run. Which command should you use?

• A.caspol Cm Cgac FullTrust
• B.caspol Cm Cag LocalIntranet_zone Curl "\\LONDON\OfficeSolutions" FullTrust
• C.caspol Cm Cgac Execute
• D.caspol Cm Cag LocalIntranet_zone Curl "\\LONDON\OfficeSolutions" Execute

You are creating a document-level solution for Microsoft Office Word 2003 by using Visual Studio Tools for the Microsoft Office System (VSTO).
The solution contains a DataRow named custrow. A serialization of custrow contains the following XML fragment.
< ClientProjects >
...
< description > Upgrade from Windows XP < /description >
... < / ClientProjects >
The solution will create an XMLNode control named ProjectDescriptionNode in a Word document.
You need to ensure that the text in the description element is displayed as unformatted text.
Which code fragment should you use?

• A.ProjectDescriptionNode.Text = _ custrow("description").ToString()
• B.ProjectDescriptionNode.PlaceholderText = _ custrow("description").ToString()
• C.ProjectDescriptionNode.NodeValue = _ custrow("description").ToString()
• D.ProjectDescriptionNode.NodeText = _ custrow("description").ToString()

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.

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

You create a document-level solution for Microsoft Office Word 2003 by using Visual Studio Tools for the Microsoft Office System (VSTO).
You write the following method in the document class.
void wordAppEvent_NewDocument ( Word.Document Doc) { //Add custom footer
}
You need to set up an event handler that is fired when a Word document is created.
Which code segment should you use?

• A.Word.ApplicationEvents3_Event wordAppEvent ; wordAppEvent = this.Application.ActiveDocument as Word.ApplicationEvents3_Event; wordAppEvent.NewDocument += new Word.ApplicationEvents3_NewDocumentEventHandler( wordAppEvent_NewDocument );
• B.Word.ApplicationEvents3_Event wordAppEvent ; wordAppEvent = this.Application as Word.ApplicationEvents3_Event; wordAppEvent.NewDocument += new Word.ApplicationEvents3_NewDocumentEventHandler( wordAppEvent_NewDocument );
• C.Word.ApplicationEvents3_Event wordAppEvent ; wordAppEvent = this.InnerObject as Word.ApplicationEvents3_Event; wordAppEvent.NewDocument += new Word.ApplicationEvents3_N ewDocumentEventHandler( wordAppEvent_NewDocument );
• D.Word.ApplicationEvents3_Event wordAppEvent ; wordAppEvent = this.ActiveWindow as
  Word.ApplicationEvents3_Event; wordAppEvent.NewDocument += new Word.ApplicationEvents3_NewDocumentEventHandler( wordAppEvent_NewDocument );