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

You are designing a .NET Framework 4 solution that includes a Windows Presentation Foundation (WPF) application. The WPF application connects to a Microsoft SQL Server 2008 database. You plan to deploy the WPF application to millions of client computers. The SQL Server database will be hosted in a data center.
The WPF application will query the database to provide type-ahead assistance as users enterdata.The WPF application will send a query after each character is entered. Each query will access multiple joined tables.
You need to recommend an approach for maximizing scalability of the solution.
What should you recommend?

• A.Use System.Runtime.Caching to cache query results on the client.
• B.Denormalize the data to fewer tables.
• C.Create stored procedures to abstract the tables.
• D.Create a separate data layer with caching.

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

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

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.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.
• 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 data access layer class.
• 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 WPF application.
• D.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.

---
You are designing updates to a Windows solution that processes complex scientific datA.The solution extracts analyzed data from Microsoft Excel by using an application-level add-in.
You have the following requirements:
Deploy the Excel add-in to client machines with the application.
Ensure that the solution supports Excel 2007 and Excel 2010.
Minimize the size of the deployment package.
You need to recommend an approach that meets the requirements.
What should you recommend?

• A.Embed the type information from the Excel 2010 COM library.
• B.Include the primary interop assembly for Excel 2007.
• C.Embed the Excel 2010 COM library.
• D.Include the primary interop assembly for Excel 2010.

You are developing an application by using Microsoft .NET Framework 4.
The application will be used by all employees of your company. Local file stores on the computers are secure and inaccessible remotely.
You need to design a remote monitoring strategy to monitor the usage time of the application by each user.
What should you do?

• A.Create a TraceLog object and the Trace object by using the System.Diagnostics element to trace startup, shutdown, and user idle time events throughout the application.
• B.Use the System.Management.Instrumentation namespace to publish startup, shutdown, and user idle time events of the application. Publish the events to Microsoft Operations Manager.
• C.Use the System.Management.Instrumentation namespace to issue event queries against methods that pass ProgressEvent and StoppedEvent arguments. Publish the events to the Event Log.
• D.Create a TraceLog object by using the System.Diagnostics element in the application configuration file. Add the TraceSource element for startup, shutdown, and user idle time events.