Free Microsoft 70-518 Exam Dumps Questions & Answers

You are designing a Windows Presentation Foundation (WPF) application.
The WPF application must run against either Microsoft SQL Server 2008 or a third-party
database system without duplicating data accesslogic.
You need to recommend a data access technology.
What should you recommend?

• A.  ADO.NET using DataSet objects and SqlDataReader objects
• B.  ADO.NET using DataSet objects and SqIDataAdapter objects
• C.  LINQ to SQL
• D.  LINQ to Entities

You are reviewing an existing Windows application that uses .NET Framework 4.
When the user clicks a button, the application sequentially processes thousands of image
files contained in a directory.
The user interface becomes unresponsive while the application processes the files.
You have the following requirements:
---
Modify the button's click event.
Increase application throughput by processing multiple image files concurrently.
Ensure that the user interface remains responsive while the application processes
the image files.
You need to recommend an approach for meeting the requirements.
What should you recommend?

• A.  Iterate over the image files by using the Parallel.ForEach() method. For each image file, start a separate thread that processes the image file, by using the Thread.Start()method.
• B.  Use the ThreadPool.QueueUserWorkItem() method to queue up a single work item that uses the Parallel.ForEach () method to process the image files concurrently.
• C.  Use the Parallel.ForEach() method to process the images concurrently.
• D.  Iterate over the image files. For each image file, use the Process.Start() method to launch a console application that processes the image file.

You are designing a Windows Forms application. The application connects to a Microsoft SQL Server 2008 database.
You need to recommend an approach for retrieving and logging all informational messages and error messages reported by the database.
What should you recommend?

• A.  Retrieve informational messages and error messages in a SqlException object.
• B.  Retrieve informational messages in a SqlException object. Retrieve error messages by creating a handler for the InfoMessage event.
• C.  Retrieve informational messages by creating a handler for the InfoMessage event. Retrieve error messages in a SqlException object.
• D.  Retrieve informational messages and error messages by creating a handler for the InfoMessage event.

You are designing a Windows Presentation Foundation (WPF) application. The WPF application displays indicators to compare your company's past performance to the current day's operationsdata.
The WPF application accesses historic data from your company's data warehouse through a Web service, and accesses current data directly from a Microsoft SQL Server 2008 database.
The WPF application must meet the following requirements:
- Retrieve historic data from the data warehouse at application startup and then once per day.
- Retrieve current data from the database every five minutes, and then update the
indicators.
- Cache all retrieveddata.
- Target the .NET Framework 4 Client Profile.
You need to recommend an approach to data caching.
What should you recommend?

• A.  Use System.Runtime.Caching with a sliding expiration.
• B.  Use System.Runtime.Caching with an absolute expiration.
• C.  UseSystem.Web.Caching with an absolute expiration.
• D.  UseSystem.Web.Caching with a sliding expiration.

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.  Insert a random time interval between updates.
• B.  Disable batch updates. Modify the client application to perform a single update.
• 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.