Nothing Special   »   [go: up one dir, main page]

PassLeader 70-487

Download as pdf or txt
Download as pdf or txt
You are on page 1of 115

Vendor: Microsoft

Exam Code: 70-487


Exam Name: Microsoft Developing Windows Azure and
Web Services
Version: 15.011

QUESTION 1
You are building an ADO.NET Entity Framework application.
You need to validate the conceptual schema definition language (CSDL), store schema definition
language (SSDL), and mapping specification language (MSL) files.
Which Entity Data Model tool can you use? (Each correct answer presents a complete solution.
Choose all that apply.)
A.
B.
C.
D.

EDM Generator (EdmGen.exe)


ADO.NET Entity Data Model Designer
Entity Data Model Wizard
Update Model Wizard

Answer: AB
Explanation:
EdmGen.exe (http://msdn.microsoft.com/en-us/library/cc716721.aspx)
ADO.Net Entity Data Model Designer
(http://msdn.microsoft.com/enus/library/vstudio/cc716685(v=vs.100).aspx)
The Entity Data Model wizard creates the .edmx files.
It does not validate the CSDL, SSDL or MSL files.
The Update Model wizard updates the .edmx file after changes have been made.
It does not validate the CSDL, SSDL or MSL files.

QUESTION 2
Drag and Drop Question
You are developing an ASP.NET Web API action method.
The action method must return the following JSON in the message body.
{ " Name ":" Fabrikam", "Vendor Id": 9823, "Items": ["Apples",
"Oranges"] }
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.)

Answer:

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

QUESTION 3
You are designing an ASP.NET Web API application.
You need to select an HTTP verb to allow blog administrators to moderate a comment.
Which HTTP verb should you use?
A.
B.
C.
D.

GET
POST
DELETE
PUT

Answer: D

QUESTION 4
Drag and Drop Question
You are developing an ASP.NET Web API application that will be consumed by a web browser
via a composite application that is served from another web domain.
You need to configure the Web API. What should you do? (To answer, drag the appropriate XML
elements to the correct location or locations in the answer area. Each XML element 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.)

Answer:

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

QUESTION 5
You are planning to migrate websites from IIS 6 to IIS 7.5.
You do not have access to SSH or a VPN.
You need to select a deployment tool to securely migrate the websites.
Which tool should you use?
A.
B.
C.
D.

RoboCopy
Web Deploy
Microsoft command-line FTP
xCopy

Answer: B

QUESTION 6
Drag and Drop Question
You are developing an ASP.NET MVC Web API application.
The method names of the Web API must match naming guidelines for RESTful services.
You need to create methods to support standard insert, select, update, and delete operations in
an HTTP service.
What should you do? (To answer, drag the appropriate HTTP methods to the correct row in the
table in the answer area. Each HTTP method 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.)

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

Answer:

QUESTION 7
You are developing an ASP.NET MVC application.
Applications can be deployed to remote servers only by administrators who have elevated
privileges.

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

The administrators do not have access to Visual Studio 2012.


You need to select a deployment tool to deploy the application to remote servers for testing.
Which tool should you use?
A.
B.
C.
D.

Copy Web Site Tool


One-Click Publish
Publish Web Site Tool
Web Deployment Package

Answer: D

QUESTION 8
You are developing an ASP.NET MVC web application that contains the following HTML.
<table id= "customer" ></table>
You also have an ASP.NET Web API application that contains a call for retrieving customers.
You must send and retrieve the data in the most compact format possible.
You need to update the HTML for the customers table to contain data from the Web API
application.
Which script segment should you use?

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

A.
B.
C.
D.

Option A
Option B
Option C
Option D

Answer: A

QUESTION 9
Drag and Drop Question
You are developing an ASP.NET MVC Web API image management application.
The application must meet the following requirements:
- It must send or receive image data without the use of a buffer.
- It must allow up to 4 MB of image data to be received.
- It must allow up to 3 MB of image 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.)

Answer:

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

QUESTION 10
You are preparing to develop a set of libraries for a company.
The libraries must be shared across the company.
You need to create a remote NuGet feed that exposes the libraries.
What should you do? (Each answer presents part of the solution. Choose all that apply.)
A. Install the NuGet.Feed Package.
B. Install the NuGet.Server Package.
C. Configure the Packages folder located in the system.webserver section of the web
application's Web.config.
D. Create a new Empty Web Site in Visual Studio 2012.
E. Configure the Packages folder located in the appSettings section of the web application's
Web.config.
F. Add packages to the Packages folder.
G. Create a new Empty Web Application in Visual Studio 2012.
Answer: BEFG

QUESTION 11
You develop an ASP.NET MVC application that is secured by using SSL.
You are ready to deploy the application to production.
The deployment package must include the installation of the SSL certificate.
You need to configure the deployment package to meet the requirement.
What should you do?
A.
B.
C.
D.

Create a web publish pipeline target file with a custom web deploy target.
In the Package/Publish settings of the project, select the All Files in this project option.
Extend the CopyAllFilesToSingleFolder target in the project file.
In the Build Events settings of the project, configure a pre-build event to include the SSL

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

certificate.
Answer: A

QUESTION 12
You are developing a library to support multiple ASP.NET MVC web applications on a shared
server.
The library provides implementations of security algorithms.
If a problem with any of the security algorithms is discovered, a new version of the library must be
created and deployed.
Application downtime during the update must be minimized.
You need to ensure that the new version of the library will be used by all applications as soon as
possible.
What should you do?
A. Build the web applications and include the security assembly as an embedded resource.
When an update is needed, copy the new assembly to the bin directory for the application.
B. Sign all assemblies in each application with the same key used to sign the security assembly.
When an update is needed, create a new key pair and re-sign all assemblies.
C. Build the security assembly as a netmodule in a shared location.
Use the assembly linker to merge the netmodule into the assemblies for the application.
When an update is needed, update the netmodule in the shared location.
D. Install the security assembly in the Global Assembly Cache (GAC).
When an update is needed, update the assembly in the GAC.
Answer: D

QUESTION 13
You are developing an application in Visual Studio 2012 to display student information.
The application contains the following Entity Framework model.
The application contains a WCF data service named DirectoryService.svc.
You need to create a query expression to display all of the grades for students whose first name
is "John".
How should you build the expression?

A. http://localhost:54946/DirectoryService.svc/Students?$filter=FirstName eq 'John' &


$expand=Grades
B. http://localhost:54946/DirectoryService.svc/Students?$filter=FirstName eq 'John'/Grades
C. http://localhost:54946/DirectoryService.svc/Students?$filter=FirstName = 'John' &
$expand=Grades

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

D. http://localhost:54946/DirectoryService.svc/Grades/Students?$filter=FirstName eq 'John'
Answer: A

QUESTION 14
Drag and Drop Question
You are developing a WCF Data Services service in Visual Studio 2012 to display movie
information from a SQL Server database that changes every 24 hours.
The service is defined in the following class.

The application contains the following Entity Framework model.

The service must only return data for movies that are currently in theaters. You need to add a
method to the MovieService class to filter the data. How should you build the method? (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.)

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

