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

You are creating an add-in project for Microsoft Office by using Visual Studio Tools for the Microsoft Office System (VSTO). You create a data source named ContactRef from a class in an assembly. The author digitally signs a new version of the assembly. You need to ensure that the add-in can load a new version of the assembly. What should you do?

• A.Add a PublicKeyToken attribute to the ContactRef.datasource file.
• B.Add the public key token to the TypeInfo element in the ContactRef.datasource file.
• C.Add the public key token to the GenericObjectDataSource element in the ContactRef.datasource file.
• D.Add a PublicKeyToken element to the ContactRef.datasource file.

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 will insert an XML data island in a Word document. The data island contains the following XML fragment.
< customer id="01AF" >
< region district="Northwest" > < /region >
< /customer >
You bind the data island to an XMLNode instance named xln.
You need to update the region element with the following data.
< customer id="01AF" >
< region district="Southwest" > California < /region >
< /customer >
Which code segment should you use?

• A.if ( xln.ParentNode.NodeValue == "customer" & & xln.NodeValue [0]. CompareTo ("Northwest") == 0) { xln.NodeText = "California"; xln.ChildNodes [1].Text = "Southwest"; }
• B.if ( xln.ChildNodes [0].Text == "customer" & & xln.NodeText == "Northwest") { xln.NodeText = "Southwest"; xln.ChildNodes [1].Text = "California"; }
• C.if ( xln.ChildNodes [0].Text == "customer" & & xln.NodeValue [0]. CompareTo ("Northwest") == 0) { xln.NodeText = "California"; xln.ChildNodes [1].Text = "Southwest"; }
• D.if ( xln.ParentNode.NodeValue == "customer" & & xln.NodeText == "Northwest") { xln.NodeText = "Southwest"; xln.ChildNodes [1].Text = "California"; }

You are creating an add-in for Microsoft Office Excel by using Visual Studio Tools for the Microsoft Office System (VSTO). The add-in contains a server document named doc. The add-in also contains a variable named filepath that will store the location of an XML file. You need to load the XML file into the document cache. Which code segment should you use?

• A.StreamReader sr = new StreamReader(filepath); doc.CachedData.HostItems.Add(sr.ReadToEnd());
• B.doc.CachedData.FromXml(filepath);
• C.StreamReader sr = new StreamReader(filepath); doc.CachedData.FromXml(sr.ReadToEnd());
• D.doc.CachedData.HostItems.Add(filepath);

You create a document-level solution for Microsoft Office Excel 2003 by using Visual Studio Tools for the Microsoft Office System (VSTO). The Excel workbook contains a worksheet object named Sheet1 that contains data in the range A1 through A5.
You write the following lines of code for the Sheet1 object. (Line numbers are included for reference only.)
01 Word.Application app = new Word.Application ();
02 Word.Document doc;
03 ...
04 object index = 1;
05 Word.Bookmark bMark = doc.Bookmarks.get_Item (
ref index);
06 ...
You need to insert the data from the range A1 through A5 into a Microsoft Office Word document after bMark. Your solution must retain the sequence of the data that is inserted.
Which code segment should you insert at line 06?

• A.Excel.Range rng = this. get_ Range ( "A1", "A5" ) ; string temp = ""; foreach ( Excel.Range r in rng.Cells ) { temp = temp + r.Value2.ToString(); } bMark.Range.InsertAfter (temp);
• B.Excel.Range rng = this. get_ Range ( "A1", "A5" ) ; foreach ( Excel.Range r in rng.Cells ) { bMark.Range.InsertAfter (r.Value2.ToString()); }
• C.Excel.Range rng = this. get_ Range ( "A1", "A5" ) ; string temp = ""; foreach ( Excel.Range r in rng.Rows ) { temp = temp + r.Text.ToString (); } bMark.Range.Text = temp;
• D.Excel.Range rng = this. get_ Range ( "A2", "A5" ) ; bMark.Range.Text = this. get_ Range ( "A1", System.Type.Missing ) .Value2.ToString(); foreach ( Excel.Range r in rng.Rows ) { bMark.Range.InsertAfter (r.Value2.ToString()); }

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.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.
• B.Publish the solution to a shared folder. As changes are made, republish the solution to the shared folder.
• C.Copy the solution to a local folder on each client computer. As changes are made, copy the updated files to the local folder.
• D.Copy the solution to a shared folder on the local network. As changes are made, copy the updated files to the shared folder.