QUESTION 91
You are developing a Windows application to manage customer data by using Microsoft .NET Framework 4 and Microsoft Visual Studio 2010. Data is stored in several geographically separated SQL Server databases. Modifications to the database schema have caused the application to fail.
You need to ensure that schema modifications will not cause application failure.
Which data access methodology should you use?
A. LINQ to SQL
B. ADO.NET Entity Framework
C. ADO.NET Data Table objects
D. ADO.NET Data Reader objects
Answer: B
QUESTION 92
You are designing a Windows client application by using Microsoft .NET Framework 4. You create a Global Positioning System (GPS) navigation application. Routing data is stored on a server. A wireless data connection that has limited bandwidth allows the application to download data from the server. The application continuously shows a perspective view of the route ahead as a user sees it, based on the position and direction of the vehicle. Prior to navigation, a user types their destination and selects a route they will follow.
You need to ensure that when the position or direction of the vehicle changes, the perspective view is updated immediately.
What should you do?
A. Download perspective views asynchronously as JPEG images when the user moves toward the route.
B. Compute the best route on the server.
Download the selected routing data as geographic coordinates before the routing begins.
C. Compute all possible perspective views on the server, compress them as JPEG images, and download the images before the routing begins
D. When a wireless connection is available, compute potential routes from the current position of the car and store the corresponding routing data on the client application.
Answer: B
QUESTION 93
You are designing a Windows application by using Microsoft NET Framework 4, Microsoft Visual Studio 2010, and Microsoft SQL Server 2008 You plan to create a Windows Communication Foundation (WCF) service. The service will query a SQL Server database. The database will be replicated to four geographically separated database instances.
You need to ensure that the WCF service meets the following requirements:
– II allows additional database instances to be added
– It routes users to the closest database server.
What should you do?
A. Implement context-based filtered routing
B. Implement content-based filtered routing
C. Store each database connection string in a local database instance.
D. Add each database server connection string to the Web configure
Answer: A
QUESTION 94
You are designing a .NET Framework 4 solution. The solution contains a Windows Presentation Foundation (WPF) application and a Windows Communication Foundation (WCF) Web service. The WPF application uses the WCF Web service to store data in a Microsoft SQL Server 2008 database.
You have the following requirements:
– Ensure that the WPF application functions while users’computers areoffline.
– Minimize the time spent sending data to the WCF Web service.
– Minimize disk space requirements for data storage.
You need to recommend an approach for synchronizing data between the WPF application and the database.
Which two actions should you recommend? (Each correct answer presents part of the solution. Choose two.)
A. Store data in custom business objects. Serialize data locally by using custom serialization.
B. Create a local caching solution that periodically checks for Internet connectivity, uses local memory, and batches changes to the WCF Web service.
C. Create a local caching solution that periodically checks for Internet connectivity and writes directly to the local data store and to the WCF Web service.
D. Store data in DataSet objects. Serialize data locally by using XML serialization.
Answer: AC
QUESTION 95
You are designing an n-tier .NET Framework 4 solution that includes a Windows Presentation Foundation (WPF) application. The WPF application will access data stored in a Microsoft SQL Server 2008 database by using the solution’s data access tier.
The data access tier must also be available from within Microsoft Excel 2010.
You need to recommend a technology for accessing the data access tier.
Which technology should you recommend?
A. ADO.NET Entity Framework 4
B. LINQ to SQL
C. WCF Data Services
D. LINQ to XML
Answer: C
QUESTION 96
You are designing a Windows Presentation Foundation (WPF) application by using Microsoft .NET Framework 4, Microsoft Visual Studio 2010, and Microsoft SQL Server 2008.
You have designed the application to use the ADO.NET Entity Framework for the Data Access Layer (DAL).
You have designed the user interface (UI) of the application by using the Model-View-ViewModel (M-VVM) pattern.
The middle tier of the application is designed by using Windows Communication Foundation (WCF).
The database schema changes often. The DAL entity objects are required to be referenced from the middle tier and the ViewModel layer of the UI.
You need to ensure that the DAL entity objects are updated when the database schema changes.
What should you do?
A. Create an observable collection of objects.
B. Create typed DataSets.
C. Create persistent-aware objects.
D. Create persistent-ignorant objects.
Answer: C
QUESTION 97
You are designing a Windows Presentation Foundation (WPF) application that will process data. The data is stored in a Microsoft SQL Server 2008 database.
You plan to access the data by using ADO.NET Entity Framework 4.
You need to recommend an approach that minimizes the number of calls to the database server.
What should you recommend?
A. Use lazy loading.
B. Use SqlDependency objects.
C. Use change tracking in the ObjectContext object.
D. Use eager loading.
Answer: D
QUESTION 98
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 DbDotoAdopter 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. Move the update method calls to a separate BackgroundWorker thread.
D. Remove any limit on batch update sizes. Modify the client application to perform a single update.
Answer: D
QUESTION 99
You are modifying an existing Windows Presentation Foundation (WPF) application that uses .NET Framework 4. The WPF application uses a wizard to capture data and insert the data into a database. The database includes one parent table and many child tables.
Inserting captured data in the database locks many database tables and delays application access.
You have the following requirements:
– Reduce delays when saving data.
– Ensure that other application users are not blocked from reading data.
– Ensure that captured data is available only after all child tables are updated.
You need to recommend an approach for inserting captured data into the database.
What should you recommend?
A. Insert all captured data in a single transaction when the user completes the wizard.
B. Insert captured data by using a single transaction as the user completes each wizard page.
C. Insert captured data by using non-transactional operations when the user completes the wizard.
D. Insert captured data by using optimistic concurrency as the user completes each wizard page.
Answer: A
QUESTION 100
You are developing an application by using Microsoft .NET Framework 4 and Microsoft Visual Studio 2010.
The application contains a grid that displays customer data stored in a database table. Users report that the grid takes a long time to display.
You plan to implement data caching to improve loading time for the grid.
You need to ensure that the cached data expires when the customer data is updated.
What should you do?
A. Use the System.Web.Caching.CacheDependency class.
B. Use the System.Runtime.Caching.SqlChangeMonitor class.
C. Use the ADO.NET Entity Framework.
D. Use a static variable to store the Grid object.
Answer: B
Free Download Microsoft 70-518 PDF and VCE Dumps Help You 100% Pass Exam
