You are developing an ASP.NET MVC application that reads and writes data from a SQL
Server database.
You need to maintain data integrity in all situations that use transactions.

HOTSPOT
You are supporting an application that uses the ADO.NET Entity Framework to query and
access data.
The latest version of Entity Framework contains bug fixes that will improve performance. You
need to update Entity Framework.
Which Visual Studio 2012 menu item should you choose? (To answer, select the appropriate
menu item in the answer area.)

You are developing an ASP.NET MVC application.
Deployment administrators do not have access to Visual Studio 2102, but will have the
elevated permissions required to deploy the application to the servers. You need to select a
deployment tool for use by the deployment administrators. Which tool should you use?

HOTSPOT
You are developing an ASP.NET MVC application named ContosoWebApp. You are ready
to deploy the application to your production web server.
You need to import the publishing profile.
Which menu item should you use? (To answer, select the appropriate menu item in the
answer area).

HOTSPOT
You are developing an ASP.NET MVC application. It is ready for deployment to the
production web server.
A local SQL Express .MDF file was used by the application during development
The deployment has the following requirements:
The deployment must merge the assemblies on the local machine with those on the host.
The deployment must publish the local database to the remote Microsoft SQL server.
You need to configure the web package settings for deployment.
Which settings should you use? (To answer, select the appropriate setting or settings in the
answer area.)

You are developing a Microsoft Azure web application. The application will be deployed to
10 web role instances. A minimum of 8 running instances is needed to meet scaling
requirements.
You need to configure the application so that upgrades are performed as quickly as possible,
but do not violate scaling requirements.
How many upgrade domains should you use?

You are supporting an application that uses the ADO.NET Entity Framework to query and
access data.
The latest version of a tool will add new templates and wizards that will enhance developer
productivity.
You need to update the tool.
Which Visual Studio 2012 menu item should you choose? (To answer, select the appropriate
menu item in the answer area.)

You are developing an ASP.NET MVC application that displays a report. The report includes
large images that are stored in a database. Members of the EntityClient namespace are
used to access the database through the ADO.NET Entity Framework data model.
You need to prevent memory exceptions while generating a report using the
EntityDataRcader type.
Which CommandBehavior type should you use?

You are developing an ASP.NET MVC application. The application has a page that searches
for and displays an image stored in a database. Members of the EntityClient namespace are
used to access an ADO.NET Entity Framework data model. Images and associated
metadata are stored in a database table.
You need to run a query that returns only the image while minimizing the amount of data that
is transmitted.
Which method of the EntityCommand type should you use?

You are developing an order processing application that uses the ADO.NET Entity
Framework against a SQL Server database. Lazy loading has been disabled. The
application displays orders and their associated order details. Order details are filtered
based on the category of the product in each order.
The Order class is shown below.

The OrderDetail class is shown below.

The Product class is shown below.

The Category class is shown below.

You need to return orders with their filtered list of order details included in a single round
trip to the database. Which code segment should you use?