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

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?

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?

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

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?

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

You need to load flight information provided by Consolidated Messenger.
What should you use?

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

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?

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?