显示标签为“70-502”的博文。显示所有博文
显示标签为“70-502”的博文。显示所有博文

2013年9月17日星期二

Microsoft 70-502 examen pratique questions et réponses

Si vous vous inscriez le test Microsoft 70-502, vous devez choisir une bonne Q&A. Le test Microsoft 70-502 est un test Certification très important dans l'Industrie IT. C'est essentielle d'une bonne préparation avant le test.

Le produit de Pass4Test peut assurer les candidats à réussir le test Microsoft 70-502 à la première fois, mais aussi offrir la mise à jour gratuite pendant un an, les clients peuvent recevoir les ressources plus nouvelles. Pass4Test n'est pas seulement un site, mais aussi un bon centre de service.

Vous pouvez s'exercer en Internet avec le démo gratuit. Vous allez découvrir que la Q&A de Pass4Test est laquelle le plus complète. C'est ce que vous voulez.

Les experts de Pass4Test ont fait sortir un nouveau guide d'étude de Certification Microsoft 70-502, avec ce guide d'étude, réussir ce test a devenu une chose pas difficile. Pass4Test vous permet à réussir 100% le test Microsoft 70-502 à la première fois. Les questions et réponses vont apparaître dans le test réel. Pass4Test peut vous donner une Q&A plus complète une fois que vous choisissez nous. D'ailleurs, la mise à jour gratuite pendant un an est aussi disponible pour vous.

Code d'Examen: 70-502
Nom d'Examen: Microsoft (TS: Microsoft .NET Framework 3.5 – Windows Presentation Foundation)
Questions et réponses: 128 Q&As

Les produits de Pass4Test sont recherchés par les experts de Pass4Test qui se profitent de leurs connaissances et leurs expériences dans l'Idustrie IT. Si vous allez participer le test Microsoft 70-502, vous devez choisir Pass4Test. La Q&A de Pass4Test peut vous aider à préparer mieux le test Microsoft 70-502 avec sa grande couiverture des questions. En face d'un test très difficile, vous pouvez obtenir le Certificat Microsoft 70-502 sans aucune doute.

Le test Microsoft 70-502 est une examination de techniques professionnelles dans l'Industrie IT. Pass4Test est un site qui peut vous aider à réussir le test Microsoft 70-502 rapidement. Si vous utiliser l'outil de formation avant le test, vous apprendrez tous essences de test Certification Microsoft 70-502.

70-502 Démo gratuit à télécharger: http://www.pass4test.fr/70-502.html

NO.1 You are creating a Windows Presentation Foundation application by using Microsoft .NET Framework

NO.2 You are creating a Windows Presentation Foundation application by using Microsoft .NET Framework
3.5.
The application defines a BrowserWindow class. Each instance of the BrowserWindow class allows the
user to browse a Web site in a separate window. When a new browser window is opened, the user is
redirected to a predefined URL.
You write the following code segment.
01 private void OpenNewWindow(object sender, RoutedEventArgs e)
02 {
03 Thread newWindowThread = new Thread(new
ThreadStart(NewThreadProc));
04
05 newWindowThread.Start();
06 }
07 private void NewThreadProc()
08 {
09 10 ?}
You need to ensure that the following requirements are met:
?The main window of the application is not blocked when an additional browser window is created.
?The application completes execution when the main window of the application is closed.
What should you do?
A. Insert the following code segment at line 04.
newWindowThread.SetApartmentState(ApartmentState.STA);
newWindowThread.IsBackground = true;
Insert the following code segment at line 09.
BrowserWindow newWindow = new BrowserWindow();
newWindow.Show();
Application app = new Application();
app.Run(newWindow);
B. Insert the following code segment at line 04.
newWindowThread.IsBackground = true;
Insert the following code segment at line 09.
newWindowThread.SetApartmentState(ApartmentState.STA);
BrowserWindow newWindow = new BrowserWindow();
newWindow.Show();
Application app = new Application();
app.Run(newWindow);
C. Insert the following code segment at line 04.
newWindowThread.SetApartmentState(ApartmentState.STA);
newWindowThread.IsBackground = false;
Insert the following code segment at line 09.
BrowserWindow newWindow = new BrowserWindow();
System.Windows.Threading.Dispatcher.Run();
newWindow.Show();
D. Insert the following code segment at line 04.
newWindowThread.SetApartmentState(ApartmentState.STA);
newWindowThread.IsBackground = true;
Insert the following code segment at line 09.
BrowserWindow newWindow = new BrowserWindow();
newWindow.Show();
System.Windows.Threading.Dispatcher.Run();
Answer: D

Microsoft   70-502   70-502

NO.3 You are creating a Windows Presentation Foundation application by using Microsoft .NET Framework
3.5.
You add a CommandBinding element to the Window element. The command has a keyboard gesture
CTRL+H. The Window contains the following MenuItem control.
<MenuItem Header="Highlight Content"
Command="local:CustomCommands.Highlight" />
You need to ensure that the MenuItem control is disabled and the command is not executable when the
focus shifts to a TextBox control that does not contain any text.
What should you do?
A. Set the IsEnabled property for the MenuItem control in the GotFocus event handler for the TextBox
controls.
B. Set the CanExecute property of the command to Highlight_CanExecute.
Add the following method to the code-behind file for the window.
private void Highlight_CanExecute(object sender, CanExecuteEventArgs e) {
TextBox txtBox = sender as TextBox;
e.CanExecute = (txtBox.Text.Length > 0);
}
C. Set the CanExecute property of the command to Highlight_CanExecute.
Add the following method to the code behind file for the window.
private void Highlight_CanExecute(object sender, CanExecuteEventArgs e) {
TextBox txtBox = e.Source as TextBox;
e.CanExecute = (txtBox.Text.Length > 0);
}
D. Set the CanExecute property of the command to Highlight_CanExecute.
Add the following method to the code behind file for the window.
private void Highlight_CanExecute(object sender, CanExecuteEventArgs e) {
MenuItem menu = e.Source as MenuItem;
TextBox txtBox = menu.CommandTarget as TextBox;
Menu.IsEnabled = (txtBox.Text.Length > 0);
}
Answer: C

certification Microsoft   certification 70-502   70-502 examen

NO.4 5.
You add a CommandBinding element to the Window element. The command has a keyboard gesture
CTRL+H. The Window contains the following MenuItem control.
<MenuItem Header="Highlight Content"
Command="local:CustomCommands.Highlight" />
You need to ensure that the MenuItem control is disabled and the command is not executable when the
focus shifts to a TextBox control that does not contain any text.
What should you do?
A. Set the IsEnabled property for the MenuItem control in the GotFocus event handler for the TextBox
controls.
B. Set the CanExecute property of the command to Highlight_CanExecute.
Add the following method to the code-behind file for the window.
Private Sub Highlight_CanExecute(ByVal sender As Object, _
ByVal e As CanExecuteRoutedEventArgs)
Dim txtBox As TextBox = CType(sender, TextBox)
e.CanExecute = (txtBox.Text.Length > 0)
End Sub
C. Set the CanExecute property of the command to Highlight_CanExecute.
Add the following method to the code-behind file for the window.
Private Sub Highlight_CanExecute(ByVal sender As Object, _
ByVal e As CanExecuteRoutedEventArgs)
Dim txtBox As TextBox
txtBox = CType(e.Source, TextBox)
e.CanExecute = (txtBox.Text.Length > 0)
End Sub
D. Set the CanExecute property of the command to Highlight_CanExecute.
Add the following method to the code-behind file for the window.
Private Sub Highlight_CanExecute(ByVal sender As Object, _
?ByVal e As CanExecuteRoutedEventArgs)
Dim Menu As MenuItem = CType(e.Source, MenuItem)
Dim txtBox As TextBox = CType(Menu.CommandTarget, TextBox)
Menu.IsEnabled = (txtBox.Text.Length > 0)
End Sub
Answer: C

Microsoft   certification 70-502   certification 70-502
3. You create a Windows Presentation Foundation application by using Microsoft .NET Framework 3.5.
The application is named EnterpriseApplication.exe.
You add the WindowSize parameter and the WindowPosition parameter to the Settings.settings file by
using the designer at the User Scope Level. The dimensions and position of the window are read from the
user configuration file.
The application must retain the original window size and position for each user who executes the
application.
You need to ensure that the following requirements are met:
?The window dimensions for each user are saved in the user configuration file.
?The user settings persist when a user exits the application.
Which configuration setting should you use?
A. private void OnClosing(object sender,
System.ComponentModel.CancelEventArgs e){
Settings.Default.WindowPosition = new Point (this.Left,
this.Top);
Settings.Default.WindowSize = new Size (this.Width,
this.Height);
Settings.Default.Save();
B. private void OnClosing(object sender,
System.ComponentModel.CancelEventArgs e){
RegistryKey appKey =
Registry.CurrentUser.CreateSubKey("Software\\EnterpriseApplication");
RegistryKey settingsKey = appKey.CreateSubKey("WindowSettings");
RegistryKey windowPositionKey =
settingsKey.CreateSubKey("WindowPosition");
RegistryKey windowSizeKey = settingsKey.CreateSubKey("WindowSize");
windowPositionKey.SetValue("X", this.Left);
windowPositionKey.SetValue("Y", this.Top);
windowSizeKey.SetValue("Width", this.Width);
windowSizeKey.SetValue("Height", this.Height);
C. private void OnClosing(object sender,
System.ComponentModel.CancelEventArgs e){
XmlDocument doc = new XmlDocument();
doc.Load("EnterpriseApplication.exe.config");
XmlNode nodePosition =
doc.SelectSingleNode("//setting[@name=\'WindowPosition\']");
nodePosition.ChildNodes[0].InnerText = String.Format("{0},{1}",
this.Left, this.Top);
XmlNode nodeSize =
doc.SelectSingleNode("//setting[@name=\'WindowSize\']");
nodeSize.ChildNodes[0].InnerText = String.Format("{0},{1}",
this.Width, this.Height);
doc.Save("UserConfigDistractor2.exe.config");
D. private void Window_Closing(object sender,
System.ComponentModel.CancelEventArgs e){
StreamWriter sw =
new StreamWriter("EnterpriseApplication.exe.config", true);
sw.WriteLine("<EnterpriseApplication.Properties.Settings>");
sw.WriteLine("<setting name=
\"WindowSize\" serializeAs=\"String\">");
sw.WriteLine(String.Format("<value>{0},{1}</value>",
this.Width, this.Height));
sw.WriteLine("</setting>");
sw.WriteLine("<setting name=
\"WindowPosition\" serializeAs=\"String\">");
sw.WriteLine(String.Format("<value>{0},{1}</value>", this.Left,
this.Top));
sw.WriteLine("</setting>");
sw.WriteLine("</UserConfigProblem.Properties.Settings>");
sw.Close();
Answer: A

Microsoft examen   70-502   70-502 examen   70-502

NO.5 You have created a Windows Presentation Foundation application by using Microsoft .NET Framework
3.5. The application, named EnterpriseApplication.exe, runs over the network.
You add the WindowSize parameter and the WindowPosition parameter to the Settings.settings file by
using the designer at the User Scope Level. The dimensions and position of the window are read from the
user configuration file.
The application must retain the original window size and position for users executing the application.
You need to ensure that the following requirements are met:
?The window dimensions for each user are saved in the user configuration file.
?User settings persist when a user exits the application.
Which configuration setting should you use?
A. Private Sub OnClosing(ByVal sender As Object, ByVal e _
As System.ComponentModel.CancelEventArgs)
My.Settings.Default.WindowPosition = New Point(Me.Left, Me.Top)
My.Settings.Default.WindowSize = New Size(Me.Width, Me.Height)
My.Settings.Default.Save()
End Sub
B. Private Sub OnClosing(ByVal sender As Object, ByVal e As _
System.ComponentModel.CancelEventArgs)
Dim appKey As RegistryKey = _
Registry.CurrentUser.CreateSubKey("Software\EnterpriseApplication")
Dim settingsKey As RegistryKey = _
appKey.CreateSubKey("WindowSettings")
Dim windowPositionKey As RegistryKey = _
settingsKey.CreateSubKey("WindowPosition")
Dim windowSizeKey As RegistryKey = _
settingsKey.CreateSubKey("WindowSize")
windowPositionKey.SetValue("X", Me.Left)
windowPositionKey.SetValue("Y", Me.Top)
windowSizeKey.SetValue("Width", Me.Width)
windowSizeKey.SetValue("Height", Me.Height)
End Sub
C. Private Sub OnClosing(ByVal sender As Object, ByVal e As _
System.ComponentModel.CancelEventArgs)
Dim doc As New System.Xml.XmlDocument()
doc.Load("EnterpriseApplication.exe.config")
Dim nodePosition As System.Xml.XmlNode = _
doc.SelectSingleNode("//setting[@name='WindowPosition']")
nodePosition.ChildNodes(0).InnerText = String.Format("{0},{1}", _
Me.Left, Me.Top)
Dim nodeSize As System.Xml.XmlNode = _
doc.SelectSingleNode("//setting[@name='WindowSize']")
nodeSize.ChildNodes(0).InnerText = String.Format("{0},{1}", _
Me.Width, Me.Height)
doc.Save("UserConfigDistractor2.exe.config")
End Sub
D. Private Sub Window_Closing(ByVal sender As Object, ByVal e As _
System.ComponentModel.CancelEventArgs)
Dim sw As New StreamWriter("EnterpriseApplication.exe.config", True)
sw.WriteLine("<EnterpriseApplication.Properties.Settings>")
sw.WriteLine("<setting name=""WindowSize"" serializeAs=""String"">")
sw.WriteLine(String.Format("<value>{0},{1}</value>", Me.Width, _
Me.Height))
sw.WriteLine("</setting>")
sw.WriteLine("<setting name=""WindowPosition"" _
serializeAs=""String"">")
sw.WriteLine(String.Format("<value>{0},{1}</value>", Me.Left, _
Me.Top))
sw.WriteLine("</setting>")
sw.WriteLine("</UserConfigProblem.Properties.Settings>")
sw.Close()
End Sub
Answer: A

Microsoft examen   70-502   certification 70-502   70-502

NO.6 You are creating a Windows Presentation Foundation application by using Microsoft .NET Framework
3.5.
The application defines a BrowserWindow class. Each instance of the BrowserWindow class allows the
user to browse a Web site in a separate window. When a new browser window is opened, the user is
redirected to a predefined URL.
You write the following code segment.
01 Private Sub OpenNewWindow(ByVal sender As Object, _
02 ?ByVal e As RoutedEventArgs)
03 Dim newWindowThread As New Thread(New _
04 ThreadStart(AddressOf NewThreadProc))
05
06 newWindowThread.Start()
07 End Sub
08 Private Sub NewThreadProc()
09 10 End Sub
You need to ensure that the following requirements are met:
?The main window of the application is not blocked when an additional browser window is created.
?The application completes execution when the main window of the application is closed.
What should you do?
A. Insert the following code segment at line 05.
newWindowThread.SetApartmentState(ApartmentState.STA)
newWindowThread.IsBackground = True
Insert the following code segment at line 09.
Dim newWindow As New BrowserWindow()
newWindow.Show()
Dim app As New Application()
app.Run(newWindow)
B. Insert the following code segment at line 05.
newWindowThread.IsBackground = True
Insert the following code segment at line 09.
newWindowThread.SetApartmentState(ApartmentState.STA)
Dim newWindow As New BrowserWindow()
newWindow.Show()
Dim app As New Application()
app.Run(newWindow)
C. Insert the following code segment at line 05.
newWindowThread.SetApartmentState(ApartmentState.STA)
newWindowThread.IsBackground = False
Insert the following code segment at line 09.
Dim newWindow As New BrowserWindow()
System.Windows.Threading.Dispatcher.Run()
newWindow.Show()
D. Insert the following code segment at line 05.
newWindowThread.SetApartmentState(ApartmentState.STA)
newWindowThread.IsBackground = True
Insert the following code segment at line 09.
Dim newWindow As New BrowserWindow()
newWindow.Show()
System.Windows.Threading.Dispatcher.Run()
Answer: D 7. You are creating a Windows Presentation Foundation application by using Microsoft .NET
Framework 3.5.
The application uses several asynchronous operations to calculate data that is displayed to the user. An
operation named tommorowsWeather performs calculations that will be used by other operations.
You need to ensure that tommorowsWeather runs at the highest possible priority.
Which code segment should you use?
A. tomorrowsWeather.Dispatcher.BeginInvoke(
System.Windows.Threading.DispatcherPriority.Normal,
new OneArgDelegate(UpdateUserInterface),
weather);
B. tomorrowsWeather.Dispatcher.BeginInvoke(
System.Windows.Threading.DispatcherPriority.DataBind,
new OneArgDelegate(UpdateUserInterface),
weather);
C. tomorrowsWeather.Dispatcher.BeginInvoke(
System.Windows.Threading.DispatcherPriority.Send,
new OneArgDelegate(UpdateUserInterface),
weather);
D. tomorrowsWeather.Dispatcher.BeginInvoke(
System.Windows.Threading.DispatcherPriority.Render,
new OneArgDelegate(UpdateUserInterface),
weather);
Answer: C 8. You are creating a Windows Presentation Foundation application by using Microsoft .NET
Framework 3.5.
The application uses several asynchronous operations to calculate data that is displayed to the user. An
operation named tommorowsWeather performs calculations that will be used by other operations.
You need to ensure that tommorowsWeather runs at the highest possible priority.
Which code segment should you use?
A. tomorrowsWeather.Dispatcher.BeginInvoke( _
System.Windows.Threading.DispatcherPriority.Normal, _
New OneArgDelegate(AddressOf UpdateUserInterface), weather)
B. tomorrowsWeather.Dispatcher.BeginInvoke( _
?System.Windows.Threading.DispatcherPriority.DataBind, _
?New OneArgDelegate(AddressOf UpdateUserInterface), weather)
C. tomorrowsWeather.Dispatcher.BeginInvoke( _
System.Windows.Threading.DispatcherPriority.Send, _
New OneArgDelegate(AddressOf UpdateUserInterface), weather)
D. tomorrowsWeather.Dispatcher.BeginInvoke( _
System.Windows.Threading.DispatcherPriority.Render, _
New OneArgDelegate(AddressOf UpdateUserInterface), weather)
Answer: C 9. You are creating a Windows Presentation Foundation application by using Microsoft .NET
Framework 3.5.
You create a window for the application.
You need to ensure that the following requirements are met:
?An array of strings is displayed by using a ListBox control in a two-column format.
?The data in the ListBox control flows from left to right and from top to bottom.
What should you do?
A. Use a ListBox control defined in the following manner.
<ListBox Name="myList">
<ListBox.ItemsPanel>
<ItemsPanelTemplate>
<UniformGrid Columns="2"/>
</ItemsPanelTemplate>
</ListBox.ItemsPanel>
</ListBox>
Use the following C# code to associate the array of strings to the ListBox control.
myList.ItemsSource = arrayOfString;
B. Use a ListBox control defined in the following manner.
<ListBox Name="myList">
<ListBox.ItemsPanel>
<ItemsPanelTemplate>
<StackPanel />
</ItemsPanelTemplate>
</ListBox.ItemsPanel>
</ListBox>
Use the following C# code to associate the array of strings to the ListBox control.
myList.ItemsSource = arrayOfString;
C. Use a ListBox control defined in the following manner.
<ListBox Name="myList">
<ListBox.ItemsPanel>
<ItemsPanelTemplate>
<WrapPanel />
</ItemsPanelTemplate>
</ListBox.ItemsPanel>
</ListBox>
Use the following C# code to associate the array of strings to the ListBox control.
myListView.ItemsSource = arrayOfString;
D. Use a ListBox control defined in the following manner.
<ListBox Name="myList">
<ListBox.ItemsPanel>
<ItemsPanelTemplate>
<Grid>
<Grid.ColumnDefinitions>
<ColumnDefinition />
<ColumnDefinition />
</Grid.ColumnDefinitions>
</Grid>
</ItemsPanelTemplate>
</ListBox.ItemsPanel>
</ListBox>
Use the following C# code to associate the array of strings to the ListBox control.
myList.ItemsSource = arrayOfString;
Answer: A

Microsoft   70-502   70-502   certification 70-502
10. You are creating a Windows Presentation Foundation application by using Microsoft .NET Framework
3.5.
You create a window for the application.
You need to ensure that the following requirements are met:
?An array of strings is displayed by using a ListBox control in a two-column format.
?The data in the ListBox control flows from left to right and from top to bottom.
What should you do?
A. Use a ListBox control defined in the following manner.
<ListBox Name="myList">
<ListBox.ItemsPanel>
<ItemsPanelTemplate>
<UniformGrid Columns="2"/>
</ItemsPanelTemplate>
</ListBox.ItemsPanel>
</ListBox>
Use the following VB.net code to associate the array of strings to the ListBox control.
myList.ItemsSource = arrayOfString
B. Use a ListBox control defined in the following manner.
<ListBox Name="myList">
<ListBox.ItemsPanel>
<ItemsPanelTemplate>
<StackPanel />
</ItemsPanelTemplate>
</ListBox.ItemsPanel>
</ListBox>
Use the following vb.net code to associate the array of strings to the ListBox control.
myList.ItemsSource = arrayOfString
C. Use a ListBox control defined in the following manner.
<ListBox Name="myList">
<ListBox.ItemsPanel>
<ItemsPanelTemplate>
<WrapPanel />
</ItemsPanelTemplate>
</ListBox.ItemsPanel>
</ListBox>
Use the following vb.net code to associate the array of strings to the ListBox control.
myListView.ItemsSource = arrayOfString
D. Use a ListBox control defined in the following manner.
<ListBox Name="myList">
<ListBox.ItemsPanel>
<ItemsPanelTemplate>
<Grid>
<Grid.ColumnDefinitions>
<ColumnDefinition />
<ColumnDefinition />
</Grid.ColumnDefinitions>
</Grid>
</ItemsPanelTemplate>
</ListBox.ItemsPanel>
</ListBox>
Use the following vb.net code to associate the array of strings to the ListBox control.
myList.ItemsSource = arrayOfString
Answer: A

Microsoft examen   70-502   70-502 examen   70-502
11. You create a form by using Windows Presentation Foundation and Microsoft .NET Framework 3.5.
The form contains a status bar.
You plan to add a ProgressBar control to the status bar.
You need to ensure that the ProgressBar control displays the progress of a task for which you cannot
predict the completion time.
Which code segment should you use?
A. progbar.IsIndeterminate = true;
B. progbar.IsIndeterminate = false;
C. progbar.HasAnimatedProperties = true;
D. progbar.HasAnimatedProperties = false;
Answer: A

Microsoft   70-502   70-502   70-502
12. You create a form by using Windows Presentation Foundation and Microsoft .NET Framework 3.5.
The form contains a status bar.
You plan to add a ProgressBar control to the status bar.
You need to ensure that the ProgressBar control displays the progress of a task for which you cannot
predict the completion time.
Which code segment should you use?
A. progbar.IsIndeterminate = True
B. progbar.IsIndeterminate = False
C. progbar.HasAnimatedProperties = True
D. progbar.HasAnimatedProperties = False
Answer: A

certification Microsoft   70-502 examen   70-502 examen   certification 70-502
13. You are converting a Windows Forms application to a Windows Presentation Foundation (WPF)
application. You use Microsoft .NET Framework 3.5 to create the WPF application.
The WPF application will reuse 30 forms of the Windows Forms application.
The WPF application contains the following class definition.
public class OwnerWindow :
System.Windows.Forms.IWin32Window
private IntPtr handle;
public IntPtr Handle
get { return handle; }
set { handle=value; }
}
}
You write the following code segment in the WPF application. (Line numbers are included for reference
only.)
01 public DialogResult LaunchWindowsFormsDialog(
02 ?Form dialog, Window wpfParent)
03 {
04 WindowInteropHelper helper=new
05 ?WindowInteropHelper(wpfParent);
06 OwnerWindow owner=new OwnerWindow();
07
08 }
You need to ensure that the application can launch the reusable forms as modal dialogs.
Which code segment should you insert at line 07?
A.owner.Handle = helper.Owner;
return dialog.ShowDialog(owner);
B. owner.Handle = helper.Handle;
return dialog.ShowDialog(owner);
C. owner.Handle = helper.Owner;
bool? result = wpfParent.ShowDialog();
if (result.HasValue)
return result.Value ? System.Windows.Forms.DialogResult.OK :
System.Windows.Forms.DialogResult.Cancel;
else
return System.Windows.Forms.DialogResult.Cancel;
D. owner.Handle = helper.Handle;
bool? result = wpfParent.ShowDialog();
if (result.HasValue)
return result.Value ? System.Windows.Forms.DialogResult.OK :
System.Windows.Forms.DialogResult.Cancel;
else
return System.Windows.Forms.DialogResult.Cancel;
Answer: B

Microsoft   70-502   70-502 examen   70-502
14. You are converting a Windows Forms application to a Windows Presentation Foundation (WPF)
application. You use Microsoft .NET Framework 3.5 to create the WPF application.
The WPF application will reuse 30 forms of the Windows Forms application.
The WPF application contains the following class definition.
Public Class OwnerWindow
Implements System.Windows.Forms.IWin32Window
Private handle_Renamed As IntPtr
Public Property Handle() As IntPtr _
Implements System.Windows.Forms.IWin32Window.Handle
Get
Return handle_Renamed
End Get
Set(ByVal value As IntPtr)
handle_Renamed = value
End Set
End Property
End Class
You write the following code segment in the WPF application. (Line numbers are included for reference
only.)
01 Public Function LaunchWindowsFormsDialog(ByVal dialog As _
02 ?System.Windows.Forms.Form, ByVal wpfParent As Window) As _
03 ?System.Windows.Forms.DialogResult
04 Dim helper As New
05 System.Windows.Interop.WindowInteropHelper(wpfParent)
07 Dim owner As New OwnerWindow()
08
09 End Function
You need to ensure that the application can launch the reusable forms as modal dialogs.
Which code segment should you insert at line 08?
Aowner.Handle = helper.Owner
Dim db As New System.Windows.Forms.DialogResult()
Return db
B. owner.Handle = helper.Owner
Return dialog.ShowDialog(owner)
C. owner.Handle = helper.Owner
Dim result As Nullable(Of Boolean) = wpfParent.ShowDialog()
If result.HasValue Then
eturn If(result.Value, System.Windows.Forms.DialogResult.OK, _
?System.Windows.Forms.DialogResult.Cancel)
Else
Return System.Windows.Forms.DialogResult.Cancel
End If
D. owner.Handle = helper.Handle
Dim result As Nullable(Of Boolean) = wpfParent.ShowDialog()
If result.HasValue Then
Return If(result.Value, System.Windows.Forms.DialogResult.OK, _
?System.Windows.Forms.DialogResult.Cancel)
Else
Return System.Windows.Forms.DialogResult.Cancel
End If
Answer: B 15. You are creating a Windows Presentation Foundation (WPF) application by using
Microsoft .NET Framework 3.5.
The WPF application has a Grid control named rootGrid.
You write the following XAML code fragment.
<Window x:Class="MCP.HostingWinFormsControls"
xmlns="http://schemas.microsoft.com/winfx/2006/xaml/
presentation"
xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
Title="HostingWinFormsControls"
Loaded="Window_Loaded">
<Grid x:Name="rootGrid">
</Grid>
</Window>
You need to ensure that each time the WPF window opens, a Windows Forms control named
MyCustomFormsControl is added to rootGrid.
Which code segment should you use?
A.private void Window_Loaded(object sender, RoutedEventArgs e)
WindowsFormsHost host = new WindowsFormsHost();
MyCustomFormsControl formsControl = new MyCustomFormsControl();
host.Child = formsControl;
rootGrid.Children.Add(host);
B. private void Window_Loaded(object sender, RoutedEventArgs e)
ElementHost host = new ElementHost();
MyCustomFormsControl formsControl=new MyCustomFormsControl();
host.Child=formsControl;
rootGrid.Children.Add(host);
C. private void Window_Loaded(object sender, RoutedEventArgs e)
MyCustomFormsControl formsControl=new MyCustomFormsControl();
formsControl.CreateControl();
HwndSource source = HwndSource.FromHwnd(formsControl.Handle);
UIElement formsElement = source.RootVisual as UIElement;
rootGrid.Children.Add(formsElement);
D. private void Window_Loaded(object sender, RoutedEventArgs e)
MyCustomFormsControl formsControl=new MyCustomFormsControl();
formsControl.CreateControl();
HwndTarget target = new HwndTarget(formsControl.Handle);
UIElement formsElement = target.RootVisual as UIElement;
rootGrid.Children.Add(formsElement);
Answer: A

certification Microsoft   certification 70-502   70-502   70-502   certification 70-502
16.You are creating a Windows Presentation Foundation (WPF) application by using Microsoft .NET
Framework 3.5.
The WPF application has a Grid control named rootGrid.
You write the following XAML code fragment.
<Window x:Class="MCP.HostingWinFormsControls"
xmlns="http://schemas.microsoft.com/winfx/2006/xaml/
presentation"
xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
Title="HostingWinFormsControls"
Loaded="Window_Loaded">
<Grid x:Name="rootGrid">
</Grid>
</Window>
You need to ensure that each time the WPF window opens, a Windows Forms control named
MyCustomFormsControl is added to rootGrid.
Which code segment should you use?
APrivate Sub Window_Loaded(ByVal sender As Object, ByVal e As _
RoutedEventArgs)
Dim host As New WindowsFormsHost()
Dim formsControl As New MyCustomFormsControl()
host.Child = formsControl;
rootGrid.Children.Add(host);
End Sub
B. Private Sub Window_Loaded(ByVal sender As Object, ByVal e As _
RoutedEventArgs)
Dim host As New ElementHost()
Dim formsControl As New MyCustomFormsControl()
host.Child = formsControl;
rootGrid.Children.Add(host);
End Sub
C. Private Sub Window_Loaded(ByVal sender As Object, ByVal e As _
RoutedEventArgs)
Dim formsControl As New MyCustomFormsControl()
formsControl.CreateControl()
Dim target As New HwndTarget(formsControl.Handle)
Dim formsElement As UIElement = TryCast(target.RootVisual, _
UIElement)
rootGrid.Children.Add(formsElement)
End Sub
D. Private Sub Window_Loaded(ByVal sender As Object, ByVal e As _
RoutedEventArgs)
Dim formsControl As New MyCustomFormsControl()
formsControl.CreateControl()
Dim source As HwndSource = HwndSource.FromHwnd(formsControl.Handle)
Dim formsElement As UIElement = TryCast(source.RootVisual, _
UIElement)
rootGrid.Children.Add(formsElement)
End Sub
Answer: A

Microsoft examen   70-502 examen   70-502
17. You are creating a Windows Presentation Foundation application by using Microsoft .NET Framework
3.5.
You include functionality in the application to troubleshoot the window behavior.
You need to display a list of UI elements at a position in the window that is decided by the mouse click.
You also need to ensure that the list of elements is displayed in a message box.
Which code segment should you include in the code-behind file?
Astring controlsToDisplay = string.Empty;
private void Window_MouseDown(object sender, MouseButtonEventArgs e) {
controlsToDisplay = ((UIElement)sender).ToString();
MessageBox.Show(controlsToDisplay);
B. string controlsToDisplay = string.Empty;
private void Window_MouseDown(object sender, MouseButtonEventArgs e) {
for (int i = 0; i < this.VisualChildrenCount; i++) {
controlsToDisplay + = this.GetVisualChild(i).ToString() + "\r\n";
MessageBox.Show(controlsToDisplay);
C. string controlsToDisplay = string.Empty;
private void Window_MouseDown (object sender, MouseButtonEventArgs e)
Visual myVisual;
for (int i = 0; i < VisualTreeHelper.GetChildrenCount(sender as
Visual); i++) {
myVisual = (Visual)VisualTreeHelper.GetChild(sender as Visual, i);
controlsToDisplay += myVisual.GetType().ToString() + "\r\n";
MessageBox.Show(controlsToDisplay);
D. string controlsToDisplay = string.Empty;
private void Window_MouseDown(object sender, MouseButtonEventArgs e) {
Point pt = e.GetPosition(this);
VisualTreeHelper.HitTest(this, null, new
HitTestResultCallback(HitTestCallback), new
PointHitTestParameters(pt));
MessageBox.Show(controlsToDisplay);
private HitTestResultBehavior HitTestCallback(HitTestResult result) {
controlsToDisplay += result.VisualHit.GetType().ToString() + "\r\n";
return HitTestResultBehavior.Continue;
Answer: D

Microsoft   70-502   70-502 examen   70-502
18. You are creating a Windows Presentation Foundation application by using Microsoft .NET Framework
3.5.
You include functionality in the application to troubleshoot the window behavior.
You need to display a list of UI elements at a position in the window that is decided by the mouse click.
You also need to ensure that the list of elements is displayed in a message box.
Which code segment should you include in the code-behind file?
A.Dim controlsToDisplay As String = String.Empty
Private Sub Window_MouseDown(ByVal sender As Object, _
ByVal e As MouseButtonEventArgs)
controlsToDisplay = CType(sender, UIElement).ToString()
MessageBox.Show(controlsToDisplay)
End Sub
B. Dim controlsToDisplay As String = String.Empty
Private Sub Window_MouseDown(ByVal sender As Object, _
ByVal e As MouseButtonEventArgs)
For i = 0 To VisualChildrenCount - 1
controlsToDisplay += GetVisualChild(i).ToString() + "\r\n"
Next
MessageBox.Show(controlsToDisplay)
End Sub
C. Dim controlsToDisplay As String = String.Empty
Private Sub Window_MouseDown(ByVal sender As Object, _
ByVal e As MouseButtonEventArgs)
Dim myVisual As Visual()
For i = 0 To VisualTreeHelper.GetChildrenCount(CType(sender, _
Visual)) - 1
myVisual(i) = CType(VisualTreeHelper.GetChild(CType(sender, _
Visual), i), Visual)
controlsToDisplay += myVisual.GetType().ToString() + "\r\n"
Next
MessageBox.Show(controlsToDisplay)
End Sub
D. Dim controlsToDisplay As String = String.Empty
Private Sub Window_MouseDown(ByVal sender As Object, _
ByVal e As MouseButtonEventArgs)
Dim pt As Point = e.GetPosition(Me)
VisualTreeHelper.HitTest(Me, Nothing, _
New HitTestResultCallback(AddressOf HitTestCallback), _
New PointHitTestParameters(pt))
MessageBox.Show(controlsToDisplay)
End Sub
Private Function HitTestCallback(ByVal result As HitTestResult) As _
HitTestResultBehavior
controlsToDisplay += result.VisualHit.GetType().ToString() + "\r\n"
Return HitTestResultBehavior.Continue
End Function
Answer: D

certification Microsoft   70-502 examen   70-502
19. You are creating a Windows Presentation Foundation application by using Microsoft .NET Framework
3.5.
You write the following code segment (Line numbers are included for reference only).
01 Dim content As Object
02 Dim fileName As String = "theFile"
03 Using xamlFile As New FileStream(fileName & ".xaml", _
04 FileMode.Open, FileAccess.Read)
06 content = TryCast(XamlReader.Load(xamlFile), Object)
07 End Using
08 Using container As Package = Package.Open(fileName & ".xps", _
09 FileMode.Create)1011 End Using
You need to ensure that the following requirements are met:
The application converts an existing flow document into an XPS document.
The XPS document is generated by using the flow document format.
The XPS document has the minimum possible size.
Which code segment should you insert at line 10?
A
Using xpsDoc As New XpsDocument(container, _
CompressionOption.SuperFast)
Dim rsm As XpsSerializationManager = New _
System.Windows.Xps.XpsSerializationManager(New _
XpsPackagingPolicy(xpsDoc), False)
rsm.SaveAsXaml(paginator)
End Using
B. Using xpsDoc As New XpsDocument(container, _
CompressionOption.SuperFast)
Dim rsm As New XpsSerializationManager(New _
XpsPackagingPolicy(xpsDoc), False)
rsm.Commit()
End Using
C. Using xpsDoc As New XpsDocument(container, _
CompressionOption.Maximum)
Dim rsm As New XpsSerializationManager(New _
XpsPackagingPolicy(xpsDoc), False)
Dim paginator As DocumentPaginator = (CType(content, _
IDocumentPaginatorSource)).DocumentPaginator
rsm.SaveAsXaml(paginator)
End Using
D. Using xpsDoc As New XpsDocument(container, _
CompressionOption.SuperFast)
Dim rsm As New XpsSerializationManager(New _
XpsPackagingPolicy(xpsDoc), False)
Dim paginator As DocumentPaginator = (CType(content, _
IDocumentPaginatorSource)).DocumentPaginator
rsm.SaveAsXaml(paginator)
End Using
Answer: C

Microsoft   70-502   certification 70-502   70-502
20. You are creating a Windows Presentation Foundation application by using Microsoft .NET Framework
3.5.
You write the following code segment (Line numbers are included for reference only).
01 Dim content As Object
02 Dim fileName As String = "theFile"
03 Using xamlFile As New FileStream(fileName & ".xaml", _
04 ?FileMode.Open, FileAccess.Read)
06 content = TryCast(XamlReader.Load(xamlFile), Object)
07 End Using
08 Using container As Package = Package.Open(fileName & ".xps", _
09 ?FileMode.Create)10 11 End Using
You need to ensure that the following requirements are met:
The application converts an existing flow document into an XPS document.
The XPS document is generated by using the flow document format.
The XPS document has the minimum possible size.
Which code segment should you insert at line 10?
A.Using xpsDoc As New XpsDocument(container, _
CompressionOption.SuperFast)
Dim rsm As XpsSerializationManager = New _
System.Windows.Xps.XpsSerializationManager(New _
XpsPackagingPolicy(xpsDoc), False)
rsm.SaveAsXaml(paginator)
End Using
B. Using xpsDoc As New XpsDocument(container, _
CompressionOption.SuperFast)
Dim rsm As New XpsSerializationManager(New _
XpsPackagingPolicy(xpsDoc), False)
rsm.Commit()
End Using
C. Using xpsDoc As New XpsDocument(container, _
CompressionOption.Maximum)
Dim rsm As New XpsSerializationManager(New _
XpsPackagingPolicy(xpsDoc), False)
Dim paginator As DocumentPaginator = (CType(content, _
IDocumentPaginatorSource)).DocumentPaginator
rsm.SaveAsXaml(paginator)
End Using
D. Using xpsDoc As New XpsDocument(container, _
CompressionOption.SuperFast)
Dim rsm As New XpsSerializationManager(New _
XpsPackagingPolicy(xpsDoc), False)
Dim paginator As DocumentPaginator = (CType(content, _
IDocumentPaginatorSource)).DocumentPaginator
rsm.SaveAsXaml(paginator)
End Using
Answer: C

Microsoft examen   70-502   certification 70-502   70-502 examen
21. You are creating a Windows Presentation Foundation application by using Microsoft .NET Framework
3.5.
The application displays documents by using an instance of the FlowDocumentPageViewer class. The
instance is named fdpv. Users can highlight and annotate the content of the documents.
You need to ensure that annotations made to a document are saved and rendered when the document is
displayed again.
Which code segment should you use?
A.protected void OnTextInput(object sender, RoutedEventArgs e) {
AnnotationService service = AnnotationService.GetService(fdpv);
if (service == null) {
AnnotationStream = new FileStream("annotations.xml",
FileMode.Open, FileAccess.ReadWrite);
service = new AnnotationService(fdpv);
AnnotationStore store = new XmlStreamStore(AnnotationStream);
service.Enable(store);
}
}
private void OnClosing(object sender,
System.ComponentModel.CancelEventArgs e) {
AnnotationService service = AnnotationService.GetService(fdpv);
if (service != null && service.IsEnabled) {
service.Store.Flush();
service.Disable();
AnnotationStream.Close();
}
}
B. protected void OnLoaded(object sender, RoutedEventArgs e) {
AnnotationService service = AnnotationService.GetService(fdpv);
if (service == null) {
AnnotationStream = new FileStream("annotations.xml",
FileMode.Open, FileAccess.ReadWrite);
service = new AnnotationService(fdpv);
}
}
private void OnClosing(object sender,
?System.ComponentModel.CancelEventArgs e) {
AnnotationService service = AnnotationService.GetService(fdpv);
if (service != null && service.IsEnabled) {
service.Store.Flush();
service.Disable();
AnnotationStream.Close();
}
}
C. protected void OnLoaded(object sender, RoutedEventArgs e) {
AnnotationService service = AnnotationService.GetService(fdpv);
if (service == null) {
AnnotationStream = new FileStream("annotations.xml",
FileMode.Open, FileAccess.ReadWrite);
service = new AnnotationService(fdpv);
AnnotationStore store = new XmlStreamStore(AnnotationStream);
service.Enable(store);
}
}
private void OnClosing(object sender,
System.ComponentModel.CancelEventArgs e) {
AnnotationService service = AnnotationService.GetService(fdpv);
if (service != null && service.IsEnabled) {
service.Store.Flush();
service.Disable();
AnnotationStream.Close();
}
}
D. protected void OnLoaded(object sender, RoutedEventArgs e) {
AnnotationService service = AnnotationService.GetService(fdpv);
if (service == null) {
AnnotationStream = new FileStream("annotations.xml",
FileMode.Open, FileAccess.ReadWrite);
service = new AnnotationService(fdpv);
AnnotationStore store = new XmlStreamStore(AnnotationStream);
service.Enable(store);
}
}
private void OnClosing(object sender,
System.ComponentModel.CancelEventArgs e) {
AnnotationService service = AnnotationService.GetService(fdpv);
if (service != null && service.IsEnabled) {
service.Disable();
AnnotationStream.Close();
}
}
Answer: C

Microsoft   70-502   certification 70-502   70-502   70-502
22. You are creating a Windows Presentation Foundation application by using Microsoft .NET Framework
3.5.
The application will display documents by using an instance of the FlowDocumentPageViewer class. The
instance is named fdpv. Users can highlight and annotate the content of the documents.
You need to ensure that annotations made to a document are saved and rendered when the document is
displayed again.
Which code segment should you use?
A. Protected Sub OnTextInput(ByVal sender As Object, _
ByVal e As RoutedEventArgs)
Dim service As AnnotationService = _
AnnotationService.GetService(fdpv)
If service Is Nothing Then
AnnotationStream = New FileStream("annotations.xml", _
FileMode.Open, FileAccess.ReadWrite)
service = New AnnotationService(fdpv)
Dim store As AnnotationStore = _
New XmlStreamStore(AnnotationStream)
service.Enable(store)
End If
End Sub
Private Sub OnClosing(ByVal sender As Object, _
ByVal e As System.ComponentModel.CancelEventArgs)
Dim service As AnnotationService = _
AnnotationService.GetService(fdpv)
If Not service Is Nothing AndAlso service.IsEnabled Then
service.Store.Flush()
srvice.Disable()
AnnotationStream.Close()
End If
End Sub
B. Protected Sub OnLoaded(ByVal sender As Object, _
ByVal e As RoutedEventArgs)
Dim service As AnnotationService = _
AnnotationService.GetService(fdpv)
If service Is Nothing Then
AnnotationStream = New FileStream("annotations.xml", _
FileMode.Open, FileAccess.ReadWrite)
service = New AnnotationService(fdpv)
End If
End Sub
Private Sub OnClosing(ByVal sender As Object, _
ByVal e As System.ComponentModel.CancelEventArgs)
Dim service As AnnotationService = _
AnnotationService.GetService(fdpv)
If Not service Is Nothing AndAlso service.IsEnabled Then
service.Store.Flush()
service.Disable()
AnnotationStream.Close()
End If
End Sub
C. Protected Sub OnLoaded(ByVal sender As Object, _
ByVal e As RoutedEventArgs)
Dim service As AnnotationService = _
AnnotationService.GetService(fdpv)
If service Is Nothing Then
AnnotationStream = New FileStream("annotations.xml", _
FileMode.Open, FileAccess.ReadWrite)
service = New AnnotationService(fdpv)
Dim store As AnnotationStore = New _
XmlStreamStore(AnnotationStream)
service.Enable(store)
End If
End Sub
Private Sub OnClosing(ByVal sender As Object, _
ByVal e As System.ComponentModel.CancelEventArgs)
Dim service As AnnotationService = _
AnnotationService.GetService(fdpv)
If Not service Is Nothing AndAlso service.IsEnabled Then
service.Store.Flush()
service.Disable()
AnnotationStream.Close()
End If
End Sub
D. Protected Sub OnLoaded(ByVal sender As Object, _
ByVal e As RoutedEventArgs)
Dim service As AnnotationService = _
AnnotationService.GetService(fdpv)
If service Is Nothing Then
AnnotationStream = New FileStream("annotations.xml", _
FileMode.Open, FileAccess.ReadWrite)
service = New AnnotationService(fdpv)
Dim store As AnnotationStore = New _
XmlStreamStore(AnnotationStream)
service.Enable(store)
End If
End Sub
Private Sub OnClosing(ByVal sender As Object, _
ByVal e As System.ComponentModel.CancelEventArgs)
Dim service As AnnotationService = _
AnnotationService.GetService(fdpv)
If Not service Is Nothing AndAlso service.IsEnabled Then
service.Disable()
AnnotationStream.Close()
End If
End Sub
Answer: C

Microsoft   70-502 examen   70-502   70-502 examen   certification 70-502
23. You are creating a Windows Presentation Foundation application by using Microsoft .NET Framework
3.5.
You plan to use the application to preview video files.
You write the following XAML code fragment.
01 <Window
01 x:Class="myClass" xmlns=
01 "http://schemas.microsoft.com/winfx/2006/xaml/presentation"
01 xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
01 Title="myWindow" Height="300" Width="300">
02 <StackPanel Background="Black">
03
04 <StackPanel HorizontalAlignment="Center"
04 Orientation="Horizontal">
05 ?<Button Name="btnPlay" Margin="10" Content="Play" />
06 </StackPanel>
07
08 </StackPanel>
09 </Window>
You need to ensure that the application plays only the first 10 seconds of a video that you want to preview.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)
A. Insert the following XAML fragment at line 03.
<MediaElement Name="myMediaElement" Stretch="Fill" />
B. Insert the following XAML fragment at line 03.
<MediaElement Name="myMediaElement"
Source="MediaFileSelected.wmv" Stretch="Fill" />
C. Create the following method in the code-behind file.
public void PlayMedia(object sender, RoutedEventArgs args) {
myMediaElement.Play();
}
D. Insert the following XAML fragment at line 07.
<StackPanel.Triggers>
<EventTrigger RoutedEvent="Button.Click" SourceName="btnPlay">
<EventTrigger.Actions>
<BeginStoryboard Name= "myBegin">
<Storyboard SlipBehavior="Slip">
<MediaTimeline Source="MediaFileSelected.wmv"
Storyboard.TargetName="myMediaElement"
BeginTime="0:0:0" Duration="0:0:10" />
</Storyboard>
</BeginStoryboard>
</EventTrigger.Actions>
</EventTrigger>
</StackPanel.Triggers>
E. Insert the following XAML fragment at line 07.
<StackPanel.Triggers>
<EventTrigger RoutedEvent="Button.Click" SourceName="btnPlay">
<EventTrigger.Actions>
<BeginStoryboard Name= "myBegin">
<Storyboard SlipBehavior="Slip">
<MediaTimeline
Storyboard.TargetName="myMediaElement"
BeginTime="0:0:0" Duration="0:0:10" />
</Storyboard>
</BeginStoryboard>
</EventTrigger.Actions>
</EventTrigger>
</StackPanel.Triggers>
Answer: A AND D

Microsoft   70-502   70-502   certification 70-502
24. You are creating a Windows Presentation Foundation application by using Microsoft .NET Framework
3.5.
You plan to use the application to preview video files.
You write the following XAML code fragment.
01 <Window
01 x:Class="myClass" xmlns=
01 "http://schemas.microsoft.com/winfx/2006/xaml/presentation"
01 xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
01 Title="myWindow" Height="300" Width="300">
02 <StackPanel Background="Black">
03
04 <StackPanel HorizontalAlignment="Center"
04 Orientation="Horizontal">
05 ?<Button Name="btnPlay" Margin="10" Content="Play" />
06 </StackPanel>
07
08 </StackPanel>
09 </Window>
You need to ensure that the application plays only the first 10 seconds of a video that you want to preview.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)
A. Insert the following XAML fragment at line 03.
<MediaElement Name="myMediaElement" Stretch="Fill" />
B. Insert the following XAML fragment at line 03.
<MediaElement Name="myMediaElement"
Source="MediaFileSelected.wmv" Stretch="Fill" />
C. Create the following method in the code-behind file.
Public Sub PlayMedia(ByVal sender As Object, _
ByVal args As RoutedEventArgs)
myMediaElement.Play()
End Sub
D. Insert the following XAML fragment at line 07.
<StackPanel.Triggers>
<EventTrigger RoutedEvent="Button.Click" SourceName="btnPlay">
<EventTrigger.Actions>
<BeginStoryboard Name= "myBegin">
<Storyboard SlipBehavior="Slip">
<MediaTimeline Source="MediaFileSelected.wmv"
Storyboard.TargetName="myMediaElement"
BeginTime="0:0:0" Duration="0:0:10" />
</Storyboard>
</BeginStoryboard>
</EventTrigger.Actions>
</EventTrigger>
</StackPanel.Triggers>
E. Insert the following XAML fragment at line 07.
<StackPanel.Triggers>
<EventTrigger RoutedEvent="Button.Click" SourceName="btnPlay">
<EventTrigger.Actions>
<BeginStoryboard Name= "myBegin">
<Storyboard SlipBehavior="Slip">
<MediaTimeline
Storyboard.TargetName="myMediaElement"
BeginTime="0:0:0" Duration="0:0:10" />
</Storyboard>
</BeginStoryboard>
</EventTrigger.Actions>
</EventTrigger>
</StackPanel.Triggers>
Answer: A AND D

Microsoft   certification 70-502   70-502   70-502
25. You are creating a Windows Presentation Foundation application.
You create a window for the application. The application contains an audio file named
AudioFileToPlay.wav.
You need to ensure that the audio file is played each time you click the client area of the window.
What should you do?
A. Add the following XAML line of code to the window.
<MediaElement Source="AudioFileToPlay.wav" />
B. Add the following code segment to the window constructor method in the code-behind file.
SoundPlayer player = new SoundPlayer();
player.SoundLocation = "AudioFileToPlay.wav";
player.Play();
C. Add the following code segment to the window MouseDown method in the code-behind file.
MediaPlayer player = new MediaPlayer();
player.SetValue(MediaElement.SourceProperty,new Uri("AudioFileToPlay.wav", UriKind.Relative));
player.Play();
D. Add the following XAML code fragment to the window.
<Window.Triggers>
<EventTrigger RoutedEvent="Window.MouseDown">
<EventTrigger.Actions>
<SoundPlayerAction Source="AudioFileToPlay.wav"/>
</EventTrigger.Actions>
</EventTrigger>
</Window.Triggers>
Answer: D

Microsoft   70-502 examen   70-502   certification 70-502   70-502 examen
26. You are creating a Windows Presentation Foundation application.
You create a window for the application. The application contains an audio file named
AudioFileToPlay.wav.
You need to ensure that the following requirements are met:
The audio file is played each time you click the client area of the window.
The window provides optimal performance when the audio file is being played.
What should you do?
A
Add the following XAML line of code to the window.
<MediaElement Source="AudioFileToPlay.wav" />
B. Add the following code segment to the window constructor method in the code-behind file.
Dim player As New SoundPlayer()
player.SoundLocation = "AudioFileToPlay.wav"
player.Play()
C. Add the following code segment to the window MouseDown method in the code-behind file.
Dim player As New MediaElement()
player.Source = New Uri("AudioFileToPlay.wav", UriKind.Relative)
player.LoadedBehavior = MediaState.Manual
player.Play()
D. Add the following XAML code fragment to the window.
<Window.Triggers>
<EventTrigger RoutedEvent="Window.MouseDown">
<EventTrigger.Actions>
<SoundPlayerAction Source="AudioFileToPlay.wav"/>
</EventTrigger.Actions>
</EventTrigger>
</Window.Triggers>
Answer: D

certification Microsoft   70-502   70-502
27. You are creating a Windows Presentation Foundation application by using Microsoft .NET Framework
3.5. Your project contains a folder named Data.
You add an MP3 file named song.mp3 in the Data folder. You set the Build Action property of the MP3 file
to Resource.
You need to access the MP3 file from the application.
Which code segment should you use?
A. Uri uri = new Uri("/Data/song.mp3", UriKind.Relative);
StreamResourceInfo sri=Application.GetContentStream(uri);
Stream stream=sri.Stream;
B. Uri uri = new Uri("/Data/song.mp3", UriKind.Relative);
StreamResourceInfo sri=Application.LoadComponent(uri);
Stream stream=sri.Stream;
C. Uri uri = new Uri("/Data/song.mp3", UriKind.Relative);
StreamResourceInfo sri=Application.GetRemoteStream(uri);
Stream stream=sri.Stream;
D. Uri uri = new Uri("/Data/song.mp3", UriKind.Relative);
StreamResourceInfo sri=Application.GetResourceStream(uri);
Stream stream=sri.Stream;
Answer: D

Microsoft examen   70-502   70-502   70-502
28. You are creating a Windows Presentation Foundation application by using Microsoft .NET Framework
3.5. Your project contains a folder named Data.
You add a .MP3 file named song.mp3 in the Data folder. You set the Build Action property of the
application to Resource.
You need to access the .MP3 file from one of the application classes.
Which code segment should you use?
A. Dim uri As New Uri("/Data/song.mp3", UriKind.Relative)
Dim sri As StreamResourceInfo = Application.GetContentStream(uri)
Dim stream As Stream = sri.Stream
B. Dim uri As New Uri("/Data/song.mp3", UriKind.Relative)
Dim sri As StreamResourceInfo = Application.LoadComponent(uri)
Dim stream As Stream = sri.Stream
C. Dim uri As New Uri("/Data/song.mp3", UriKind.Relative)
Dim sri As StreamResourceInfo = Application.GetRemoteStream(uri)
Dim stream As Stream = sri.Stream
D. Dim uri As New Uri("/Data/song.mp3", UriKind.Relative)
Dim sri As StreamResourceInfo = Application.GetResourceStream(uri)
Dim stream As Stream = sri.Stream
Answer: D

Microsoft   70-502   70-502   70-502 examen   70-502 examen
29. You are creating a Windows Presentation Foundation application by using Microsoft .NET Framework
3.5.
The application has a window that programatically displays an image. The window contains a grid named
theGrid.
The window displays images in their actual size of 1024 pixels wide or larger. You want the images to be
200 pixels wide.
You write the following code segment. (Line numbers are included for reference only.)
01 Image theImage=new Image();
02 theImage.Width=200;
03 BitmapImage theBitmapImage=new BitmapImage();
04
05 theImage.Source=theBitmapImage;
06 theGrid.Children.Add(theImage);
You need to ensure that the application meets the following requirements:
The window uses the least amount of memory to display the image.
The image is not skewed.
Which code segment should you insert at line 04?
A. theBitmapImage.UriSource=new Uri(@"imageToDisplay.jpg");
theBitmapImage.DecodePixelWidth=200;
B. theBitmapImage.BeginInit();
theBitmapImage.UriSource=new Uri(@"imageToDisplay.jpg");
theBitmapImage.EndInit();
C. theBitmapImage.BeginInit();
theBitmapImage.UriSource=new Uri(@"imageToDisplay.jpg");
theBitmapImage.DecodePixelWidth=200;
theBitmapImage.EndInit();
D. theBitmapImage.BeginInit();
theBitmapImage.UriSource=new Uri(@"imageToDisplay.jpg");
theBitmapImage.DecodePixelWidth=200;
theBitmapImage.DecodePixelHeight=200;
theBitmapImage.EndInit();
Answer: C

Microsoft examen   70-502   70-502
30. You are creating a Windows Presentation Foundation application by using Microsoft .NET Framework
3.5.
The application has a window that programatically displays an image. The window contains a grid named
theGrid.
The window displays images in their actual size. You want the images to be 200 pixels wide. You write the
following code segment.
01 Dim theImage As New Image()
02 theImage.Width = 200
03 Dim theBitmapImage As New BitmapImage()
04
05 theImage.Source = theBitmapImage
06 theGrid.Children.Add(theImage)
You need to ensure that the application meets the following requirements:
The window uses the least amount of memory to display the image.
The image is not skewed.
Which code segment should you insert at line 04?
A. theBitmapImage.UriSource = New Uri("imageToDisplay.jpg")
theBitmapImage.DecodePixelWidth = 200
B. theBitmapImage.BeginInit()
theBitmapImage.UriSource = New Uri("imageToDisplay.jpg")
theBitmapImage.EndInit()
C. theBitmapImage.BeginInit()
theBitmapImage.UriSource = New Uri("imageToDisplay.jpg")
theBitmapImage.DecodePixelWidth = 200
theBitmapImage.EndInit()
D. theBitmapImage.BeginInit()
theBitmapImage.UriSource = New Uri("imageToDisplay.jpg")
theBitmapImage.EndInit()
theBitmapImage.DecodePixelWidth = 200
theBitmapImage.DecodePixelHeight = 200
Answer: C

Microsoft   70-502 examen   70-502 examen   70-502   70-502 examen

Pass4Test est un fournisseur important de résume du test Certification IT dans tous les fournissurs. Les experts de Pass4Test travaillent sans arrêt juste pour augmenter la qualité de l'outil formation et vous aider à économiser le temps et l'argent. D'ailleur, le servie en ligne après vendre est toujours disponible pour vous.

2013年7月31日星期三

Dernières Microsoft MB7-840 70-565 70-561 70-503 70-502 de la pratique de l'examen questions et réponses téléchargement gratuit

Le produit de Pass4Test que vous choisissez vous met le pied sur la première marche du pic de l'Industrie IT, et vous serez plus proche de votre rêve. Les matériaux offerts par Pass4Test peut non seulement vous aider à réussir le test Microsoft MB7-840 70-565 70-561 70-503 70-502, mais encore vous aider à se renforcer les connaissances professionnelles. Le service de la mise à jour pendant un an est aussi gratuit pour vous.


Vous aurez une assurance 100% à réussir le test Microsoft MB7-840 70-565 70-561 70-503 70-502 si vous choisissez le produit de Pass4Test. Si malheuresement, vous ne passerez pas le test, votre argent seront tout rendu.


Pass4Test possède un l'outil de formation particulier à propos de test Microsoft MB7-840 70-565 70-561 70-503 70-502. Vous pouvez améliorer les techniques et connaissances professionnelles en coûtant un peu d'argent à courte terme, et vous preuver la professionnalité dans le future proche. L'outil de formation Microsoft MB7-840 70-565 70-561 70-503 70-502 offert par Pass4Test est recherché par les experts de Pass4Test en profitant les expériences et les connaissances riches.


Code d'Examen: MB7-840

Nom d'Examen: Microsoft (NAV 2009 C/SIDE Introduction)

Questions et réponses: 109 Q&As

Code d'Examen: 70-565

Nom d'Examen: Microsoft (Pro: Designing and Developing Enterprise Applications Using the Microsoft .NET Framework 3.5)

Questions et réponses: 138 Q&As

Code d'Examen: 70-561

Nom d'Examen: Microsoft (TS: MS .NET Framework 3.5, ADO.NET Application Development)

Questions et réponses: 170 Q&As

Code d'Examen: 70-503

Nom d'Examen: Microsoft (TS: Microsoft .NET Framework 3.5 C Windows Communication Foundation)

Questions et réponses: 158 Q&As

Code d'Examen: 70-502

Nom d'Examen: Microsoft (TS: Microsoft .NET Framework 3.5 – Windows Presentation Foundation)

Questions et réponses: 128 Q&As

Les produits de Pass4Test a une bonne qualité, et la fréquence de la mise à jour est bien impressionnée. Si vous avez déjà choisi la Q&A de Pass4Test, vous n'aurez pas le problème à réussir le test Microsoft MB7-840 70-565 70-561 70-503 70-502.


70-561 Démo gratuit à télécharger: http://www.pass4test.fr/70-561.html


NO.1 You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET. The
application connects to a Microsoft SQL Server 2005 database.
You need to separate the security-related exceptions from the other exceptions for database operations at
run time.
Which code segment should you use?
A. catch (System.Security.SecurityException ex)
{
//Handle all database security related exceptions.
}
B. catch (System.Data.SqlClient.SqlException ex)
{
for (int i = 0; i < ex.Errors.Count; i++){
if (ex.Errors[i].Class.ToString() == "14") {
//Handle all database security related exceptions.
}
else{
//Handle other exceptions
}
}
}
C. catch (System.Data.SqlClient.SqlException ex)
{
for (int i = 0; i < ex.Errors.Count; i++){
if (ex.Errors[i].Number == 14){
//Handle all database security related exceptions.
}
else{
//Handle other exceptions
}
}
}
D. catch (System.Data.SqlClient.SqlException ex)
{
for (int i = 0; i < ex.Errors.Count; i++){
if (ex.Errors[i].Message.Contains("Security")){
//Handle all database security related exceptions.
}
else{
//Handle other exceptions
}
}
}
Answer: B

Microsoft   70-561   certification 70-561

NO.2 You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET. The
application connects to a Microsoft SQL Server 2005 database.
The application analyzes large amounts of transaction data that are stored in a different database.
You write the following code segment. (Line numbers are included for reference only.)
01 using (SqlConnection connection = new
SqlConnection(sourceConnectionString))
02 using (SqlConnection connection2 = new
SqlConnection(destinationConnectionString))
03 using (SqlCommand command = new SqlCommand())
04 {
05 connection.Open();
06 connection2.Open();
07 using (SqlDataReader reader = command.ExecuteReader())
08 {
09 using (SqlBulkCopy bulkCopy = new
SqlBulkCopy(connection2))
10 {
11
12 }
13 }
14 }
You need to copy the transaction data to the database of the application.
Which code segment should you insert at line 11?
A. reader.Read()
bulkCopy.WriteToServer(reader);
B. bulkCopy.DestinationTableName = "Transactions";
bulkCopy.WriteToServer(reader);
C. bulkCopy.DestinationTableName = "Transactions";
bulkCopy.SqlRowsCopied += new
SqlRowsCopiedEventHandler(bulkCopy_SqlRowsCopied);
D. while (reader.Read())
{
bulkCopy.WriteToServer(reader);
}
Answer: B

Microsoft examen   70-561   70-561 examen   70-561

NO.3 You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET.
The application contains a TextBox control named txtProductID. The application will return a list of active
products that have the ProductID field equal to the txtProductID.Text property.
You write the following code segment. (Line numbers are included for reference only.)
01 private DataSet GetProducts(SqlConnection cn) {
02 SqlCommand cmd = new SqlCommand();
03 cmd.Connection = cn;
04 SqlDataAdapter da = new SqlDataAdapter(cmd);
05 DataSet ds = new DataSet();
06
07 da.Fill(ds);
08 return ds;
09 }
You need to populate the DataSet object with product records while avoiding possible SQL injection
attacks.
Which code segment should you insert at line 06?
A. cmd.CommandText = string.Format("sp_sqlexec 'SELECT ProductID,
Name FROM Product WHERE ProductID={0} AND IsActive=1'", txtProductID.Text);
B. cmd.CommandText = string.Format("SELECT ProductID, Name FROM
Product WHERE ProductID={0} AND IsActive=1", txtProductID.Text);
cmd.Prepare();
C. cmd.CommandText = string.Format("SELECT ProductID, Name FROM
Product WHERE ProductID={0} AND IsActive=1", txtProductID.Text);
cmd.CommandType = CommandType.TableDirect;
D. cmd.CommandText = "SELECT ProductID, Name FROM Product WHERE
ProductID=@productID AND IsActive=1";
cmd.Parameters.AddWithValue("@productID", txtProductID.Text);
Answer: D

Microsoft   70-561   70-561   70-561   70-561

NO.4 You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET. The
application uses Microsoft SQL Server 2005.
You write the following code segment. (Line numbers are included for reference only.)
01 String myConnString = "User
02 ID=<username>;password=<strong password>;Initial
03 Catalog=pubs;Data Source=myServer";
04 SqlConnection myConnection = new
05 SqlConnection(myConnString);
06 SqlCommand myCommand = new SqlCommand();
07 DbDataReader myReader;
08 myCommand.CommandType =
09 CommandType.Text;
10 myCommand.Connection = myConnection;
11 myCommand.CommandText = "Select * from Table1;
Select * from Table2;";
12 int RecordCount = 0;
13 try
14 {
15 myConnection.Open();
16
17 }
18 catch (Exception ex)
19 {
20 }
21 finally

NO.5 You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET. The
application connects to a Microsoft SQL Server 2005 database.
The connection string of the application is defined in the following manner.
"Server=Prod;Database=WingtipToys;Integrated
Security=SSPI;Asynchronous Processing=true"
The application contains the following code segment. (Line numbers are included for reference only.)
01 protected void UpdateData(SqlCommand cmd) {
02 cmd.Connection.Open();
03
04 lblResult.Text = "Updating ...";
05 }
The cmd object takes a long time to execute.
You need to ensure that the application continues to execute while cmd is executing.
What should you do?
A. Insert the following code segment at line 03.
cmd.BeginExecuteNonQuery(new AsyncCallback(UpdateComplete), cmd);
Add the following code segment.
private void UpdateComplete (IAsyncResult ar) {
int count = (int)ar.AsyncState;
LogResults(count);
}
B. Insert the following code segment at line 03.
cmd.BeginExecuteNonQuery(new AsyncCallback(UpdateComplete), cmd);
Add the following code segment.
private void UpdateComplete (IAsyncResult ar) {
SqlCommand cmd = (SqlCommand)ar.AsyncState;
int count = cmd.EndExecuteNonQuery(ar);
LogResults(count);
}
C. Insert the following code segment at line 03.
cmd.StatementCompleted += new
StatementCompletedEventHandler(UpdateComplete);
cmd.ExecuteNonQuery();
Add the following code segment.
private void UpdateComplete (object sender, StatementCompletedEventArgs e) {
int count = e.RecordCount;
LogResults(count);
}
D. Insert the following code segment at line 03.
SqlNotificationRequest notification = new
SqlNotificationRequest("UpdateComplete", "", 10000);
cmd.Notification = notification;
cmd.ExecuteNonQuery();
Add the following code segment.
private void UpdateComplete(SqlNotificationRequest notice) {
int count = int.Parse(notice.UserData);
LogResults(count);
}
Answer: B

certification Microsoft   70-561 examen   certification 70-561   70-561   certification 70-561

NO.6 You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET. The
application connects to a Microsoft SQL Server 2005 database.
The application throws an exception when the SQL Connection object is used.
You need to handle the exception.
Which code segment should you use?
A. Try
If conn IsNot Nothing Then
conn.Close()
' code for the query
End If
Catch ex As Exception
' handle exception
Finally
If conn Is Nothing Then
conn.Open()
End If
End Try
B. Try
' code for the query
conn.Close()
Catch ex As Exception
' handle exception
Finally
If conn IsNot Nothing Then
conn.Open()
End If
End Try
C. Try
' code for the query
conn.Open()
Catch ex As Exception
' handle exception
Finally
If conn IsNot Nothing Then
conn.Close()
End If
End Try
D. Try
' code for the query
conn.Open()
Catch ex As Exception
' handle exception
Finally
If conn Is Nothing Then
conn.Close()
End If
End Try
Answer: C

Microsoft examen   70-561   70-561   70-561 examen

NO.7 You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET.
The application contains a DataSet object named orderDS. The object contains a table named Order as
shown in the following exhibit.
The application uses a SqlDataAdapter object named daOrder to populate the Order table.
You write the following code segment. (Line numbers are included for reference only.)
01 private void FillOrderTable(int pageIndex) {
02 int pageSize = 5;
03
04 }
You need to fill the Order table with the next set of 5 records for each increase in the pageIndex value.
Which code segment should you insert at line 03?
A. string sql = "SELECT SalesOrderID, CustomerID, OrderDate FROM Sales.SalesOrderHeader";
daOrder.SelectCommand.CommandText = sql;
daOrder.Fill(orderDS, pageIndex, pageSize, "Order");
B. int startRecord = (pageIndex - 1) * pageSize;
string sql = "SELECT SalesOrderID, CustomerID, OrderDate FROM Sales.SalesOrderHeader";
daOrder.SelectCommand.CommandText = sql;
daOrder.Fill(orderDS, startRecord, pageSize, "Order");
C. string sql = string.Format("SELECT TOP {0} SalesOrderID, CustomerID,
OrderDate FROM Sales.SalesOrderHeader WHERE SalesOrderID > {1}", pageSize, pageIndex);
daOrder.SelectCommand.CommandText = sql;
daOrder.Fill(orderDS, "Order");
D. int startRecord = (pageIndex - 1) * pageSize;
string sql = string.Format("SELECT TOP {0} SalesOrderID, CustomerID,
OrderDate FROM Sales.SalesOrderHeader WHERE SalesOrderID > {1}",
pageSize, startRecord);
daOrder.SelectCommand.CommandText = sql;
daOrder.Fill(orderDS, "Order");
Answer: B

certification Microsoft   70-561 examen   70-561

NO.8 You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET. The
application connects to a Microsoft SQL Server 2005 database.
You write the following code segment. (Line numbers are included for reference only.)
01 Using connection As New SqlConnection(connectionString)
02 Dim cmd As New SqlCommand(queryString, connection)
03 connection.Open()
04
05 While sdrdr.Read()
06 ' use the data in the reader
07 End While
08 End Using
You need to ensure that the memory is used efficiently when retrieving BLOBs from the database.
Which code segment should you insert at line 04?
A. Dim sdrdr As SqlDataReader = _ cmd.ExecuteReader()
B. Dim sdrdr As SqlDataReader = _ cmd.ExecuteReader(CommandBehavior.[Default])
C. Dim sdrdr As SqlDataReader = _ cmd.ExecuteReader(CommandBehavior.SchemaOnly)
D. Dim sdrdr As SqlDataReader = _ cmd.ExecuteReader(CommandBehavior.SequentialAccess)
Answer: D

Microsoft examen   70-561   70-561   70-561

NO.9 You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET.
The application contains a SqlDataAdapter object named daOrder. The SelectCommand property of the
daOrder object is set.
You write the following code segment. (Line numbers are included for reference only.)
01 private void ModifyDataAdapter() {
02
03 }
You need to ensure that the daOrder object can also handle updates.
Which code segment should you insert at line 02?
A. SqlCommandBuilder cb = new SqlCommandBuilder(daOrder);
cb.RefreshSchema();
B. SqlCommandBuilder cb = new SqlCommandBuilder(daOrder);
cb.SetAllValues = true;
C. SqlCommandBuilder cb = new SqlCommandBuilder(daOrder);
daOrder.DeleteCommand = cb.GetDeleteCommand();
daOrder.InsertCommand = cb.GetInsertCommand();
daOrder.UpdateCommand = cb.GetUpdateCommand();
D. SqlCommandBuilder cb = new SqlCommandBuilder(daOrder);
cb.RefreshSchema();
cb.GetDeleteCommand();
cb.GetInsertCommand();
cb.GetUpdateCommand();
Answer: C

Microsoft   70-561   70-561   70-561 examen   70-561 examen

NO.10 You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET.
The application contains a DataSet object named orderDS. The object contains a table named Order as
shown in the following exhibit.
The application uses a SqlDataAdapter object named daOrder to populate the Order table.
You write the following code segment. (Line numbers are included for reference only.)
01 Private Sub FillOrderTable(ByVal pageIndex As Integer)
02 Dim pageSize As Integer = 5
03
04 End Sub
You need to fill the Order table with the next set of 5 records for each increase in the pageIndex value.
Which code segment should you insert at line 03?
A. Dim sql As String = "SELECT SalesOrderID, CustomerID, " + _
"OrderDate FROM Sales.SalesOrderHeader"
daOrder.SelectCommand.CommandText = sql
daOrder.Fill(orderDS, pageIndex, pageSize, "Order")
B. Dim startRecord As Integer = (pageIndex - 1) * pageSize
Dim sql As String = "SELECT SalesOrderID, CustomerID, " + _
"OrderDate FROM Sales.SalesOrderHeader"
daOrder.SelectCommand.CommandText = sql
daOrder.Fill(orderDS, startRecord, pageSize, "Order")
C. Dim sql As String = _
String.Format("SELECT TOP {0} SalesOrderID, " + _
"CustomerID, OrderDate FROM Sales.SalesOrderHeader " + _
"WHERE SalesOrderID > {1}", pageSize, pageIndex)
daOrder.SelectCommand.CommandText = sql
daOrder.Fill(orderDS, "Order")
D. Dim startRecord As Integer = (pageIndex - 1) * pageSize
Dim sql As String = _
String.Format("SELECT TOP {0} SalesOrderID, " + _
"CustomerID, OrderDate FROM Sales.SalesOrderHeader " + _
"WHERE SalesOrderID > {1}", pageSize, startRecord)
daOrder.SelectCommand.CommandText = sql
daOrder.Fill(orderDS, "Order")
Answer: B

Microsoft examen   70-561 examen   70-561   certification 70-561

NO.11 You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET. The
application connects to a Microsoft SQL Server 2005 database.
You need to separate the security-related exceptions from the other exceptions for database operations at
run time.
Which code segment should you use?
A. Catch ex As System.Security.SecurityException
'Handle all database security related exceptions.
End Try
B. Catch ex As System.Data.SqlClient.SqlException
For i As Integer = 0 To ex.Errors.Count - 1
If ex.Errors(i).[Class].ToString() = "14" Then
'Handle all database security related exceptions.
Else
'Handle other exceptions
End If
Next
End Try
C. Catch ex As System.Data.SqlClient.SqlException
For i As Integer = 0 To ex.Errors.Count - 1
If ex.Errors(i).Number = 14 Then
'Handle all database security related exceptions.
Else
'Handle other exceptions
End If
Next
End Try
D. Catch ex As System.Data.SqlClient.SqlException
For i As Integer = 0 To ex.Errors.Count - 1
If ex.Errors(i).Message.Contains("Security") Then
'Handle all database security related exceptions.
Else
'Handle other exceptions
End If
Next
End Try
Answer: B

Microsoft   70-561   70-561 examen   70-561   70-561

NO.12 {

NO.13 You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET. The
application connects to a Microsoft SQL Server 2005 database.
You write the following code segment.
string query = "Select EmpNo, EmpName from dbo.Table_1;
select Name,Age from dbo.Table_2";
SqlCommand command = new SqlCommand(query, connection);
SqlDataReader reader = command.ExecuteReader();
You need to ensure that the application reads all the rows returned by the code segment.
Which code segment should you use?
A. while (reader.NextResult())
{
Console.WriteLine(String.Format("{0}, {1}",reader[0], reader[1]));
reader.Read();
}
B. while (reader.Read())
{
Console.WriteLine(String.Format("{0}, {1}",reader[0], reader[1]));
reader.NextResult();
}
C. while (reader.Read())
{
Console.WriteLine(String.Format("{0}, {1}",reader[0], reader[1]));
}
reader.NextResult();
while (reader.Read())
{
Console.WriteLine(String.Format("{0}, {1}",reader[0], reader[1]));
}
D. while (reader.NextResult())
{
Console.WriteLine(String.Format("{0}, {1}",reader[0], reader[1]));
}
reader.Read();
while (reader.NextResult())
{
Console.WriteLine(String.Format("{0}, {1}",reader[0], reader[1]));
}
Answer: C

certification Microsoft   70-561   70-561   70-561   70-561

NO.14 You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET. The
application connects to a Microsoft SQL Server 2005 database.
You write the following code segment. (Line numbers are included for reference only.)
01 using (SqlConnection connection = new
SqlConnection(connectionString)) {
02 SqlCommand cmd = new SqlCommand(queryString, connection);
03 connection.Open();
04
05 while (sdrdr.Read()){
06 // use the data in the reader
07 }
08 }
You need to ensure that the memory is used efficiently when retrieving BLOBs from the database.
Which code segment should you insert at line 04?
A. SqlDataReader sdrdr = cmd.ExecuteReader();
B. SqlDataReader sdrdr = cmd.ExecuteReader(CommandBehavior.Default);
C. SqlDataReader sdrdr = cmd.ExecuteReader(CommandBehavior.SchemaOnly);
D. SqlDataReader sdrdr = cmd.ExecuteReader(CommandBehavior.SequentialAccess);
Answer: D

Microsoft   70-561   70-561 examen   certification 70-561   70-561

NO.15 You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET.
The application contains a DataSet object named OrderDS that has the Order and OrderDetail tables as
shown in the following exhibit.
You write the following code segment. (Line numbers are included for reference only.)
01 Private Sub GetOrders(ByVal cn As SqlConnection)
02 Dim cmd As SqlCommand = cn.CreateCommand()
03 cmd.CommandText = "Select * from [Order]; " + _
"Select * from [OrderDetail];"
04 Dim da As New SqlDataAdapter(cmd)
05
06 End Sub
You need to ensure that the Order and the OrderDetail tables are populated.
Which code segment should you insert at line 05?
A. da.Fill(OrderDS)
B. da.Fill(OrderDS.Order)
da.Fill(OrderDS.OrderDetail)
C. da.TableMappings.AddRange(New DataTableMapping() _
{New DataTableMapping("Table", "Order"), _
New DataTableMapping("Table1", "OrderDetail")})
da.Fill(OrderDS)
D. Dim mapOrder As New DataTableMapping()
mapOrder.DataSetTable = "Order"
Dim mapOrderDetail As New DataTableMapping()
mapOrder.DataSetTable = "OrderDetail"
da.TableMappings.AddRange(New DataTableMapping() _
{mapOrder, mapOrderDetail})
da.Fill(OrderDS)
Answer: C

Microsoft examen   70-561 examen   70-561   70-561

NO.16 You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET. The
application connects to a Microsoft SQL Server 2005 database.
You write the following code segment.
Dim query As String = _ "Select EmpNo, EmpName from dbo.Table_1; " + _ "select Name,Age from
dbo.Table_2"
Dim command As New SqlCommand(query, connection)
Dim reader As SqlDataReader = command.ExecuteReader()
You need to ensure that the application reads all the rows returned by the code segment.
Which code segment should you use?
A. While reader.NextResult()
Console.WriteLine([String].Format("{0}, {1}", reader(0), reader(1)))
reader.Read()
End While
B. While reader.Read()
Console.WriteLine([String].Format("{0}, {1}", reader(0), reader(1)))
reader.NextResult()
End While
C. While reader.Read()
Console.WriteLine([String].Format("{0}, {1}", reader(0), reader(1)))
End While
reader.NextResult()
while reader.Read()
Console.WriteLine([String].Format("{0}, {1}", reader(0), reader(1)))
End While
D. While reader.NextResult()
Console.WriteLine([String].Format("{0}, {1}", reader(0), reader(1)))
End While
reader.Read()
while reader.NextResult()
Console.WriteLine([String].Format("{0}, {1}", reader(0), reader(1)))
End While
Answer: C

certification Microsoft   70-561 examen   70-561   70-561   70-561

NO.17 You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET. The
application connects to a Microsoft SQL Server 2005 database.
The connection string of the application is defined in the following manner.
"Server=Prod;Database=WingtipToys;Integrated
Security=SSPI;Asynchronous Processing=true"
The application contains the following code segment. (Line numbers are included for reference only.)
01 Protected Sub UpdateData(ByVal cmd As SqlCommand)
02 cmd.Connection.Open()
03
04 lblResult.Text = "Updating ..."
05 End Sub
The cmd object takes a long time to execute.
You need to ensure that the application continues to execute while cmd is executing.
What should you do?
A. Insert the following code segment at line 03.
cmd.BeginExecuteNonQuery(New AsyncCallback( _
AddressOf UpdateComplete), cmd)
Add the following code segment.
Private Sub UpdateComplete (ByVal ar As IAsyncResult)
Dim count As Integer = CInt(ar.AsyncState)
LogResults(count)
End Sub
B. Insert the following code segment at line 03.
cmd.BeginExecuteNonQuery(New AsyncCallback( _
AddressOf UpdateComplete), cmd)
Add the following code segment.
Private Sub UpdateComplete(ByVal ar As IAsyncResult)
Dim cmd As SqlCommand = DirectCast(ar.AsyncState, SqlCommand)
Dim count As Integer = cmd.EndExecuteNonQuery(ar)
LogResults(count)
End Sub
C. Insert the following code segment at line 03.
AddHandler cmd.StatementCompleted, AddressOf UpdateComplete
cmd.ExecuteNonQuery()
Add the following code segment.
Private Sub UpdateComplete(ByVal sender As Object, _
ByVal e As StatementCompletedEventArgs)
Dim count As Integer = e.RecordCount
LogResults(count)
End Sub
D. Insert the following code segment at line 03.
Dim notification As New _
SqlNotificationRequest("UpdateComplete ", "", 10000)
cmd.Notification = notification
cmd.ExecuteNonQuery()
Add the following code segment.
Private Sub UpdateComplete (ByVal notice As SqlNotificationRequest)
Dim count As Integer = Integer.Parse(notice.UserData)
LogResults(count)
End Sub
Answer: B

Microsoft   70-561   70-561   70-561   70-561 examen   certification 70-561

NO.18 You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET. The
application connects to a Microsoft SQL Server 2005 database.
You write the following code segment.
Dim queryString As String = "Select Name, Age from dbo.Table_1"
Dim command As New _SqlCommand(queryString, DirectCast(connection, SqlConnection))
You need to get the value that is contained in the first column of the first row of the result set returned by
the query.
Which code segment should you use?
A. Dim value As Object = command.ExecuteScalar()
Dim requiredValue As String = value.ToString()
B. Dim value As Integer = command.ExecuteNonQuery()
Dim requiredValue As String = value.ToString()
C. Dim value As SqlDataReader = _command.ExecuteReader(CommandBehavior.SingleRow)
Dim requiredValue As String = value(0).ToString()
D. Dim value As SqlDataReader = _command.ExecuteReader(CommandBehavior.SingleRow)
Dim requiredValue As String = value(1).ToString()
Answer: A

Microsoft examen   70-561   certification 70-561   70-561 examen   70-561 examen   70-561

NO.19 You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET. The
application connects to a Microsoft SQL Server 2005 database.
The application analyzes large amounts of transaction data that are stored in a different database.
You write the following code segment. (Line numbers are included for reference only.)
01 Using connection As New SqlConnection(sourceConnectionString)
02 Using connection2 As _
New SqlConnection(destinationConnectionString)
03 Using command As New SqlCommand()
04 connection.Open()
05 connection2.Open()
06 Using reader As SqlDataReader = command.ExecuteReader()
07 Using bulkCopy As New SqlBulkCopy(connection2)
08
09 End Using
10 End Using
11 End Using
12 End Using
13 End Using
You need to copy the transaction data to the database of the application.
Which code segment should you insert at line 08?
A. reader.Read()
bulkCopy.WriteToServer(reader)
B. bulkCopy.DestinationTableName = "Transactions"
bulkCopy.WriteToServer(reader)
C. bulkCopy.DestinationTableName = "Transactions"
AddHandler bulkCopy.SqlRowsCopied, _
AddressOf bulkCopy_SqlRowsCopied
D. While reader.Read()
bulkCopy.WriteToServer(reader)
End While
Answer: B

Microsoft   70-561   70-561   70-561   70-561 examen

NO.20 myConnection.Close();

NO.21 You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET.
The application has a DataTable object named OrderDetailTable. The object has the following columns:
ID
OrderID
ProductID
Quantity
LineTotal
The OrderDetailTable object is populated with data provided by a business partner. Some of the records
contain a null value in the LineTotal field and 0 in the Quantity field.
You write the following code segment. (Line numbers are included for reference only.)
01 Dim col As New DataColumn("UnitPrice", GetType(Decimal))
02
03 OrderDetailTable.Columns.Add(col)
You need to add a DataColumn named UnitPrice to the OrderDetailTable object.
Which line of code should you insert at line 02?
A. col.Expression = "LineTotal/Quantity"
B. col.Expression = "LineTotal/ISNULL(Quantity, 1)"
C. col.Expression = "LineTotal.Value/ISNULL(Quantity.Value, 1)"
D. col.Expression = "iif(Quantity > 0, LineTotal/Quantity, 0)"
Answer: D

Microsoft examen   70-561 examen   70-561   70-561   certification 70-561

NO.22 You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET.
You need to ensure that the application can connect to any type of database.
What should you do?
A. Set the database driver name in the connection string of the application, and then create the
connection object in the following manner.
Dim connection As DbConnection = _ New OdbcConnection(connectionString)
B. Set the database provider name in the connection string of the application, and then create the
connection object in the following manner.
Dim connection As DbConnection = _ New OleDbConnection(connectionString)
C. Create the connection object in the following manner.
Dim factory As DbProviderFactory = _ DbProviderFactories.GetFactory("System.Data.Odbc")
Dim connection As DbConnection = _ factory.CreateConnection()
D. Create the connection object in the following manner.
Dim factory As DbProviderFactory = _ DbProviderFactories.GetFactory(databaseProviderName)
Dim connection As DbConnection = factory.CreateConnection()
Answer: D

certification Microsoft   70-561 examen   certification 70-561   70-561 examen   70-561

NO.23 }
You need to compute the total number of records processed by the Select queries in the RecordCount
variable.
Which code segment should you insert at line 16?
A. myReader = myCommand.ExecuteReader();
RecordCount = myReader.RecordsAffected;
B. while (myReader.Read())
{
//Write logic to process data for the first result.
}
RecordCount = myReader.RecordsAffected;
C. while (myReader.HasRows)
{
while (myReader.Read())
{
//Write logic to process data for the second result.
RecordCount = RecordCount + 1;
myReader.NextResult();
}
}
D. while (myReader.HasRows)
{
while (myReader.Read())
{
//Write logic to process data for the second result.
RecordCount = RecordCount + 1;
}
myReader.NextResult();
}
Answer: D

certification Microsoft   70-561   70-561   70-561 examen   certification 70-561
22. You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET. The
application uses Microsoft SQL Server 2005.
You write the following code segment. (Line numbers are included for reference only.)
01 Dim myConnString As String = _
02 "User ID=<username>;password=<strong password>;" + _
03 "Initial Catalog=pubs;Data Source=myServer"
04 Dim myConnection As New SqlConnection(myConnString)
05 Dim myCommand As New SqlCommand()
06 Dim myReader As DbDataReader
07 myCommand.CommandType = CommandType.Text
08 myCommand.Connection = myConnection
09 myCommand.CommandText = _
10 "Select * from Table1;Select * from Table2;"
11 Dim RecordCount As Integer = 0
12 Try
13 myConnection.Open()
14
15 Catch ex As Exception
16 Finally
17 myConnection.Close()
18 End Try
You need to compute the total number of records processed by the Select queries in the RecordCount
variable.
Which code segment should you insert at line 14?
A. myReader = myCommand.ExecuteReader()
RecordCount = myReader.RecordsAffected
B. While myReader.Read()
'Write logic to process data for the first result.
End While
RecordCount = myReader.RecordsAffected
C. While myReader.HasRows
While myReader.Read()
'Write logic to process data for the second result.
RecordCount = RecordCount + 1
myReader.NextResult()
End While
End While
D. While myReader.HasRows
While myReader.Read()
'Write logic to process data for the second result.
RecordCount = RecordCount + 1
End While
myReader.NextResult()
End While
Answer: D

Microsoft   70-561   70-561   70-561   70-561 examen   certification 70-561
23. You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET.
The application uses data from a Microsoft SQL Server 2005 database table. A Web page of the
application contains a GridView server control.
You write the following code segment. (Line numbers are included for reference only.)
01 private void LoadGrid()
02 {
03 using (SqlCommand command = new SqlCommand())
04 {
05 command.Connection = connection;
06 command.CommandText = "SELECT * FROM Customers";
07 connection.Open();
08
09 }
10 }
You need to retrieve the data from the database table and bind the data to the DataSource property of the
GridView server control.
Which code segment should you insert at line 08?
A. SqlDataReader rdr = command.ExecuteReader();
connection.Close();
GridView1.DataSource = rdr;
GridView1.DataBind();
B. SqlDataReader rdr = command.ExecuteReader();
GridView1.DataSource = rdr.Read();
GridView1.DataBind();
connection.Close();
C. SqlDataReader rdr = command.ExecuteReader();
Object[] values = new Object[rdr.FieldCount];
GridView1.DataSource = rdr.GetValues(values);
GridView1.DataBind();
connection.Close();
D. DataTable dt = new DataTable();
using (SqlDataReader reader = command.ExecuteReader())
{
dt.Load(reader);
}
connection.Close();
GridView1.DataSource = dt;
GridView1.DataBind();
Answer: D

Microsoft examen   70-561 examen   70-561   70-561 examen
24. You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET.
The application uses data from a Microsoft SQL Server 2005 database table. A Web page of the
application contains a GridView server control.
You write the following code segment. (Line numbers are included for reference only.)
01 Private Sub LoadGrid()
02 Using command As New SqlCommand()
03 command.Connection = connection
04 command.CommandText = "SELECT * FROM Customers"
05 connection.Open()
06
07 End Using
08 End Sub
You need to retrieve the data from the database table and bind the data to the DataSource property of the
GridView server control.
Which code segment should you insert at line 06?
A. Dim rdr As SqlDataReader = command.ExecuteReader()
connection.Close()
GridView1.DataSource = rdr
GridView1.DataBind()
B. Dim rdr As SqlDataReader = command.ExecuteReader()
GridView1.DataSource = rdr.Read()
GridView1.DataBind()
connection.Close()
C. Dim rdr As SqlDataReader = command.ExecuteReader()
Dim values As Object() = New Object(rdr.FieldCount - 1) {}
GridView1.DataSource = rdr.GetValues(values)
GridView1.DataBind()
D. Dim dt As New DataTable()
Using reader As SqlDataReader = command.ExecuteReader()
dt.Load(reader)
End Using
connection.Close()
GridView1.DataSource = dt
GridView1.DataBind()
Answer: D

Microsoft   70-561   70-561 examen   70-561

NO.24 You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET.
The application contains a SqlDataAdapter object named daOrder. The SelectCommand property of the
daOrder object is set.
You write the following code segment. (Line numbers are included for reference only.)
01 Private Sub ModifyDataAdapter()
02
03 End Sub
You need to ensure that the daOrder object can also handle updates.
Which code segment should you insert at line 02?
A. Dim cb As New SqlCommandBuilder(daOrder)
cb.RefreshSchema()
B. Dim cb As New SqlCommandBuilder(daOrder)
cb.SetAllValues = True
C. Dim cb As New SqlCommandBuilder(daOrder)
daOrder.DeleteCommand = cb.GetDeleteCommand()
daOrder.InsertCommand = cb.GetInsertCommand()
daOrder.UpdateCommand = cb.GetUpdateCommand()
D. Dim cb As New SqlCommandBuilder(daOrder)
cb.RefreshSchema()
cb.GetDeleteCommand()
cb.GetInsertCommand()
cb.GetUpdateCommand()
Answer: C

certification Microsoft   70-561 examen   70-561 examen   70-561   certification 70-561

NO.25 You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET.
The application contains a DataSet object named OrderDS that has the Order and OrderDetail tables as
shown in the following exhibit.
You write the following code segment. (Line numbers are included for reference only.)
01 private void GetOrders(SqlDataConnection cn) {
02 SqlCommand cmd = cn.CreateCommand();
03 cmd.CommandText = "Select * from [Order];
Select * from [OrderDetail];";
04 SqlDataAdapter da = new SqlDataAdapter(cmd);
05
06 }
You need to ensure that the Order and the OrderDetail tables are populated.
Which code segment should you insert at line 05?
A. da.Fill(OrderDS);
B. da.Fill(OrderDS.Order);
da.Fill(OrderDS.OrderDetail);
C. da.TableMappings.AddRange(new DataTableMapping[] {
new DataTableMapping("Table", "Order"),
new DataTableMapping("Table1", "OrderDetail")});
da.Fill(OrderDS);
D. DataTableMapping mapOrder = new DataTableMapping();
mapOrder.DataSetTable = "Order";
DataTableMapping mapOrderDetail = new DataTableMapping();
mapOrder.DataSetTable = "OrderDetail";
da.TableMappings.AddRange(new DataTableMapping[]
{ mapOrder, mapOrderDetail });
Da.Fill(OrderDS);
Answer: C

Microsoft   certification 70-561   certification 70-561   70-561   70-561

NO.26 You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET.
The application contains a TextBox control named txtProductID. The application will return a list of active
products that have the ProductID field equal to the txtProductID.Text property.
You write the following code segment. (Line numbers are included for reference only.)
01 Private Function GetProducts(ByVal cn _
As SqlConnection) As DataSet
02 Dim cmd As New SqlCommand()
03 cmd.Connection = cn
04 Dim da As New SqlDataAdapter(cmd)
05 Dim ds As New DataSet()
06
07 da.Fill(ds)
08 Return ds
09 End Function
You need to populate the DataSet object with product records while avoiding possible SQL injection
attacks.
Which code segment should you insert at line 06?
A. cmd.CommandText = _
String.Format("sp_sqlexec 'SELECT ProductID, " + _
"Name FROM Product WHERE ProductID={0} AND IsActive=1'", _
txtProductID.Text)
B. cmd.CommandText = _
String.Format("SELECT ProductID, " + _
"Name FROM Product WHERE ProductID={0} AND IsActive=1", _
txtProductID.Text)
cmd.Prepare()
C. cmd.CommandText = _
String.Format("SELECT ProductID, " + _
"Name FROM Product WHERE ProductID={0} AND IsActive=1", _
txtProductID.Text)
cmd.CommandType = CommandType.TableDirect
D. cmd.CommandText = "SELECT ProductID, " + _
"Name FROM Product WHERE ProductID=@productID AND IsActive=1"
cmd.Parameters.AddWithValue("@productID", txtProductID.Text)
Answer: D

Microsoft examen   70-561   certification 70-561

NO.27 You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET.
The application has a DataTable object named OrderDetailTable. The object has the following columns:
ID
OrderID
ProductID
Quantity
LineTotal
The OrderDetailTable object is populated with data provided by a business partner. Some of the records
contain a null value in the LineTotal field and 0 in the Quantity field.
You write the following code segment. (Line numbers are included for reference only.)
01 DataColumn col = new DataColumn("UnitPrice", typeof(decimal));
02
03 OrderDetailTable.Columns.Add(col);
You need to add a DataColumn named UnitPrice to the OrderDetailTable object.
Which line of code should you insert at line 02?
A. col.Expression = "LineTotal/Quantity";
B. col.Expression = "LineTotal/ISNULL(Quantity, 1)";
C. col.Expression = "LineTotal.Value/ISNULL(Quantity.Value,1)";
D. col.Expression = "iif(Quantity > 0, LineTotal/Quantity, 0)";
Answer: D

Microsoft   70-561 examen   70-561   70-561 examen   70-561

NO.28 You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET. The
application connects to a Microsoft SQL Server 2005 database.
The application throws an exception when the SQL Connection object is used.
You need to handle the exception.
Which code segment should you use?
A. try
{
if(null!=conn)
conn.Close();
// code for the query
}
catch (Exception ex)
{
// handle exception
}
finally
{
if(null==conn)
conn.Open();
}
B. try
{
conn.Close();
// code for the query
}
catch (Exception ex)
{
// handle exception
}
finally
{
if(null!=conn)
conn.Open();
}
C. try
{
conn.Open();
// code for the query
}
catch (Exception ex)
{
// handle exception
}
finally
{
if(null!=conn)
conn.Close();
}
D. try
{
conn.Open();
// code for the query
}
catch (Exception ex)
{
// handle exception
}
finally
{
if(null==conn)
conn.Close();
}
Answer: C

Microsoft   70-561 examen   70-561 examen

NO.29 You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET.
You need to ensure that the application can connect to any type of database.
What should you do?
A. Set the database driver name in the connection string of the application, and then create the
connection object in the following manner.
DbConnection connection = new OdbcConnection(connectionString);
B. Set the database provider name in the connection string of the application, and then create the
connection object in the following manner.
DbConnection connection = new OleDbConnection(connectionString);
C. Create the connection object in the following manner.
DbProviderFactory factory = DbProviderFactories.GetFactory("System.Data.Odbc");
DbConnection connection = factory.CreateConnection();
D. Create the connection object in the following manner.
DbProviderFactory factory = DbProviderFactories.GetFactory(databaseProviderName);
DbConnection connection = factory.CreateConnection();
Answer: D

Microsoft   certification 70-561   certification 70-561   70-561 examen

NO.30 You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET. The
application connects to a Microsoft SQL Server 2005 database.
You write the following code segment.
string queryString = "Select Name, Age from dbo.Table_1";
SqlCommand command = new SqlCommand(queryString, (SqlConnection)connection));
You need to get the value that is contained in the first column of the first row of the result set returned by
the query.
Which code segment should you use?
A. var value = command.ExecuteScalar();
string requiredValue = value.ToString();
B. var value = command.ExecuteNonQuery();
string requiredValue = value.ToString();
C. var value = command.ExecuteReader(CommandBehavior.SingleRow);
string requiredValue = value[0].ToString();
D. var value = command.ExecuteReader(CommandBehavior.SingleRow);
string requiredValue = value[1].ToString();
Answer: A

Microsoft examen   70-561   70-561 examen   70-561   certification 70-561