You are designing a multi-tenant Windows Presentation Foundation (WPF) application that
will connect to a Microsoft SQL Server 2008 database. The WPF application will change the
structure of database tables and views at runtime based on the tenant’s configuration. The
WPF application must meet the following requirements: • Keep each tenant’s data separate.
• Allow changes to the structure of the tables and views for each tenant without interfering
with other tenants’ data. You need to recommend an approach for managing the database
structure. What should you recommend?

You are designing an update to an existing Windows Presentation Foundation (WPF)
application. You plan to use Microsoft Visual Studio 2010. The updated WPF application will
require a specific version of a third-party component. You have the following requirements: •
Deploy the update by using Windows Installer. • Update the WPF application only if the
required version of the third-party component is present on the client computer. You need to
recommend configuration settings for the application installer. Which property should you
recommend be set?

You are designing updates to an existing Windows Presentation Foundation (WPF)
application that connects to a Microsoft SQL Server 2008 database. The application
updates will require updates to the database. You have the following requirements: •
Prevent data loss. • Recover the database if the database update fails. You need to
recommend a database deployment strategy. Which two actions should you recommend?
(Each correct answer presents part of the solution. Choose two.)

You are designing an application by using Microsoft .NET Framework 4 and Microsoft
Visual Studio 2010. The application will store data that includes a time and date stamp. The
middle tier of the application is implemented by using Windows Communication Foundation
(WCF). The middle tier connects to geographically separated database servers. You need
to ensure that the application meets the following requirements; • Data stored contains time
and date information local to the database server. • Data stored contains Universal
Coordinated Time (UTC). Which class should you use?

You are designing a Windows Presentation Foundation (WPF) application. The WPF
application contains code that will be executed by both full trust callers and partial trust
callers. The WPF application code does not have the AllowPartialTrustCallers attribute set.
You have the following requirements: • The application security settings must allow partial
trust callers to create and write to a file. • Users must have access only to files that they
create and not to files created by other users. You need to recommend a location for storing
each user’s files. Which location should you recommend?

You are designing a Windows application by using Microsoft .NET Framework 4 and
Microsoft Visual Studio 2010. You need to use a replacement culture for the application at
runtime. You also need to ensure that the information in the custom culture will tie available
to the application. Which two tasks should you perform? (Each correct answer presents part
of the solution. Choose two.)

You are designing a Windows Presentation Foundation (WPF) application. The application
calls methods that perform long-running computational tasks. You need to recommend an
approach for ensuring that the application remains responsive while the tasks are executing.
What are two possible ways to achieve this goal? (Each correct answer presents a
complete solution. Choose two.)

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?

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. The mainframe-based database will be
replaced in one year. You have the following requirements: • Centrally manage all database
connections. • Minimize changes to the code base when the database is replaced. • Ensure
that the WPF application will not need to be redeployed when the database is replaced. You
need to recommend an approach for designing the data access layer. 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 DbDataAdapter 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?