Online Access Free 070-543 Exam Questions

You are creating an add-in for Microsoft Office Word by using Visual Studio Tools for the Microsoft Office System (VSTO). The add-in will display data from a Web service named Service1. Service1 runs on a server named LONDON. The Web service contains a method named GetCustomers that returns a DataSet object. You need to bind the data returned by the GetCustomers method to a DataSet object named ds. Which code segment should you use?

• A.Dim lh As LONDON.Service1 = New LONDON.Service1() Dim ds As DataSet = New DataSet() ds.DataSetName = lh.GetCustomers.GetXml()
• B.Dim ds As DataSet = New DataSet() Dim mappings As ArrayList = New ArrayList() LONDON.Service1.GenerateXmlMappings( _ ds.GetType(), mappings)
• C.Dim lh As LONDON.Service1 = New LONDON.Service1() Dim ds As DataSet = lh.GetCustomers()
• D.Dim lh As LONDON.Service1 = New LONDON.Service1() Dim ds As DataSet = New DataSet() ds.GetXml()

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

You develop an add-in for Microsoft Office Excel by using Visual Studio Tools for the Microsoft Office System (VSTO). The add-in contains a class that uses the following method.
Public Sub ProcessCells ()
Dim ws As Excel.Worksheet = CType _
( Application.ActiveSheet , Excel.Worksheet ) Dim values As List(Of Object) = New List(Of Object)()
'Your code goes here
End Sub
The add-in must retrieve the values for the cells in the range A1 through E3.
You need to exclude empty cell values when you retrieve cell values from the range.
Which code segment should you use?

• A.Dim rng As Excel.Range = ws.Range ("A1", "E3") For x As Integer = 1 To 3 For y As Integer = 1 To 5 Dim r As Excel.Range = rng.Cells (x, y) If Not r Is Nothing Then values.Add (r.Value2) End If Next Next '...
• B.Dim rng As Excel.Range = ws.Range ("A1", "E3") For x As Integer = 0 To 2 For y As Integer = 0 To 5 Dim r As Excel.Range = rng.Cells (x, y) If Not r.Value2 Is Nothing Then values.Add (r.Value2) End If Next Next '...
• C.Dim rng As Excel.Range = ws.Range ("A1", "E3") For Each r As Excel.Range In rng.Cells If Not r Is Nothing Then values.Add (r.Value2) End If Next '...
• D.Dim rng As Excel.Range = ws.Range ("A1", "E3") For Each r As Excel.Range In rng.Cells If Not r.Value2 Is Nothing Then values.Add (r.Value2) End If Next '...

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.Publish the solution to a shared folder. As changes are made, republish the solution to the shared folder.
• B.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.
• 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.

You are creating a customized Microsoft Office Excel workbook by using the Visual Studio Tools for the Microsoft Office System (VSTO). The data in the Excel workbook will be used to update a Microsoft Office Word report named MyDoc.doc. The MyDoc.doc report is located in the C:\ folder. You need to retrieve a Document object that sends updates from the Excel workbook to the Mydoc.doc report. Which code segment should you use?

• A.Dim app As Word.Application = New Word.Application() Dim filename As Object = "C:\MyDoc.doc" Dim temp As Object = Nothing app.Documents.Open(FileName:=filename, ConfirmConversions:=temp) Dim doc As Word.Document = CType(temp, Word.Document)
• B.Dim app As Word.Application = New Word.Application() Dim filename As Object = "C:\MyDoc.doc" Dim action As Object = "Open" Dim doc As Word.Document = _ app.Documents.Add(Template:=filename, NewTemplate:=action)
• C.Dim app As Word.Application = New Word.Application() Dim filename As Object = "C:\MyDoc.doc" Dim temp As Object = app.Documents.Open(FileName:=filename) Dim doc As Word.Document = app.Documents.Add(temp)
• D.Dim app As Word.Application = New Word.Application() Dim filename As Object = "C:\MyDoc.doc" Dim doc As Word.Document = _ app.Documents.Open(FileName:=filename)