Developing Windows Azure and Web Services Microsoft 70-487 Updated PDF & Exam Engine

1
70-487
Developing Windows Azure and Web Services Exam
70-487
Demo Edition
2014 - 2015 Troy Tec, LTD All Rights Reserved
http//www.troytec.com
2
70-487
Section 1 Sec One (1 to 16) Details Topic 1,
Flight Information 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. 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
http//www.troytec.com
3
70-487
http//www.troytec.com
4
70-487
http//www.troytec.com
5
70-487
QUESTION 1 DRAG DROP 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.)
http//www.troytec.com
6
70-487
Answer
QUESTION 2 HOTSPOT 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.)
http//www.troytec.com
7
70-487
Answer
QUESTION 3 You need to recommend a data access
technology to the contractor to retrieve data
from the new data source. Which data access
technology should you recommend?
http//www.troytec.com
8

• 70-487
• LINQ to XML
• ADO.NET Entity Framework
• ADO.NET DataSets
• WCF Data Services
• Answer D
• QUESTION 4 DRAG DROP
• 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 5 DRAG DROP 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 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
http//www.troytec.com
9
70-487 may need to drag the split bar between
panes or scroll to view content.)
Answer
QUESTION 6 DRAG DROP 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.)
http//www.troytec.com
10
70-487
Answer
http//www.troytec.com
11
70-487 QUESTION 7 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?
http//www.troytec.com
12
70-487

• Option A
• Option B
• Option C
• Option D
• Answer A
• QUESTION 8
• You are adding a new REST service endpoint to the
  Flight Data Controller 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?

http//www.troytec.com
13
70-487

• 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 9
• 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?

http//www.troytec.com
14

• 70-487
• QUESTION 10
• You need to load flight information provided by
  Consolidated Messenger. Which should you use?
• SQL Server Data Transformation Services (DTS)
• EntityTransaction and EntityCommand
• Office Open XML
• OleDbConnection and OleDbDataReader
• Answer D
• QUESTION 11 DRAG DROP
• 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 Load
Flights() 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.)
http//www.troytec.com
15
70-487
Answer
http//www.troytec.com
16
70-487
QUESTION 12 You are adding a new REST service
endpoint to the Flight Data Controller 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?
http//www.troytec.com
17
70-487

• Option A
• Option B
• Option C
• Option D
• Answer D
• QUESTION 13
• You need to load flight information provided by
  Consolidated Messenger. What should you use?
• Office Open XML
• COM interop

http//www.troytec.com
18

• 70-487
• OleDbConnection and OleDbDataReader
• EntityConnection and EntityDataReader
• Answer C
• QUESTION 14
• 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 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.)
• 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.

http//www.troytec.com
19
70-487

• Option A
• Option B
• Option C
• Option D
• Answer D
• Explanation
• http//msdn.microsoft.com/en- us/library/system.xm
  l.linq.xstreamingelement.aspx and
  http//msdn.microsoft.com/en- us/library/bb551307.
  aspx
• QUESTION 16
• 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. With which code segment should you
  replace the body of the SaveChanges() method in
  the FlightInfoContext.es file?

http//www.troytec.com
20
70-487

• 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

http//www.troytec.com
21
70-487 wraps a provider-specific
exception. Section 2 Sec Two (17 to
47) Details Topic 2, ASP.NET MVC 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.
The project contains two services defined in the
following files. ? IExternalQueueService.es ?
ExternalQueueService.svc. The ExternalQueue.Helper
s namespace contains a definition OrderNotFound
Exception. OrderProcessor Project Entity
Framework is used for data access. The entities
for a class named
are defined in the
http//www.troytec.com
22
70-487 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 ? ProcessedOrderControll
er.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. 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.
http//www.troytec.com
23
70-487
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
http//www.troytec.com
24
70-487
http//www.troytec.com
25
70-487
http//www.troytec.com
26
70-487
http//www.troytec.com
27
70-487
QUESTION 17 DRAG DROP The GetVendorPolicy()
private method in the ProcessedOrderController
controller is returning a CacheItem Policy 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
content.)
http//www.troytec.com
28
70-487
Answer
QUESTION 18 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?

1. Option A
2. Option B
3. Option C

http//www.troytec.com
29
70-487
D. Option D Answer A QUESTION 19 DRAG
DROP 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.)
Answer
http//www.troytec.com
30
70-487
QUESTION 20 DRAG DROP You need to create the
Shipping Context 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
http//www.troytec.com
31
70-487
http//www.troytec.com