Answer:

QUESTION 15
You are developing an ASP.NET MVC application that reads and writes data from a SQL Server
database.
You need to prevent the application from reading data that is locked by other transactions.
You also need to prevent exclusive range locks.
Which isolation level should you use?
A.
B.
C.
D.

ReadCommitted
Serializable
Repeatable
ReadUncommitted

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

Answer: A
Explanation:
SQL Server Isolation Levels
(http://msdn.microsoft.com/en-us/library/ms189122(v=sql.105).aspx)
(http://msdn.microsoft.com/en-us/library/ms173763.aspx)

QUESTION 16
Drag and Drop Question
You are developing a Windows Azure based web application that provides users the ability to rent
training videos.
The application is deployed to hosted services in Asia and Europe.
The web application must meet the following requirements:
- Video files are large and must be able to be streamed.
- Streaming videos requires low latency network connections.
- Rental data contains structured information about the user and the
video.
- Rental permissions are checked every five seconds during video
playback.
You need to recommend storage architecture for the application.
What should you do? (To answer, drag the appropriate technologies to the correct location or
locations in the answer area. Each technology 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.)

Answer:

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

QUESTION 17
Drag and Drop Question
You are developing a self-hosted WCF service that returns stock market information.
The service must be discoverable by any client application.
You need to build the service host. How should you build the host? (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.)

Answer:

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

QUESTION 18
You are developing a WCF service that compares several data sources.
The service takes a long time to complete.
The service must meet the following requirements:
- The client must be able to continue processing while the service is
running.
- The service must initiate communication with the client application
when processing is complete.
You need to choose a message pattern to meet the requirements.
Which message pattern should you choose?
A.
B.
C.
D.

One Way
Streaming
Duplex
Request/Reply

Answer: C

QUESTION 19
You are developing a WCF service.
A new service instance must be created for each client session.
You need to choose an instancing mode.
Which instance mode should you use?
A.
B.
C.
D.
E.

PerCall
Single
Multiple
PerSession
PerRequest

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

Answer: D
Explanation:
WCF Instancing Modes (http://msdn.microsoft.com/en-us/library/ms731193.aspx)

QUESTION 20
Drag and Drop Question
You are developing a WCF service.
You need to implement transport security by using NTLM authentication and NetTcpBindings.
Which configuration values should you use? (To answer, drag the appropriate configuration
values to the correct location or locations in the answer area. Each configuration value 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.)

Answer:

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

QUESTION 21
Drag and Drop Question
You are developing a WCF service.
The service will stream messages to clients on the internal network.
You must use Windows Authentication, and all messages must be binary encoded.
You need to configure the service.
What should you do? (To answer, drag the appropriate elements to the correct location or
locations in the answer area. Each element 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.)

Answer:

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

QUESTION 22
Drag and Drop Question
You are developing a WCF service.
The WCF service requires implementations of the new data contracts to validate against the old
schema.
You need to develop a new data contract without breaking current functionality.
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.)

Answer:

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

QUESTION 23
You are developing a WCF service.
A new service instance must be created for each client request.
You need to choose an instancing mode.
Which instancing mode should you use?
A.
B.
C.
D.
E.

Single
PerRequest
PerCall
Multiple
PerSession

Answer: C

QUESTION 24
Drag and Drop Question
You are creating a WCF service.
The service endpoints must be exposed to the Windows 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.
How should you modify the file? (To answer, drag the appropriate attributes to the correct location
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.)

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

Answer:

QUESTION 25
Hotspot Question
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).

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

Answer:

QUESTION 26
Drag and Drop Question
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.)

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

Answer:

QUESTION 27
Drag and Drop Question
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.

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

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.)

Answer:

QUESTION 28
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?
A.
B.
C.
D.

PUT
DELETE
POST
GET

Answer: B

QUESTION 29
Drag and Drop Question
You are developing an ASP.NET Web API application for currency conversion that will be
consumed by a web browser by using a composite application that is served from another web
domain.
You need to configure the Web API.
What should you do? (To answer, drag the appropriate XML elements to the correct location or
locations in the answer area. Each XML element 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.)

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

Answer:

QUESTION 30
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?

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

A.
B.
C.
D.

Option A
Option B
Option C
Option D

Answer: A

QUESTION 31
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.
A.
B.
C.
D.

ReadUncommitted
Repeatable
Serializable
ReadCommitted

Answer: C
Explanation:
SQL Server Isolation Levels
(http://msdn.microsoft.com/en-us/library/ms189122(v=sql.105).aspx)
(http://msdn.microsoft.com/en-us/library/ms173763.aspx)

QUESTION 32
Hotspot Question
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

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

menu item in the answer area.)

Answer:

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

QUESTION 33
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?
A.
B.
C.
D.

Publish Web Site Tool


Web Deployment Package
One-Click Publish
Deployment Package Editor

Answer: B

Case Study 1 - Flight Information (QUESTION 34 - QUESTION 48)


Background
You are developing a flight information consolidation service.
The service retrieves flight information from a number of sources and combines them into a single
data set.
The consolidated flight information is stored in a SQL Server database.
Customers can query and retrieve the data by using a REST API provided by the service.
The service also offers access to historical flight information.
The historical flight information can be filtered and queried in an ad hoc manner.
The service runs on a Windows Azure Web Role. SSL is not used.

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

Business Requirements
- A new data source for historical flight information is being
developed by a contractor located on another continent.
- If a time zone is not specified, then it should be interpreted as
Coordinated Universal Time (UTC).
- When you upgrade a service from a staging deployment to a production
deployment, the time that the service is unavailable must be minimized.
- The default port must be used for HTTP.
Technical Requirements
The existing sources of flight information and the mechanism of exchange are listed below.
- Blue Yonder Airlines provides flight information in an XML file.
- Consolidated Messenger provides flight information in a Microsoft
Access database that is uploaded every 12 hours to the service using
SFTP. The company uses port 22 for SFTP.
- Margie's Travel provides and consumes flight information using
serialized ADO.NET DataSets. Data is periodically synced between the
service and Margie's Travel.
- Trey Research provides data from multiple sources serialized in
proprietary binary formats. The data must be read by using .NET
assemblies provided by Trey Research. The assemblies use a common set
of dependencies.
- The current version of the Trey Research assemblies is 1.2.0.0. All
assemblies provided by Trey Research are signed with a key pair
contained in a file named Trey.snk, which Trey Research also supplies.
- The application specification requires that any third-party
assemblies must have strong names.
Application Structure

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

QUESTION 34
Drag and Drop Question
You need to configure the Windows Azure service definition to enable Consolidated Messenger
to upload files.
What should you do? (To answer, drag the appropriate configuration items to the correct location
or locations. Each configuration item 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.)

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

Answer:

QUESTION 35
Hotspot Question
You need to deploy the application to the Windows Azure production environment to meet the
business requirements.
What should you do? (To answer, select the appropriate button in the answer area.)

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

Answer:

QUESTION 36
You need to recommend a data access technology to the contractor to retrieve data from the new

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

data source.
Which data access technology should you recommend?
A.
B.
C.
D.

LINQ to XML
ADO.NET Entity Framework
ADO.NET DataSets
WCF Data Services

Answer: D

QUESTION 37
Drag and Drop Question
Flight information data provided by Margie's Travel is updated both locally and remotely.
When the data is synced, all changes need to be merged together without causing any data loss
or corruption.
You need to implement the Sync() method in the MargiesTravelSync.es file.
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.)

