70-518 試験問題を無料オンラインアクセス

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.

• 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 data access layer class.
• B.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.
• C.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.
• 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.

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.Runtime.Caching.SqlChangeMonitor class.
• B.Use the ADO.NET Entity Framework.
• C.Use a static variable to store the Grid object.
• D.Use theSystem.Web.Caching.CacheDependency class.

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.Use a SqlCacheDependency object in the data layer to query the database when a change is detected.
• C.Use a System.Runtime.Caching object in the data layer with a sliding expiration, and query the database when the Cache object expires.
• D.Implement OneWayToSource binding between the controls in the WPF application and objects in the data layer.

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 captured data by using a single transaction as the user completes each wizard page.
• B.Insert captured data by using non-transactional operations when the user completes the wizard.
• C.Insert captured data by using optimistic concurrency as the user completes each wizard page.
• D.Insert all captured data in a single transaction when the user completes the wizard.

You are designing an n-tier solution that connects to a Microsoft SQL Server 2008 database.
You plan to deploy the database to development machines and to a staging database server from within Microsoft Visual Studio 2010.
You plan to set up separate build configurations for development and staging. You also plan to deploy to multiple production database servers managed by an outside vendor.
You must not allow the outside vendor to access the Visual Studio projects.
You need to recommend an approach for configuring and deploying the production database servers.
Which two actions should you recommend? (Each correct answer presents part of the solution. Choose two.)

• A.Use VSDBCMD to deploy the production databases.
• B.Use a Visual C# SQL CLR Database Project.
• C.Use SQL Server 2008 Management Studio to deploy the production databases.
• D.Use a SQL Server 2008 Database Project.