Microsoft 70-518 Online Practice Questions and Exam Preparation

Microsoft 70-518 Online Questions & Answers

• Question 191:

  You are packaging updates for multiple Windows Presentation Foundation (WPF) applications by using Microsoft .NET Framework 4.

  Updates to the applications and to third-party control files are available. Updates to the applications have dependencies upon updates to the third-party control files. An update script is run at logon that allows only a single command to be

  executed.

  You need to package the application updates and updates to the third party controls to ensure that they are successfully installed.

  What should you do?

  A. Package application updates as a single installer. Package third-party control files as a merge module.
  B. Package application updates as a single installer. Package third-party control files as a separate installer.
  C. Prepare the installers for individual application updates and include the third-party control files as individual files.
  D. Prepare the installers for individual application updates and include the third-party control files as a merge module.
  A. Package application updates as a single installer. Package third-party control files as a merge module.

• Question 192:

  You are designing a distributed application that will be deployed to 5,000 users worldwide. Servers on five continents will host the Web services and the Microsoft SQL Server 2008 databases that support the application.

  You have the following requirements:

  Collect information about all errors associated with the application.

  Store and view all error information in a centralized location.

  Minimize the network bandwidth required for the transfer of error information.

  You need to recommend a strategy for reporting error information.

  Which strategy should you recommend?

  A. Write error messages to the SQL Server databases. Synchronize the databases by using merge replication.
  B. Write error messages to the event logs on the local computers. Use Windows Error Reporting to view the error information.
  C. Write error messages to the SQL Server databases. Synchronize the databases by using transactional replication.
  D. Write error messages to the event logs on the local computers. Use Windows Management Instrumentation (WMI) to view the error information.
  B. Write error messages to the event logs on the local computers. Use Windows Error Reporting to view the error information.

• Question 193:

  You are designing an n-tier solution that includes a Windows Presentation Foundation (WPF) client application. The WPF application connects to a middle-tier server that runs the data access layer. The data access layer connects to a

  Microsoft SQL Server 2008 database and to a mainframe-based database.

  The mainframe-based database will be replaced in one year.

  You have the following requirements:

  Centrally manage all database connections.

  Minimize changes to the code base when the database is replaced.

  Ensure that the WPF application will not need to be redeployed when the database is replaced.

  You need to recommend an approach for designing the data access layer.

  What should you recommend?

  A. Create a data access layer class that uses a database factory class to access all databases. Add the connection string information for the databases to the configuration file for the WPF application.
  B. Add the connection string information for the databases to the configuration file for the WPF application. Implement one class in the WPF application for each data source.
  C. Create a data access layer class that uses a database factory class to access all databases. Add the connection string information for the databases to the configuration file for the data access layer class.
  D. Add the connection string information for the databases to the configuration file for the WPF application. Implement a database factory class from within the WPF application.
  C. Create a data access layer class that uses a database factory class to access all databases. Add the connection string information for the databases to the configuration file for the data access layer class.

• Question 194:

  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 195:

  You are designing a new feature for an existing Windows Forms application by using Microsoft .NET Framework 4.

  The application contains multiple forms that are loaded into a parent Multiple Document Interface (MDI) form.

  Your company policy does not allow the use of third-party controls.

  You need to ensure that the new feature meets the following requirements:

  It provides a three-dimensional scale model.

  It allows users to change the colors of the model and communicates the color selections back to the application.

  It allows the model to scale, based on the user's client computer display resolution.

  It is a child form in the MDI application.

  What should you do?

  A. ?Design the new feature in the existing Windows Forms application as a Windows form. ?Add the form as a child form to the MDI window.
  B. ?Design the new feature in a new application by using Windows Presentation Foundation (WPF). ?Invoke the new WPF application from the existing Windows Forms application.
  C. ?Design the new feature in a new Windows Presentation Foundation (WPF) application. ?Host the existing application inside the new WPF application by using the WindowsFormsHost class.
  D. ?Design the new feature by using a Windows Presentation Foundation (WPF) user control. ?Use the ElementHost class to host the WPF user control in the existing Windows Forms application.
  D. ?Design the new feature by using a Windows Presentation Foundation (WPF) user control. ?Use the ElementHost class to host the WPF user control in the existing Windows Forms application.

• Question 196:

  You are designing an application by using Microsoft .NET Framework 4, Microsoft Visual Studio 2010, and Microsoft SQL Server 2008. The application will be used by a sales team to enter sales orders and update customer information.

  You need to ensure that the application meets the following requirements: Allows users to enter sales orders while their computers are disconnected from the network Uploads sales orders to the server database when connected to the network Compiles against the .NET Framework 4 client profile

  What should you use?

  A. XML files
  B. WCF services
  C. Microsoft Sync Framework
  D. The System.Web.Caching namespace classes
  C. Microsoft Sync Framework

• Question 197:

  You are designing a Windows Presentation Foundation (WPF) application that will be used to display real- time data from a Microsoft SQL Server 2008 database.

  You need to recommend an approach for displaying the data.

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

  A. Implement Oneway binding between the controls in the WPF application and objects in the data layer.
  B. Implement OneWayToSource binding between the controls in the WPF application and objects in the data layer.
  C. Use a SqlCacheDependency object in the data layer to query the database when a change is detected.
  D. Use a System.Runtime.Caching object in the data layer with a sliding expiration, and query the database when the Cache object expires.
  A. Implement Oneway binding between the controls in the WPF application and objects in the data layer.
  C. Use a SqlCacheDependency object in the data layer to query the database when a change is detected.

• Question 198:

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

  You plan to add a feature to the application. The application will be used in several different locales.

  The application will send data to a centralized server and log the date and time information.

  You need to ensure that the date and time information includes the local Universal Time Coordinate (UTC) offset value.

  Which class should you use?

  A. Culturelnfo
  B. DateTimeOffset
  C. CulturelnfoConverter
  D. DateTimeOffsetConverter
  B. DateTimeOffset

• Question 199:

  You are analyzing an application that uses Microsoft .NET Framework 4 and Microsoft SQL Server 2008.

  The application is used to maintain an inventory database and is accessed from several remote Windows client applications. The application frequently updates multiple rows in a database table by using a DbDataAdapter object.

  Users report that the application runs slowly during peak business hours.

  When large number of records are changed by multiple users, you discover the following:

  The CPU utilization of the client applications is normal.

  The network utilization increases slightly.

  The CPU utilization of the database server remains close to the normal average for a day.

  You need to resolve the performance issue. What should you do?

  A. Disable batch updates. Modify the client application to perform a single update.
  B. Insert a random time interval between updates.
  C. Remove any limit on batch update sizes. Modify the client application to perform a single update.
  D. Move the update method calls to a separate BackgroundWorker thread.
  C. Remove any limit on batch update sizes. Modify the client application to perform a single update.

• Question 200:

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

  The application retrieves data from multiple heterogeneous data sources. The retrieved data is aggregated into a single record set

  You need to ensure that the application takes advantage of new multi-core server processors.

  Which technology should you use?

  A. LINQ
  B. PLINQ
  C. ADO.NET DataSet
  D. ADO.NET Typed DataSet
  B. PLINQ