Microsoft 70-518 Online Practice Questions and Exam Preparation

Microsoft 70-518 Online Questions & Answers

• Question 111:

  You are designing an application by using Microsoft .NET Framework 4 and Microsoft Visual Studio 2010.

  The application is used mostly in a disconnected scenario. The application requires offline data from a Microsoft SQL Server 2008 database. When the application connects to the network, data will be modified and synchronized.

  You need to ensure that the application does not access the database server directly to synchronize data when online.

  Which technology should you use?

  A. WCF Data Service
  B. Remote Data Access
  C. ADO.NET Sync Services
  D. SQL Server Merge Replication
  C. ADO.NET Sync Services

• Question 112:

  You are designing updates to an existing Windows Presentation Foundation (WPF) application that connects to a Microsoft SQL Server 2008 database. The application updates will require updates to the database.

  You have the following requirements:

  Prevent data loss.

  Recover the database if the database update fails.

  You need to recommend a database deployment strategy.

  Which two actions should you recommend? (Each correct answer presents part of the solution.Choose two.)

  A. Place the database in single-user mode before deploying the changes.
  B. Specify the simple recovery model for the database.
  C. Specify the full recovery model for the database.
  D. Place the database in restricted user mode before deploying the changes.
  A. Place the database in single-user mode before deploying the changes.
  C. Specify the full recovery model for the database.

• Question 113:

  You are updating a Windows desktop client application that was created by using Microsoft .NET Framework 4 and Microsoft Visual Studio 2010.

  The application displays data derived from several database queries. The display takes a long time to update.

  The application currently uses a BackgroundWorker thread and a Parallel.ForEach statement on that thread.

  Users have requested a modification to the program that would allow them to interrupt the display of data and begin processing a new and different query.

  You decide to provide a new Stop button on the user interface (UI) to allow the user to terminate the current data display and initiate the new query.

  The main UI thread must be notified when the current data processing is terminated so that the new query can be started.

  You need to implement the Stop button event handler.

  What should you do?

  A. Use the DoWork handler of the worker thread and test a shared status value. Use a break statement to terminate the Parallel.ForEach loop.
  B. Use the DoWork handler of the worker thread and test a shared status value. Use a loopStatus.Stop() statement to terminate the Parallel.ForEach loop.
  C. Use the DoWork handler of the worker thread and test a shared status value. Use the Thread.AbortQ statement to terminate the worker thread. Start a new BackgroundWorker thread from the main UI thread.
  D. Use a CancelAsync() function to cancel the worker thread. In the Parallel.ForEach loop, test the CancellationPending property. If the property is set to true, perform the following tasks: Write a loopStatus.Stop() statement. Set the DoWorkEventArgs.Cancel property to true. Use a return statement to exit from the loop.
  D. Use a CancelAsync() function to cancel the worker thread. In the Parallel.ForEach loop, test the CancellationPending property. If the property is set to true, perform the following tasks: Write a loopStatus.Stop() statement. Set the DoWorkEventArgs.Cancel property to true. Use a return statement to exit from the loop.

• Question 114:

  You are developing a Windows Presentation Foundation (WPF) application by using Microsoft .NET Framework 4 and Microsoft Visual Studio 2010.

  The application will run in a partially trusted sandbox.

  You plan to deploy the application on client computers by using the ClickOnce deployment technology.

  You plan to sign the deployment and application manifest by using a trusted publisher certificate. You need to ensure that the following requirements are met:

  Users are not prompted for elevated permissions during application deployment.

  The application can request elevated permissions at runtime.

  Where should you install the trusted publisher certificate?

  A. in the trusted root store on the deployment server
  B. in the trusted publisher store on the deployment server
  C. in the trusted root store on each client computer
  D. in the trusted publisher store on each client computer
  D. in the trusted publisher store on each client computer

• Question 115:

  You are designing an application by using Microsoft .NET Framework 4 and Microsoft Visual Studio 2010.

  You plan to design an instrumentation strategy for the application.

  You need to ensure that the strategy meets the following requirements:

  Captures detailed performance information.

  Enables or disables diagnostic messages by using an application configuration option without requiring the application to restart.

  What should you design?

  A. A custom trace listener
  B. A custom performance counter
  C. An override to the Debug class
  D. An override to the EventLog class
  B. A custom performance counter

• Question 116:

  You are designing a Windows Presentation Foundation (WPF) application by using Microsoft .NET Framework 4 and Microsoft Visual Studio 2010.

  You plan to create a Customer object that contains an Orders property. The Orders property contains an array of Order objects.

  When users browse Customer objects, they must be able to optionally view Order objects.

  You need to design a data access strategy that retrieves data only when necessary.

  Which strategy should you use?

  A. lazy loading
  B. eager loading
  C. file streaming
  D. pessimistic locking
  A. lazy loading

• Question 117:

  You are developing an application by using Microsoft .NET Framework 4 and Microsoft Visual Studio 2010.

  You plan to use Microsoft Sync Framework to synchronize the data stored in a local Microsoft SQL Server Compact Edition database with the data stored in a centralized SQL Server 2008 database.

  Four columns are added to each table involved in the synchronization process to track changes to the database.

  You add the following four columns to the database table.

  

  Users report that the synchronization process is not always successful. You need to ensure that the application synchronizes data successfully. What should you do?

  A. Option A
  B. Option B
  C. Option C
  D. Option D
  A. Option A

• Question 118:

  You are designing a Windows Presentation Foundation (WPF) application by using Microsoft .NET Framework 4 and Microsoft Visual Studio 2010.

  You plan to create an Author object that contains a Books property. The Books property contains a large array of Book objects.

  When users browse through author data in the application, they must be able to view all information related to books written by that author without additional queries.

  You need to design a data access strategy that meets the requirement.

  Which strategy should you use?

  A. lazy loading
  B. eager loading
  C. optimistic locking
  D. pessimistic locking
  B. eager loading

• Question 119:

  You are designing a Windows Presentation Foundation (WPF) application. The WPF application contains code that will be executed by both full trust callers and partial trust callers. The WPF application code does not have the

  AllowPartialTmstCallers attribute set.

  You have the following requirements:

  The application security settings must allow partial trust callers to create and write to a file.

  Users must have access only to files that they create and not to files created by other users. You need to recommend a location for storing each user' s files.

  Which location should you recommend?

  A. the user's Roaming folder
  B. the user's LocalSettings folder
  C. the user's IsolatedStorage folder
  D. the user's My Documents folder
  C. the user's IsolatedStorage folder

• Question 120:

  You are developing an application by using Microsoft .NET Framework 4.

  The application will be used by all employees of your company, Local file stores on the computers are secure and inaccessible remotely.

  You need to design a remote monitoring strategy to monitor the usage time of the application by each user.

  What should you do?

  A. Create a TraceLog object and the Trace object by using the System.Diagnostics element to trace startup, shutdown, and user idle time events throughout the application.
  B. Create a TraceLog object by using the System.Diagnostics element in the application configuration file. Add the TraceSource element for startup, shutdown, and user idle time events.
  C. Use the System.Management.Instrumentation namespace to publish startup, shutdown, and user idle time events of the application. Publish the events to Microsoft Operations Manager.
  D. Use the System.Management.Instrumentation namespace to issue event queries against methods that pass ProgressEvent and StoppedEvent arguments. Publish the events to the Event Log.
  C. Use the System.Management.Instrumentation namespace to publish startup, shutdown, and user idle time events of the application. Publish the events to Microsoft Operations Manager.