You need to ensure that the application meets the following requirements: • There is a SqlConnection named c
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. The
application connects to two different Microsoft SQL Server 2008 database servers named Serverl
and Server2. A string named sqllcontains a connection string to Serverl. A string named sql2contains
a connection string to Server2.
01 Using scope As New 02
03 Using cnl As New SqlConnection(sqll)
04 Try 05
06 Catch ex As Exception
07 End Try
08 End Using
09 scope.Complete()
10 End Using
You need to ensure that the application meets the following requirements:
• There is a SqlConnection named cn2 that uses sql2.
• The commands that use cnl are initially enlisted as a lightweight transaction.
• The cn2 SqlConnection is enlisted in the same TransactionScope only if commands executed
by cnl do not throw an exception.
What should you do?
You need to ensure that the application synchronizes data successfully
You are developing an application by using Microsoft .NET Framework 4 and Microsoft
Visual Studio 2010. You plan to use Microsoft Sync Framework to synchronize the data
stored in a local Microsoft SQL Server Compact Edition database with the data stored in a
centralized SQL Server 2008 database. Four columns are added to each table involved in
the synchronization process to track changes to the database. You add the following four
columns to the database table. Users report that the synchronization process is not always
successful. You need to ensure that the application synchronizes data successfully. What
should you do?
Which data access technology should you use?
You are designing a Windows application by using Microsoft .NET Framework 4, Microsoft
Visual Studio 2010, and Microsoft SQL Server 2008. You need to design a data access
strategy that meets the following requirements: • Automatically tracks changes • Maps the
database data model to the object model Which data access technology should you use?
Which approach should you recommend?
You are planning a deployment process for a set of interrelated Web services. You need to
ensure maximum availability of the Web services in the event of a hardware or software
failure. Which approach should you recommend?
What should you add to the schema of the action?
You are creating a custom workflow action to be used in Microsoft SharePoint Designer reusable
workflows. The action programmatically creates a SharePoint site named Site1 at a specific URL.
The workflow actions schema file contains the following code segment. < Workflowlnfo> <Actions
Sequential=”then” Parallel=”and”> <Action Name=”Create Sice” ClassName =”
SPDActivityDemo.Createsite ” Assembly=” SPDActivityDemo , Version=l.0.0.0, Culture=neutral,
PublicKeyToken= Ia4a7a2c3215a71b ” AppliesTo =”all” Category=”Test”> <Parameters>
<Parameter Name=”Url” Type=” System.String , mscorlib ” Direction=”Inr’ /> <Parameters>
</Action> </Actions> </ Workflowlnfo > You need to ensure that users can specify the URL
property of the action in SharePoint Designer. What should you add to the schema of the action?
Which two actions should you perform?
You are developing a Windows application by using Microsoft .NET Framework 4, Microsoft
Visual Studio 2010, and Microsoft SQL Server 2003. 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.)
You need to design a database locking strategy that meets the following requirements:
You are designing the data access layer (DAL) for an application that uses Microsoft SQL
Server 2008, Microsoft ADO.NET, and Microsoft Visual Studio 2010. Conflicts are occurring
in the SQL Server database due to concurrent updates. You need to design a database
locking strategy that meets the following requirements: • Resolves concurrent update
conflicts without loss of data • Ensures that data conflicts can be resolved by users • Locks
only the data necessary for updates What should you do?
Which connection string should you add to the app.config file?
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. You
use the ADO.NET Entity Framework to model your entities. The application connects to a Microsoft
SQL Server 2008 database named AdventureWorks by using Windows Authentication. Information
about the required Entity Data Model (EDM) is stored in the following files:
• model.csdl
• model.ssdl
• model.msl
These files are embedded as resources in the MyCompanyData.dll file. You need to define the
connection string that is used by the application. Which connection string should you add to the
app.config file?
Which type of authentication should you design?
You are designing an extranet site using SharePoint 2010. This site must allow employees
to log on to the extranet site from home. They should use their corporate Active Directory
credentials by typing their user name and password into text boxes on a logon page on the
site. After users log on, they should be redirected to the site home page. You need to meet
these requirements with the least amount of configuration. Which type of authentication
should you design?
Which two components should you include in the reservation?
You need to add a reservation for a print device to a DHCP scope. Which two components should
you include in the reservation? (Each correct answer presents part of the solution. Choose two.)