DRAG DROP
You have an Azure SQL Database that contains two tables named Country and City.
You need to insert a country into the Country table and a city into the City table. The solution must meet the
following requirements:
If an error occurs while attempting to add the country, the city must NOT be added.
If an error occurs while attempting to add the city, the country must NOT be added.
How should you complete the code? To answer, drag the appropriate code blocks to the correct locations in the
answer area. Each code block may be used once, more than once, or not at all. You may need to drag the split
bar between panes or scroll to view content.
Select and Place:

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 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 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.)
Hot Area:

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.

You are developing an ASP.NET MVC application. The application is an order processing system that uses the
ADO.NET Entity Framework against a SQL Server database. It has a controller that loads a page that displays
all orders along with customer information. Lazy loading has been disabled.
The Order class is shown below.

You need to return the orders and customer information in a single round trip to the database.
Which code segment should you use?

You are designing an ASP.NET Web API application.
You need to select an HTTP verb to allow blog administrators to remove a comment.
Which HTTP verb should you use?

DRAG DROP
You are developing an ASP.NET Web API action method.
The action method must return the following JSON in the message body.
{“Name”: “Fabrikam”, “VendorId” :9823, Items”: [“Dogs”, “Cats”) >
You need to return an anonymous object that is serialized to JSON.
What should you do? (To answer, drag the appropriate code segments to the correct location or locations in the
answer area. Each code segment may be used once, more than once, or not at all. You may need to drag the
split bar between panes or scroll to view content.)
Select and Place:

DRAG DROP
You are developing an ASP.NET MVC Web API application.
The application must meet the following requirements:
It must send or receive data without the use of a buffer.
It must allow up to 1 MB of data to be received.
It must allow up to 2 MB of data to be sent.
You need to complete the code to meet the requirements.
What should you do? (To answer, drag the appropriate code segments to the correct location or locations in the
answer area. Each code segment may be used once, more than once, or not at all. You may need to drag the
split bar between panes or scroll to view content.)
Select and Place:

DRAG DROPYou are creating a WCF service.
The service endpoints must be exposed to the Microsoft Azure Service Bus. The service bus has a namespace
named RestaurantSB. The key provider is “owner”.
You need to modify the web.config file to expose the endpoints.
You have the following markup in the web.config file:

Which attributes should you include in Target 1, Target 2 and Target 3 to complete the markup? (To answer,
drag the appropriate attributes to the correct targets or locations in the answer area. Each attribute may be
used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view
content.)
Select and Place: