Microsoft-Pro Designing and Developing Windows Applications Using Microsoft .NET Framework 4 Set 1

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?

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-V-VM) 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?

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?

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?

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:

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?

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 operations data. 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 retrieved data. Target the .NET Framework 4 Client Profile. You need to recommend an approach to data caching. What should you recommend?

You are designing a Windows Presentation Foundation (WPF) application that accesses a Microsoft SQL Server 2008 database. You must ensure that database administrators can change the structure of database tables without requiring redeployment of the WPF application. You need to recommend a data modeling and data access strategy. What should you recommend?.

You are designing an application by using Microsoft .NET Framework 4 and Microsoft Visual Studio 2010. The application includes Windows Workflow Foundation (WF) hosts that run thousands of workflow instances. Workflows usually take 2 hours of time to complete. The application also includes a Windows Communication Foundation (WCF) service that contains a method to check the completion status of a workflow stored in a database. External applications that use the WCF service to check the status of workflows every minute causes performance degradation of the workflow that hosts the application. You need to eliminate the performance degradation caused by workflow status checks. What should you do?

You are designing an n-tier solution for use by multiple groups of users. The solution consists of a client application that collects information from users and transmits it to a business layer for processing. The business layer sends the information to a service layer by using Windows Communication Foundation (WCF). The service layer exists on multiple servers. The solution must send the collected information to a specific server in the service layer based on the user's group. You need to recommend an approach that will allow the information to be sent to the correct server. What should you recommend?