Answer:

QUESTION 38
Drag and Drop Question
Historical flight information data will be stored in Windows Azure Table Storage using the
FlightInfo class as the table entity.
There are millions of entries in the table.
Queries for historical flight information specify a set of airlines to search and whether the query
should return only late flights.
Results should be ordered by flight name.

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

You need to specify which properties of the FlightInfo class should be used at the partition and
row keys to ensure that query results are returned as quickly as possible.
What should you do? (To answer, drag the appropriate properties to the correct location or
locations in the answer area. Each property 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.)

Answer:

QUESTION 39
Drag and Drop Question
The service has been deployed to Windows Azure.
Trey Research has provided version 1.3.0.0 of the assembly to support a change in the
serialization format.
The service must remain available during the transition to the new serialization format.
You need to ensure that the service is using the new assembly.
Which configuration setting should you add to the web.config? (To answer, drag the appropriate
configuration elements to the correct location or locations in the answer area. Each configuration
element 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.)

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

Answer:

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

Explanation:
http://msdn.microsoft.com/en-us/library/7wd6ex19.aspx

QUESTION 40
Errors occasionally occur when saving data using the FlightInfoContext ADO.NET Entity
Framework context.
Updates to the data are being lost when an error occurs.
You need to ensure that data is still saved when an error occurs by retrying the operation.
No more than five retries should be performed.
Which code segment should you use as the body of the SaveChanges() method in the
FlightInfoContext.es file?

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

A.
B.
C.
D.

Option A
Option B
Option C
Option D

Answer: A

QUESTION 41
You are adding a new REST service endpoint to the FlightDataController controller.
It returns flights from the consolidated data sources only for flights that are late.
You need to write a LINQ to Entities query to extract the required data.
Which code segment should you use?

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

A.
B.
C.
D.

Option A
Option B
Option C
Option D

Answer: D
Explanation:
D is right because you send result as REST so if you use "AsQueryable" the result is deferred to
the next enumeration of your result.
D is not optimized but will works.
A will break at runtime.
Credits to Rem

QUESTION 42
Data provided by Consolidated Messenger is cached in the HttpContext.Cache object.
You need to ensure that the cache is correctly updated when new data arrives.
What should you do?
A.
B.
C.
D.

Ensure that the EffectivePrivateBytesLimit value is greater than the size of the database file.
Change the sliding expiration of the cache item to 12 hours.
Use the SqlCacheDependency type configured with a connection string to the database file.
Use the CacheDependency type configured to monitor the SFTP target folder.

Answer: D

QUESTION 43
You need to load flight information provided by Consolidated Messenger.
Which should you use?

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

A.
B.
C.
D.

SQL Server Data Transformation Services (DTS)


EntityTransaction and EntityCommand
Office Open XML
OleDbConnection and OleDbDataReader

Answer: D

QUESTION 44
Drag and Drop Question
You need to parse flight information from Blue Yonder Airlines.
The content of the XML file is shown below.

Some airlines do not specify the timezone of the arrival time.


If the timezone is not specified, then it should be interpreted per the business requirements.
You need to implement the LoadFlights() and Parse() methods of the BlueYonderLoader class.
What should you do? (To answer, drag the appropriate code segments to the correct location in
the answer area. Each 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.)

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

Answer:

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

QUESTION 45
You are adding a new REST service endpoint to the FlightDataController controller that returns
the total number of seats for each airline.
You need to write a LINQ to Entities query to extract the required data.
Which code segment should you use?

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

A.
B.
C.
D.

Option A
Option B
Option C
Option D

Answer: D

QUESTION 46
Historical flight information data will be stored in Windows Azure Table Storage using the
FlightInfo class as the table entity.
There are millions of entries in the table.
Queries for historical flight information specify a set of airlines to search and whether the query
should return only late flights.
Results should be ordered by flight name.
You need to specify which properties of the FlightInfo class should be used at the partition and

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

row keys to ensure that query results are returned as quickly as possible.
What should you do? (Each correct answer presents part of the solution. Choose all that apply.)
A.
B.
C.
D.
E.
F.

Use the WasLate property as the row key.


Use the Airline property as the row key.
Use the WasLate property as the partition key
Use the Arrival property as the row key.
Use the Airline property as the partition key.
Use the Flight property as the row key.

Answer: EF

QUESTION 47
Transformed historical flight information provided by the RemoteDataStream() method must be
written to the response stream as a series of XML elements named Flight within a root element
named Flights.
Each Flight element has a child element named FlightName that contains the flight name that
starts with the two-letter airline prefix.
You need to implement the StreamHistoricalFlights() method so that it minimizes the amount of
memory allocated.
Which code segment should you use as the body of the StreamHistoricalFlights() method in the
HistoricalDataLoader.es file?

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

A.
B.
C.
D.

Option A
Option B
Option C
Option D

Answer: D
Explanation:
http://msdn.microsoft.com/en-us/library/system.xml.linq.xstreamingelement.aspx
http://msdn.microsoft.com/en-us/library/bb551307.aspx

QUESTION 48
Errors occasionally occur when saving data using the FlightlnfoContext ADO.NET Entity
Framework context.
Updates to the data are being lost when an error occurs.
You need to ensure that data is still saved when an error occurs by retrying the operation.
No more than five retries should be performed.
With which code segment should you replace the body of the SaveChanges() method in the
FlightInfoContext.es file?

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

A.
B.
C.
D.

Option A
Option B
Option C
Option D

Answer: C
Explanation:
EntitySqlException: Represents errors that occur when parsing Entity SQL command text.
This exception is thrown when syntactic or semantic rules are violated.
SqlException: The exception that is thrown when SQL Server returns a warning or error.
This class cannot be inherited.
EntityCommandExecutionException : Represents errors that occur when the underlying storage
provider could not execute the specified command.
This exception usually wraps a provider-specific exception.

Case Study 2 - ASP.NET MVC (QUESTION 49 - QUESTION 63)


Background
You are developing an ASP.NET MVC application in Visual Studio 2012 that will be used to
process orders.
Business Requirements
The application contains the following three pages.
- A page that queries an external database for orders that are ready to
be processed. The user can then process the order.
- A page to view processed orders.
- A page to view vendor information.
The application consumes three WCF services to retrieve external data.
Technical Requirements
Visual Studio Solution:
The solution contains the following four projects.
- ExternalQueue: A WCF service project used to communicate with the
external order database.
- OrderProcessor: An ASP.NET MVC project used for order processing and
logging order metadata.
- OrderUpload: A WCF service project used to submit order data to an
external data source.
- Shipping: A WCF service project used to acquire shipping information.
ExternalQueue Project:
Entity Framework is used for data access.
The entities are defined in the ExternalOrders.edmx file as shown in the following diagram.

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

The project contains two services defined in the following files.


- IExternalQueueService.es
- ExternalQueueService.svc.
The ExternalQueue.Helpers namespace contains a definition for a class named OrderNotFound
Exception.
OrderProcessor Project:
Entity Framework is used for data access.
The entities are defined in the ProcessedOrders.edmx file as shown in the following diagram.

The classes are contained in the OrderProcessor.Entities namespace.


The project contains the following two controllers.
- InboundQueueController.es
- ProcessedOrderController.es
WCF service proxies to the ExternalQueue, Shipping and OrderUpload services have been
generated by using the command prompt.
The ExecuteCommandProcedure() method in the ExternalQueueService.svc file must run
asynchronously.
The ProcessedOrderController controller has the following requirements.
The GetVendorPolicy() method must enforce a 10 minute absolute cache expiration policy.
The GetProcessedOrders() method must return a view of the 10 most recently processed orders.

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

OrderUpload Project:
The project contains two services defined in the following files.
- IUploadCallbackService.es
- UploadCallbackService.svc
Data Access is maintained in a file named UploadOrder.es.
Shipping Project:
Entity Framework is used for data access.
The entities are defined in the ExternalOrders.edmx file as shown in the following diagram.

The Custom Tool property for ExternalOrders.edmx has been removed. POCO classes for the
Entity Model are located in the ShippingAddress.es file.
The POCO entity must be loaded by using lazy loading.
The project contains two services defined in the following files.
- IShippingService.es
- ShippingService.svc.
The IShippingService contract must contain an operation that receives an order number as a
parameter.
The operation must return a class named ShippingInfo that inherits from a class named State.
Application Structure

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

QUESTION 49
The QueueDetail entity type must inherit from the InboundQueue entity type in the ExternalQueue
service project using table-per-type inheritance.
You need to modify the entities in the designer.
What should you do? (Each correct answer presents part of the solution. Choose all that apply.)
A.
B.
C.
D.
E.
F.

Remove the OrderNum property in InboundQueue.


Remove the OrderNum property in QueueDetail.
Set the QueueDetail BaseType to InboundQueue.
Remove the association between the entities.
Right-click the entities and validate the table mapping.
Set the InboundQueue BaseType to QueueDetail.

Answer: BCDE
Explanation:
http://www.robbagby.com/entity-framework/entity-framework-modeling-table-per-type-inheritance/

QUESTION 50
Drag and Drop Question
The GetVendorPolicy() private method in the ProcessedOrderController controller is returning a
CacheItemPolicy object with default values.
The returned policy must expire if the external file located at C:\Triggers\VendorTrigger.txt has
been modified or the timeout outlined in the technical requirements is reached.
You need to return the policy.
How should you build the method? (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

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

content.)

Answer:

QUESTION 51
The GetExternalOrder() method in the ExternalQueueService service is throwing a runtime error.
The method must query the database for a record that matches the orderNum parameter passed
to the method.
You need to modify the queryString string to retrieve the record.
With which code segment should you replace line EQ64?

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

A.
B.
C.
D.

Option A
Option B
Option C
Option D

Answer: A

QUESTION 52
Drag and Drop Question
You add a class named ShippingInfo.
You need to modify the IShippingService interface and the ShippingInfo class to meet the
technical 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.)

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

Answer:

QUESTION 53
Drag and Drop Question
You need to create the ShippingContext class in the ShippingAddress.es file 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.)

Answer:

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

QUESTION 54
You need to modify the ExecuteCommandProcedure() method to meet the technical
requirements.
Which code segment should you use?

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

A.
B.
C.
D.

Option A
Option B
Option C
Option D

Answer: A

QUESTION 55
Drag and Drop Question
You need to complete the GetProcessedOrders() action in the ProcessedOrderController
controller 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.)

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

Answer:

QUESTION 56
Drag and Drop Question
The GetQueueItems() action in the InboundQueueController controller is not populating the view
with data.
The action must populate the view with data by calling the GetExternalOrders() method in the
ExternalQueueService service using the ChannelFactory class.
You need to modify the action to populate the view with data.
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.)

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

Answer:

QUESTION 57
The DeleteExternalOrder() method in the ExternalQueueService service is not throwing a
FaultException exception as defined by the FaultContractAttribute attribute in the
IExternalQueueService.cs file.
You need to throw the FaultException exception.
Which code segments can you insert at line EQ45 to achieve this goal? (Each correct answer
presents a complete solution. Chose all that apply)

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

A.
B.
C.
D.

Option A
Option B
Option C
Option D

Answer: BC

QUESTION 58
Drag and Drop Question
The GetExternalOrders() method must use members of the EntityClient namespace to query the
database for all records in the InboundQueue entity.
You need to modify the GetExternalOrders() method to return the correct data.
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.)

Answer:

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

QUESTION 59
You need to regenerate the service proxies to include task-based asynchronous method
signatures.
Which command should you use?
A. aspnet_regiis.exe /t:code http://localhost:62965/
UploadCallbackService.svc
B. svcutil.exe /t:code http://localhost:62965/
UploadCallbackService.svc
C. aspnet_compiler.exe /t:code http://localhost:62965/
UploadCallbackService.svc
D. aspnet_regiis.exe /t:code http://localhost:62965/
UploadService.svc
E. svcutil.exe /t:code http://localhost:62965/
UploadService.svc
Answer: B
Explanation:
http://msdn.microsoft.com/en-us/library/aa347733.aspx

QUESTION 60
The DeleteExternalOrder() method in the ExternalQueueService service is not throwing a
FaultException exception as defined by the FaultContractAttribute attribute in the
IExternatQueueService.cs file.
You need to throw the FaultException exception.
Which code segment can you insert at line EQ45 to achieve this goal? (Each correct answer
presents a complete solution. Chose all that apply.)

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

A.
B.
C.
D.

Option A
Option B
Option C
Option D

Answer: C

QUESTION 61
Drag and Drop Question
You need to modify the ExecuteCommandProcedure() method to meet the technical
requirements.
Which code segment should you use?

Answer:

QUESTION 62

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

The GetVendors() action in the ProcessedOrderController controller is querying the database


each time it is run.
The GetVendors() action must query the database only if the cache is null.
You need to add code to the action at line PC33 to cache the data.
Which code segment can you use? (Each correct answer presents a complete solution. Choose
all that apply.)
A.
B.
C.
D.

cache.Set(new CacheItem("vendorKey", vendors), GetVendorPolicy());


cache.Add("vendors", vendors, new CacheItemPolicy());
cache.Add(new CacheItem("vendorKey", vendors) , GetVendorPolicy());
cache.AddOrGetExisting("vendorKey", context, new CacheItemPolicy());

Answer: AC

QUESTION 63
Drag and Drop Question
The UploadOrder() method in the UploadCallbackService service is not implementing the
callback behavior defined in the IUploadCallBackService interface.
You need to modify the class to implement the required callback behavior.
What should you do? (To answer, drag the appropriate code segments to the correct location or
locations in the answer area. Each code segments 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.)

Answer:

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

Case Study 3 - Online Bookstore (QUESTION 64 - QUESTION 78)


