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 LINQto Entities query to extract the required data.
Which code segment should you use?

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 byflight
name. You need to specify which properties of the FlightInfo class should be used at the partition androw 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 tothe
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 useas the body of the StreamHistoricalFlights() method in
the HistoricalDataLoader.cs file?

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 codesegment
should you replace the body of the SaveChanges() method in the FlightInfoContext.cs file?

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?

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

The DeleteExternalOrder() method in the ExternalQueueService service is not throwing a FaultException
exception as defined by the FaultContractAttribute attribute in the IExternalQueueService.cs file. Youneed 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)

You need to regenerate the service proxies to include task-based asynchronous method signatures. Which
command should you use?

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. Chooseall that apply.)