Microsoft 70-518 Online Practice Questions and Exam Preparation

Microsoft 70-518 Online Questions & Answers

• Question 101:

  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.
  D. Use eager loading.

• Question 102:

  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?

  A. Model the data layer by using DataSet objects with automatically generated Create, Read, Update, and Delete (CRUD) statements.
  B. Model the data layer by using custom data access objects. Access the database by using stored procedures.
  C. Model the data layer by using LINQ to SQL with attribute-based mapping of objects to tables.
  D. Model the data layer by using typed DataSet objects with automatically generated Create, Read, Update, and Delete (CRUD) statements
  B. Model the data layer by using custom data access objects. Access the database by using stored procedures.

• Question 103:

  You design a Windows Presentation Foundation (WPF) application that connects to a Microsoft SQL Server 2008 database.

  The WPF application becomes unresponsive at times. When the WPF application is running, physical memory usage is between 90 percent and 95 percent.

  You need to recommend a tool that will identify the memory usage characteristics of the WPF application.

  Which tool should you recommend?

  A. Application Center Test (ACT)
  B. CLR Profiler
  C. Event Tracing for Windows (ETW)
  D. SQL Profiler
  A. Application Center Test (ACT)

• Question 104:

  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.
  A. Insert all captured data in a single transaction when the user completes the wizard.

• Question 105:

  You are developing a Windows application by using Microsoft .NET Framework 4, Microsoft Visual Studio 2010, and Microsoft SQL Server 2008. New features that require changes to be made to the database schema are added to the application every week.

  You need to ensure that the changes made to the database schema do not require the application to be recompiled.

  Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

  A. Modify the xml mapping file when the schema changes occur.
  B. Modify the conceptual schema xml file when the schema changes occur.
  C. Build a storage model and use it to access data from the business entities.
  D. Build a conceptual model and use it to access data from the business entities.
  A. Modify the xml mapping file when the schema changes occur.
  D. Build a conceptual model and use it to access data from the business entities.

• Question 106:

  The application includes multiple Windows Workflow Foundation (WF) hosts along with thousands of instances.

  The application will continue to execute over extended periods of time. You need to ensure that the performance of the application does not degrade over extended periods of time.

  Which type of testing should you perform on the application?

  A. Stress testing
  B. Duration testing
  C. Functional testing
  D. Scalability testing
  B. Duration testing

• Question 107:

  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?

  A. Model the data layer by using typed DataSet objects with automatically generated Create, Read, Update, and Delete (CRUD) statements.
  B. Model the data layer by using DataSet objects with automatically generated Create, Read, Update, and Delete (CRUD) statements.
  C. Model the data layer by using LINQ to SQL with attribute-based mapping of objects to tables.
  D. Model the data layer by using custom data access objects. Access the database by using stored procedures.
  D. Model the data layer by using custom data access objects. Access the database by using stored procedures.

• Question 108:

  You are designing a Windows Presentation Foundation (WPF) application.

  The application will be localized into multiple languages.

  You need to recommend an approach for preparing the application for localization. Which two actions should you recommend? (Each correct answer presents part of the solution.

  Choose two.)

  A. Add UID attributes to language-specific elements in the XAML file.
  B. Define a UICulture element for each language in the project file.
  C. Add an application setting for each language to the App.config file.
  D. Translate the contents of the appropriate XAML elements into each localization language.
  A. Add UID attributes to language-specific elements in the XAML file.
  B. Define a UICulture element for each language in the project file.

• Question 109:

  You have developed a Windows application by using Microsoft .NET Framework 4, Windows Presentation Foundation (WPF), and Microsoft SQL Server 2008.

  The application is deployed as an XAML Browser Application (XBAP) and executes in the Internet Zone in Internet Explorer. The application updates data in a SQL Server 2008 database. Users report that a SecurityException exception

  occurs when the application attempts to save data to the database.

  You need to design a solution to resolve the problem.

  What should you do?

  A. Redesign the XBAP application by using partial trust.
  B. Redesign the XBAP code to utilize stored procedures.
  C. Design a WCF Service tier to provide database access.
  D. Design a data access layer that uses ASP.NET Entity Framework to communicate with the database by using the System.Data.SqICIient class.
  C. Design a WCF Service tier to provide database access.

• Question 110:

  You are designing a Windows Presentation Foundation (WPF) application that uses .NET Framework 4. The WPF application will be deployed to 5,000 users worldwide.

  You need to recommend an approach for identifying problems that users will experience.

  Which testing methodology should you recommend?

  A. Usability testing
  B. Integration testing
  C. Acceptance testing
  D. Functional testing
  A. Usability testing