Background
You are developing an online bookstore web application that will be used by your company's
customers.
Technical Requirements
General requirements:
- The web store application must be an ASP.NET MVC application written
in Visual Studio.
- The application must connect to a Microsoft SQL database.
- The GetTop100Books() method is mission critical and must return data
as quickly as possible.
It should take advantage of fast, forward-only, read-only methods of
reading data.
- The ImportBooks() method must keep a copy of the data that can be
accessed while new books are being imported without blocking reads.
- The Create MonthlyTotalsReport() method must lock the data and
prevent others from updating or inserting new rows until complete.
- The college textbook area of the web application must get data from a
daily updated CSV file.
- The children's book area of the web application must get data
directly from a local database.
It must use a connection string. It must also support access to the
stored procedures on the database. Further, it is required to have
strongly typed objects. Finally, it will require access to databases
from multiple vendors and needs to support more than one-to-one mapping
of database tables.
- The cookbook functionality is contained within a client-side
application that must connect to the server using HTTP and requires
access to the data using JavaScript.
- The BookApiController class must have a method that is able to
perform ad-hoc queries using OData.
The RESTful API of the bookstore must expose the following endpoints.

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

Application Structure

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

PurchaseOrders.xml

FeaturedBooks.xml

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

QUESTION 64
You need to choose the appropriate data access technology for the children's book area of the
web application.
Which data access technology should you choose?
A.
B.
C.
D.

Web Service
LINQ to SQL
ADO.NET Entity Framework
WCF Data Services

Answer: C

QUESTION 65
You need to update the CreateMonthlyTotalsReports() method to use database transactions.
Which code segment should you use?
A.
B.
C.
D.

SqlConnection.BeginTransaction(IsolationLevel.ReadCommitted);
SqlConnection.BeginTransaction(IsolationLevel.ReadUnconwited);
SqlConnection.BeginTransaction(IsolationLevel.Chaos);
SqlConnection.BeginTransaction(IsolationLevel.Serializable);

Answer: D
Explanation:
* Scenario: The Create MonthlyTotalsReport() method must lock the data and prevent others
from updating or inserting new rows until complete.
* Serializable: A range lock is placed on the DataSet, preventing other users from updating or
inserting rows into the dataset until the transaction is complete.

QUESTION 66
The PurchaseOrders.xml file contains all of the purchase orders for the day.
You need to query the XML file for all of the shipping addresses.
Which code segment should you use?

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

A.
B.
C.
D.

Option A
Option B
Option C
Option D

Answer: B

QUESTION 67
Drag and Drop Question
An XML file must be produced by the SaveFeaturedBooks() method of the Book class.
The schema of the resulting XML file must be identical to the FeaturedBooks.xml file.
You need to write the code to produce the file.
You have the following code:

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

Which code segments should you include in Target 1, Target 2 and Target 3 to complete the
code? (To answer, drag the appropriate code segments to the correct targets 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)

Answer:

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

QUESTION 68
You need to choose the appropriate data access strategy for the college textbook area of the web
application.
Which data access technology should you implement?
A.
B.
C.
D.

ADO.NET
Entity Data Model (EDM)
WCF Data Services
LINQ to SQL

Answer: A
Explanation:
* Scenario: The college textbook area of the web application must get data from a daily updated
CSV file.
* ADO.NET reads the CSV file in a very similar way as table in database.

QUESTION 69
You need to configure the server to self-host the bookstore's Web API application.
Which code segment should you use?

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

A.
B.
C.
D.

Option A
Option B
Option C
Option D

Answer: C
Explanation:
MapHttpRoute Method
Maps the specified route template.
Use the option with "api/...

QUESTION 70
You need to return the list of the top 100 books for the GetTopBooks() method.
Which type should you use to retrieve the data?
A.
B.
C.
D.

SqlDataReader
DataSet
DataTable
Data View

Answer: A

QUESTION 71
You need to choose the appropriate data access technology for the cookbook area of the web
application.
Which data access technology should you choose?
A.
B.
C.
D.

WCF Data Services


LINQ to SQL
Entity Framework
ADO.NET

Answer: A
Explanation:
* Scenario: The cookbook functionality is contained within a client-side application that must
connect to the server using HTTP and requires access to the data using JavaScript.
* WCF Data Services (formerly known as "ADO.NET Data Services") is a component of the .NET
Framework that enables you to create services that use the Open Data Protocol (OData) to
expose and consume data over the Web or intranet by using the semantics of representational
state transfer (REST). OData exposes data as resources that are addressable by URIs. Data is
accessed and changed by using standard HTTP verbs of GET, PUT, POST, and DELETE
* WCF Data Services uses the OData protocol for addressing and updating resources. In this
way, you can access these services from any client that supports OData. OData enables you to
request and write data to resources by using well-known transfer formats:
Atom, a set of standards for exchanging and updating data as XML, and JavaScript Object
Notation (JSON), a text-based data exchange format used extensively in AJAX application.

QUESTION 72
You are preparing to write the data access code for the children's book area of the web site.
You need to review the requirements and identify the appropriate data access technology.

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

What should you do?


A.
B.
C.
D.

Use ADO.NET Entity Framework.


Use a Web Service.
Use the WCF Data Services.
Use LINQ to SQL.

Answer: A

QUESTION 73
The PurchaseOrders.xml file contains all of the purchase orders for the day.
You need to query the XML file for all of the billing addresses.
Which code segment should you use?

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

A.
B.
C.
D.

Option A
Option B
Option C
Option D

Answer: D

QUESTION 74
You need to create an OData filter expression that returns books that match the following
characteristics:
- Published after 1/1/2000
- Have "Science" as the first word
Which filter statement should you use?

A.
B.
C.
D.

Option A
Option B
Option C
Option D

Answer: D
Explanation:
* gt
Greater than
Example:
filter= Entry_No gt 610
Query on GLEntry service. Returns entry numbers 611 and higher.
* startswith
filter=startswith(Name, 'S')
Query on Customer service. Returns all customers names beginning with "S".

QUESTION 75
You need to update the ImportBooks() method to use database transactions.
Which code segment should you use?
A. SqlConnection.BeginTransaction(IsolationLevel.RepeatableRead);

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

B. SqlConnection.BeginTransaction(IsolationLeve.ReadUnconvnited);
C. SqlConneetion.BeginTransaction(IsolationLevel.Serializable);
D. SqlConnection.BeginTransaction(IsolationLevel.Snapshot);
Answer: B
Explanation:
* scenario: The ImportBooks() method must keep a copy of the data that can be accessed while
new books are being imported without blocking reads.
* ReadUncommitted: A dirty read is possible, meaning that no shared locks are issued and no
exclusive locks are honored.

QUESTION 76
You need to implement the Get() method in the bookstore Web API application to be able to find
books by using an ad hoc query.
Which method should you use?

A.
B.
C.
D.

Option A
Option B
Option C
Option D

Answer: D

QUESTION 77

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

Drag and Drop Question


You need to update the GetBook() method to retrieve book data by using ADO.NET.
You have the following code:

Which code segments should you include in Target 1, Target 2, Target 3, Target 4 and Target 5
to complete the code? (To answer, drag the appropriate code segments to the correct targets 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.)

Answer:

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

QUESTION 78
You need to create an OData query expression to return the ten books with the largest number of
sales.

Which query expression should you use?


A.
B.
C.
D.

Option A
Option B
Option C
Option D

Answer: C
Explanation:
Order by desc(ending) to get the posts with the largest number of sales at the top. Specify to
display the top 10 posts.

QUESTION 79
Drag and Drop Question
You are developing an ASP.NET MVC Web API application.

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

The methods of the Web API must return details about the result of the operation.
You need to create methods to update and delete products.
You have the following code:

Which code segments should you include in Target 1, Target 2, Target 3, Target 4 and Target 5
to complete the code? (To answer, drag the appropriate code segments to the correct targets 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.)

Answer:

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

QUESTION 80
Hotspot Question
You are developing an application.
The application must be deployed from Team Foundation Server after a successful build is
completed.
The Process tab of the Build Definition screen is shown in the exhibit. (Click the Exhibit button.)

You need to configure the automated deployment.


In which section should you define the parameters for the automated deployment? (To answer,
select the appropriate section in the answer area.)

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

Answer:

QUESTION 81
Drag and Drop Question
You are developing an ASP.NET Web API for a home inventory management system.
You need to limit access to users with IP addresses based only in the United States.
You have the following code:

Which code segments should you include in Target 1 and Target 2 to complete the code? (To
answer, drag the appropriate code segments to the correct targets 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.)

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

Answer:

QUESTION 82
Drag and Drop Question
You are developing an Internet-based ASP.NET Web API application that manages pet data.
You install an SSL certificate on the web server to encrypt calls to the API.
You create a class named PetAuthorization, which inherits from a type named AuthorizeAttribute,
and implements the OnAuthorization() method.
You need to implement basic authentication for the API.
What should you do? (To answer, drag the appropriate words to the correct targets in the answer
area. Words 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)

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

Answer:

QUESTION 83
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 customers.
Customers are filtered on Country and, if provided, on CompanyName.
You have an Entity Framework context named db.
The Customer class is shown below.

You need to execute a single deferred query to return the filtered list of customers.
Which code segment should you use?

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

A.
B.
C.
D.

Option A
Option B
Option C
Option D

Answer: C

QUESTION 84
Drag and Drop Question
You are developing a self-hosted WCF service to display data about books.
The solution contains a service named BookService that implements the IBookService interface.
You need to expose the metadata in the service host programmatically.
You have the following code:

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

Which code segments should you include in Target 1, Target 2, Target 3, Target 4 and Target 5
to build the service host? (To answer, drag the appropriate code segments to the correct targets
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.)

Answer:

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

QUESTION 85
You are developing an ASP.NET MVC application.
The application is a loan 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 loans along with rate information.
Lazy loading has been disabled.
The Loan class is shown below.

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

A.
B.
C.
D.

Option A
Option B
Option C
Option D

Answer: C

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

QUESTION 86
You are developing a library management application that uses the ADO.NET Entity Framework
against a SQL Server database.
The application has a method that returns check outs filtered by date.
The Book class is shown below.

You must filter the data on the SQL server before it is returned to the application server.
You need to return books checked out more recently than the entered date.
Which code segment should you use?

A.
B.
C.
D.

Option A
Option B
Option C
Option D

Answer: A
Explanation:
The difference is that IQueryable<T> is the interface that allows LINQ-to-SQL (LINQ.-to- anything
really) to work. So if you further refine your query on an IQueryable<T>, that query will be
executed in the database, if possible.
For the IEnumerable<T> case, it will be LINQ-to-object, meaning that all objects matching the
original query will have to be loaded into memory from the database.

QUESTION 87
Hotspot Question
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.

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

Which settings should you use? (To answer, select the appropriate setting or settings in the
answer area.)

Answer:

QUESTION 88

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

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?
A.
B.
C.
D.

1
2
5
10

Answer: C

QUESTION 89
Hotspot Question
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.)

Answer:

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

QUESTION 90
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?
A.
B.
C.
D.

FastForwardReadOnly
SequentialAccess
SingleResult
SingleRow

Answer: B
Explanation:
SequentialAccess
Provides a way for the DataReader to handle rows that contain columns with large binary values.
Rather than loading the entire row, SequentialAccess enables the DataReader to load data as a
stream.

QUESTION 91
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

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

transmitted.
Which method of the EntityCommand type should you use?
A.
B.
C.
D.

ExecuteScalar
ExecuteDbDataReader
ExecuteReader
ExecuteNonQuery

Answer: A
Explanation:
ExecuteScalar
Executes the command, and returns the first column of the first row in the result set.
Additional columns or rows are ignored.

QUESTION 92
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.

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

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?

A.
B.
C.
D.

Option A
Option B
Option C
Option D

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

Answer: B

QUESTION 93
Drag and Drop Question
You are developing a WCF service application.
The application must meet the following requirements:
- Operations must have 30 second timeouts.
- The service must have a transaction scope.
- Transactions must flow from the client to the server.
You need to write a transactional service contract and implementation class to meet the
requirements.
You have the following code:

Which code segments should you include in Target 1, Target 2, Target 3 and Target 4 to
complete the code? (To answer, drag the appropriate code segments to the correct targets 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.)

Answer:

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

QUESTION 94
Drag and Drop Question
You are developing a WCF service.
You need to configure the web.config file to ensure that metadata is exposed only via the MEX
protocol.
You have the following markup:

Which XML elements should you include in Target 1, Target 2, Target 3 and Target 4 to complete
the markup? (To answer, drag the appropriate XML elements to the correct targets in the answer
area. Each XML element 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.)

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

Answer:

QUESTION 95
Hotspot Question
You are developing a WCF service in Visual Studio 2013 that integrates with the Microsoft Azure
service bus relay.

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

The Azure service bus namespace is named RestaurantServiceBus


You need to obtain the issuer name and secret.
What should you do? (To answer, select the appropriate option in the answer area.)

Answer:

QUESTION 96
Drag and Drop Question
You are developing an ASP.NET MVC Web API application.
The methods of the Web API must return details about the result of the operation.
You need to create a method to add products.
You have the following code:

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

Which code segments should you include in Target 1, Target 2, Target 3, Target 4 and Target 5
to complete the code? (To answer, drag the appropriate code segments to the correct targets 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.)

Answer:

QUESTION 97
You are developing a .NET application that uses the HttpClient type to call an ASP.NET Web API

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

application.
The API call returns a list of customers in JSON format and logs the results.
The URI for the API call is in a variable named address.
You need to make the API call without blocking.
Which code segment should you use?

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

A. Option A
B. Option B
C. Option C

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

D. Option D
Answer: A
Explanation:
Example:
// Create an HttpClient instance
11: HttpClient client = new HttpClient();
12:
13: // Send a request asynchronously continue when complete
14: client.GetAsync(_address).ContinueWith(
15: (requestTask) =>
16: {
17: // Get HTTP response from completed task.
18: HttpResponseMessage response = requestTask.Result;
19:
20: // Check that response was successful or throw exception
21: response.EnsureSuccessStatusCode();
22:
23: // Read response asynchronously as JsonValue and write out top
facts for each country
24: response.Content.ReadAsAsync<JsonArray>().ContinueWith(
25: (readTask) =>

QUESTION 98
Drag and Drop Question
You are developing a .NET application that uses the HttpClient type to access an ASP.NET Web
API application.
You need to add a header to specify that data is returned as JSON.
You have the following code:

Which code segments should you include in Target 1 and Target 2 to complete the code? (To
answer, drag the appropriate code segments to the correct targets 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)

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

Answer:

QUESTION 99
Hotspot Question
You are updating an existing multitenant ASP.NET MVC application for medical clinics.
The application aggressively uses output caching to improve performance by caching content for
36 hours. The application uses a query string parameter named "clinicID" that contains the clinic
that the user is currently viewing.
Users report that they are occasionally seeing data for the wrong clinic.
Users also report that sensitive data is stored in the browser cache folder on their computers.
You need to configure web.config to resolve the reported problems.

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

You have the following markup:

Which markup segments should you include in Target 1, Target 2 and Target 3 to complete the
markup? (To answer, select the correct markup segment from each drop-down list in the answer
area.)

Answer:

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

QUESTION 100
Drag and Drop Question
You have a UI element library.
You need to build a NuGet package to integrate the library into your projects.
What should you do? (To answer, drag the appropriate code elements to the correct location or
locations in the answer area. Each code element 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.)

Answer:

QUESTION 101
Hotspot Question
You are developing a WCF service.
The service must be interoperable with ASP.NET web service clients. In addition, it must have a
time-out of three hours.
You need to configure the service to meet the requirements.
You have the following markup:

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

Which markup segments should you include in Target 1, Target 2, Target 3, Target 4, Target 5,
Target 6 and Target 7 to complete the markup? (To answer, select the appropriate markup
segment from each drop-down list in the answer area.)

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

Answer:

QUESTION 102
Drag and Drop Question
You are configuring a web application for deployment.
You need to create a SetParameters.xml file to configure the IIS application pool.
You have the following markup:

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

Which configuration values should you include in Target 1 and Target 2 to complete the markup?
(To answer, drag the appropriate configuration values to the correct targets in the answer area.
Each configuration value 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.)

Answer:

QUESTION 103
You are developing an ASP.NET MVC application.
The application has a page that updates 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 single database table.
You need to run a single query that updates an image and associated metadata in the database

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

while returning only the number of affected rows.


Which method of the EntityCommand type should you use?
A.
B.
C.
D.

ExecuteNonQuery()
ExecutcScalar()
ExecuteDbDataReader()
ExecuteReader()

Answer: A

QUESTION 104
You are developing a new ASP.NET MVC application that does not have an existing database.
The requirements for the application are not complete, and the SQL data model will likely change.
You need to choose an approach to visually manage a data model.
Which approach should you use?
A.
B.
C.
D.

Physical First
Database First
Code First
Model First

Answer: D
Explanation:
With the model first workflow, you can design a model in a designer.

QUESTION 105
You are preparing to develop a set of libraries that uses large data sets.
The libraries must be shared across an organization and distributed to several servers.
You need to create a remote NuGet feed that exposes the libraries for developer use.
What should you do? (Each answer presents part of the solution. Choose all that apply.)
A. Add packages to the Packages folder.
B. Create a new Empty Web Application in Visual Studio.
C. Configure the Packages folder located in the appSettings section of the web application's
Web.config.
D. Install the NuGet.DataFeed Package.
E. Install the NuGet.Server Package.
F. Create a new Empty Web Site in Visual Studio.
Answer: ABCE
Explanation:
Creating Remote Feeds
You can host a remote (or internal) feed on a server that runs IIS.
Step 1 (B): Create a new Empty Web Application in Visual Studio
Step 2 (E): Install the NuGet.Server Package
Step 3 (C): Configure the Packages folder
Step 4 (A): Add Packages to the Packages folder
Step 5: Deploy and run your brand new Package Feed!
Reference: Hosting Your Own NuGet Feeds

QUESTION 106

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

Drag and Drop Question


You are supporting a WCF data contract that returns a price calculation that can be expanded to
add new data members.
Clients using the old version of the data contract must be supported.
You need to define the data contract so that the data serializer can put unknown data members
into a property bag.
You have the following code:

Which code segments should you include in Target 1 and Target 2 to complete the data contract?
(To answer, drag the appropriate code elements to the correct targets in the answer area. Each
code element 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.)

Answer:

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

QUESTION 107
You are developing an ASP.NET MVC application that reads and writes data from a SQL Server
database.
You need to maintain data integrity including retrieving identical sets across reads in all situations
that use transactions.
Which isolation level should you use?
A.
B.
C.
D.

Repeatable
Serializable
ReadUncommitted
ReadCommitted

Answer: A
Explanation:
REPEATABLE READ
Specifies that statements cannot read data that has been modified but not yet committed by other
transactions and that no other transactions can modify data that has been read by the current
transaction until the current transaction completes.

QUESTION 108
You are developing an ASP.NET MVC web application in Visual Studio 2012.
The application requires several thousand content files.
All content is hosted on the same IIS instance as the application.
You detect performance issues when the application starts.
You need to resolve the performance issues.
What should you do?
A.
B.
C.
D.

Implement HTTP caching in the ASP.NET MVC controllers.


Combine the content files by using ASP.NET MVC bundling.
Install a second IIS instance.
Move the content to a Windows Azure CDN.

Answer: B

QUESTION 109
You are testing an ASP.NET application.
The test plan requires that tests run against the application's business layer.
You need to use the test project template that meets this requirement.
Which template should you use?
A.
B.
C.
D.

Web Test Project


Load Test Project
Unit Test Project
Coded Test Project

Answer: C

QUESTION 110
You are developing an ASP.NET MVC news aggregation application that will be deployed to

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

servers on multiple networks.


The application must be compatible with multiple browsers.
A user can search the website for news articles.
You must track the page number that the user is viewing in search results.
You need to program the location for storing state information about the user's search.
What should you do?
A.
B.
C.
D.

Store search results and page index in Session.


Use Application state to store search terms and page index.
Use QueryString to store search terms and page index.
Store search results and page index in TempData

Answer: C

QUESTION 111
You are developing an ASP.NET MVC application.
The application is deployed in a web farm and is accessed by many users.
The application must handle web server failures gracefully.
The servers in the farm must share the state information.
You need to persist the application state during the session.
What should you implement?
A.
B.
C.
D.

A state server
Cookieless sessions
A web garden on the web servers
An InProc session

Answer: A

QUESTION 112
You are developing an ASP.NET MVC application that displays stock market information.
The stock market information updates frequently and must be displayed in real-time.
You need to eliminate unnecessary header data, minimize latency, and transmit data over a fullduplex connection.
What should you do?
A.
B.
C.
D.

Implement long-running HTTP requests.


Instantiate a MessageChannel object on the client.
Implement WebSockets protocol on the client and the server.
Configure polling from the browser.

Answer: C

QUESTION 113
You are designing a distributed application that runs on the Windows Azure platform.
The application must store a small amount of insecure global information that does not change
frequently.
You need to configure the application to meet the requirements.
Which server-side state management option should you use? (Each correct answer presents a
complete solution. Choose all that apply.)

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

A.
B.
C.
D.

Windows Azure application state


Sql Azure
Profile properties of the Windows Azure application
Windows Azure session state

Answer: BD
Explanation:
SQL Database provides a relational database management system for Windows Azure and is
based on SQL Server technology. With a SQL Database instance, you can easily provision and
deploy relational database solutions to the cloud, and take advantage of a distributed data center
that provides enterprise-class availability, scalability, and security with the benefits of built-in data
protection and self-healing.
Session States in Windows Azure.
If you are a Web developer, you are probably very familiar with managing user state - that is you
are familiar with tracking user activity and actions across several request-response exchanges
that occur in Web applications. Since HTTP is a stateless protocol, developers over the years
have developed all sorts of means to manage state. You'll even find an MSDN page providing
alternatives and recommendations for state management here. Cookies, hidden fields, and query
strings are some client-side options to tracking user state. When it comes to managing that state
on the server-side, most Web developers rely on session objects.

QUESTION 114
You are developing an ASP.NET MVC application.
You need to authenticate clients by using NT LAN Manager (NTLM).
Which authentication method should you implement?
A.
B.
C.
D.

Basic
Windows
Forms
Kerberos

Answer: B

QUESTION 115
You are developing an ASP.NET MVC application.
The application must allow users to enter JavaScript in a feedback text box only.
You need to disable request validation.
What should you do?
A.
B.
C.
D.

Apply and set the CausesClientSideValidation attribute on the text box to FALSE.
Apply and set the ValidateInput attribute on the text box to FALSE.
Use the HttpRequest.Unvalidated property to read the unvalidated form value.
Use the HttpRequest.Form property to read the unvalidated form value.

Answer: C

QUESTION 116
You are developing an ASP.NET MVC application that will be deployed on a web farm.
Passwords must be stored in the web.config file and must not be readable or in a format that is
easily decodable
You need to encrypt the passwords that are stored in the web.config file.

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

Which command-line tool should you use?


A.
B.
C.
D.

Aspnet_regiis.exe
Ngen.exe
Aspnet_merge.exe
EdmGen.exe

Answer: A

QUESTION 117
You are developing an ASP.NET MVC application in Visual Studio 2012.
The application supports multiple cultures.
The application contains three resource files in the Resources directory:
ProductDictionary.resx
ProductDictionary.es.resx
ProductDictionary.fr.resx
Each file contains a public resource named Currency with the localized currency symbol.
The application is configured to set the culture based on the client browser settings.
The application contains a controller with the action defined in the following code segment.
(Line numbers are included for reference only.)

You need to set ViewBag.LocalizedCurrency to the localized currency contained in the resource
files.
Which code segment should you add to the action at line 03?
A. ViewBag.LocaIizedCurrency = Resources.ProductDictionary.Currency;
B. VievBag.LocalizedCurrency =
HttpContext.GetGlobalResourceObject("ProductDictionary", "Currency", new System.Globalization.
CultureInfo(Men"));
C. VievBag.LocalizedCurrency =
HttpContext.GetLocalResourceObject("ProductDictionary", "Currency");
D. ViewBag.LocalizedCurrency =
HttpContext.GetGlobalResourceObject("ProductDictionary", "Currency");
Answer: A

QUESTION 118
You are developing an ASP.NET MVC application.
You need to authenticate clients by using an ASP.NET membership database.
Which authentication method should you implement?
A. Kerberos

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

B. Forms
C. Basic
D. Windows
Answer: B

QUESTION 119
You are developing an ASP.NET MVC application by using Visual Studio 2012.
The application throws and handles exceptions when it runs.
You need to examine the state of the application when exceptions are thrown.
What should you do?
A. From the Debug menu in Visual Studio 2012, select Exceptions.
Enable the Thrown check box for Common Language Runtime Exceptions.
B. From the DEBUG menu in Visual Studio 2012, select Attach to Process. Select the IIS process.
C. From the Debug menu in Visual Studio 2012, select Exceptions.
Disable the User- unhandled check box for Common Language Runtime Exceptions.
D. From the TOOLS menu in Visual Studio 2012, click Customize.
Click Commands tab and select Debug.
Answer: A

QUESTION 120
You are developing an ASP.NET MVC application by using Visual Studio 2012.
The application throws and handles exceptions when it runs.
You need to examine the state of the application when exceptions are thrown.
What should you do?
A. From the DEBUG menu in Visual Studio 2012, select Exceptions.
Enable the Thrown check box for Common Language Runtime Exceptions.
B. From the DEBUG menu in Visual Studio 2012, select Exceptions.
Disable the User-unhandled check box for Common Language Runtime Exceptions.
C. Add the following code to the Web.config file of the application:
<customErrors mode="On"> <error statusCode="500"
redirect="CustomErrors.html" /></customErrors>
D. Add the following code to the Web.config file of the application:
<customErrors mode="On" > <error statusCode="404"
redirect="CustomErrors.html"/> </customErrors>
Answer: A

QUESTION 121
You are developing a WCF service.
You need to create a duplex contract.
What should you do? (Each correct answer presents part of the solution. Choose all that apply.)
A. Apply the MessageContractAttribute attribute to every public method signature included in the
appropriate contract.
B. Create an interface for the client-side duplex contract.
C. Create an interface for the server-side duplex contract.

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

D. Apply the MessageContractAttribute attribute to the appropriate interface.


E. Apply the ServiceContractAttribute attribute to the appropriate interface.
Then, apply the OperationContractAttribute attribute to every public method signature included in
that contract.
F. Set the CallbackContract property to the appropriate interface.
Answer: CEF
Explanation:
To create a duplex contract
(C) Create the interface that makes up the server side of the duplex contract.
(E) Apply the ServiceContractAttribute class to the interface.
Declare the method signatures in the interface.
(E) Apply the OperationContractAttribute class to each method signature that must be part of the
public contract.
Create the callback interface that defines the set of operations that the service can invoke on the
client.
Declare the method signatures in the callback interface. Apply the OperationContractAttribute
class to each method signature that must be part of the public contract.
(F) Link the two interfaces into a duplex contract by setting the CallbackContract property in the
primary interface to the type of the callback interface.

QUESTION 122
Drag and Drop Question
You are developing a RESTful application by using ASP.NET MVC.
The application is a pet management system and implements the following method in a controller
for retrieving pet data.

The method must only accept JSON data using the standard MIME type.
You need to implement a controller that saves pet data and return a properly formatted HTTP/1.1
protocol response.
You have the following code:

Which code segments should you include in Target 1, Target 2, Target 3 and Target 4 to

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

complete the code? (To answer, drag the appropriate code segments to the correct targets 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.)

Answer:

Get Complete Collection of 70-487 Exam's Question and Answers.


http://www.passleader.com

You might also like