Pass with professional 070-543 actual quiz materials

Microsoft 070-543 Exam Overview:

Microsoft 070-543 Exam Syllabus Topics:

Microsoft TS: Visual Studio Tools for 2007 MS Office System (VTSO) Sample Questions:

1. You create a document-level solution by using Visual Studio Tools for the Microsoft Office System (VSTO). The solution uses an assembly named MyAssembly. MyAssembly is located in the C:\Assemblies\ folder. A Microsoft Office Word 2003 document named MyWordDocument is located in the C:\Documents\ folder. You need to associate MyAssembly with MyWordDocument if managed extensions are enabled in MyWordDocument. Which code segment should you use?

A) Dim document As String = "C:\Documents\MyWordDocument.doc" Dim assembly As String = "C:\Assemblies\MyAssembly.dll" If ServerDocument.IsCacheEnabled (document) Then 'Add document customization End If
B) Dim document As String = "C:\Documents\MyWordDocument.doc" Dim assembly As String = "C:\Assemblies\MyAssembly.dll" If ServerDocument.IsCustomized (assembly) Then 'Add document customization End If
C) Dim document As String = "C:\Documents\MyWordDocument.doc" Dim assembly As String = "C:\Assemblies\MyAssembly.dll" If ServerDocument.IsCustomized (document) Then 'Add document customization End If
D) Dim document As String = "C:\Documents\MyWordDocument.doc" Dim assembly As String = "C:\Assemblies\MyAssembly.dll" If ServerDocument.IsCacheEnabled (assembly) Then 'Add document customization End If

2. You are creating a document-level solution for Microsoft Office Word 2003 by using Visual Studio Tools for the Microsoft Office System (VSTO).
You create the following objects in the solution:
a DataSet object named AWDataSet that contains two tables named Product and SalesOrderDetail
a BindingSource object named ProductsBindingSource
a bookmark that is bound to the SalesOrderDetail table You need to retrieve the active row from the solution .
Which code segment should you use?

A) AWDataSet.ProductRow pr = ( AWDataSet.ProductRow )((( DataRowView )( this.productBindingSource.Current )).Row);
B) AWDataSet.ProductRow pr = ( AWDataSet.ProductRow )((( DataRowView )( this.productBindingSource.SyncRoot )).Row);
C) AWDataSet.ProductRow pr = ( AWDataSet.ProductRow )((( DataRowView )( (object)this.productBindingSource.Filter)).Row);
D) AWDataSet.ProductRow pr = ( AWDataSet.ProductRow )((( DataRowView )( this.productBindingSource.DataSource )).Row);

3. You create a document-level solution by using Visual Studio Tools for the Microsoft Office System (VSTO). The solution uses an assembly named MyAssembly. MyAssembly is located in the C:\Assemblies\ folder. A Microsoft Office Word 2003 document named MyWordDocument is located in the C:\Documents\ folder. You need to associate MyAssembly with MyWordDocument if managed extensions are enabled in MyWordDocument. Which code segment should you use?

A) string document = @"C:\Documents\MyWordDocument.doc"; string assembly = @"C:\Assemblies\MyAssembly.dll"; if ( ServerDocument.IsCustomized (document)) { //Add document customization }
B) string document = @"C:\Documents\MyWordDocument.doc"; string assembly = @"C:\Assemblies\MyAssembly.dll"; if ( ServerDocument.IsCacheEnabled (document)) { //Add document customization }
C) string document = @"C:\Documents\MyWordDocument.doc"; string a ssembly = @"C:\Assemblies\MyAssembly.dll"; if ( ServerDocument.IsCustomized (assembly)) { //Add document customization }
D) string document = @"C:\Documents\MyWordDocument.doc"; string assembly = @"C:\Assemblies\MyAssembly.dll"; if ( ServerDocument.IsCacheEnabled (assembly)) { //Add document customization }

4. 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;Initial Catalog= AdventureWorks ;" & _ "Integrated Security=True")> _
B) < System.Configuration.DefaultSettingValueAttribute ( _ "Data Source= EXCELSQL.AdventureWorks ;" & _ "Initial Catalog= Production;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")> _

5. You are creating an add-in for Microsoft Office Word 2007 by using Visual Studio Tools for the Microsoft Office System (VSTO). You write the following lines of code.
Private Pane As Microsoft.Office.Tools.CustomTaskPane
Private Sub ThisAddIn_Startup _
(ByVal sender As Object, ByVal e As System.EventArgs)
Pane = Me.CustomTaskPanes.Add _
(New MyUserControl(), "Do Something")
End Sub
You need to display the custom task pane when text is selected in a Word document.
What should you do?

A) Create the following event handler for the Pane.VisibleChanged event. Private Sub Pane_VisibleChanged _ (ByVal sender As Object, ByVal e As EventArgs) Dim Doc As Word.Document = Application.ActiveDocument If Doc.Content.Text.Length > 0 Then Pane.Visible = False Else Pane.Visible = True End If End Sub
B) Create the following event handler for the Application.DocumentChange event. Private Sub Application_DocumentChange() Dim Doc As Word.Document = Application.ActiveDocument If Doc.Content.Text.Length > 0 Then Pane.Visible = False Else Pane.Visible = True End If End Sub
C) Create the following event handler for the Application.WindowActivate event. Private Sub Application_WindowActivate _ (ByVal Doc As Word.Document, ByVal Wn As Word.Window) If Doc.Content.Text.Length > 0 Then Pane.Visible = False Else Pane.Visible = True End If End Sub
D) Create the following event handler for the Application.WindowSelectionChange event. Private Sub Application_WindowSelectionChange(ByVal Sel As Word.Selection) If Sel.Start = Sel.End Then Pane.Visible = False Else Pane.Visible = True End If End Sub

Solutions: