Developing Microsoft Azure and Web Services — Question 71

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

Answer options

• A. Use the WasLate property as the row key.
• B. Use the Airline property as the row key.
• C. Use the WasLate property as the partition key
• D. Use the Arrival property as the row key.
• E. Use the Airline property as the partition key.
• F. Use the Flight property as the row key.

Correct answer: E, F

Explanation

Using the Airline property as the partition key (E) allows for efficient grouping of flight records by airline, facilitating quicker searches. Setting the Flight property as the row key (F) ensures that within each partition, entries are uniquely identified and can be ordered by flight name, improving retrieval speed. The other options do not effectively support the required queries.