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.)
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.
Accordinatly to https://msdn.microsoft.com/en-us/library/azure/dd179338.aspx “Together the PartitionKey and RowKey uniquely identify every entity within a table”. Therefore Arrival should be a row key and Flight should be a partition key.
I’ve been answering this question wrong for ages based on my understanding of how flights are identified. It’s worth noting that from Wikipedia – “A flight number, when combined with the name of the airline and the date, identifies a particular flight.” (https://en.wikipedia.org/wiki/Flight_number)
I’d been figuring that Airline and Flight was enough, but White is right – it’s Arrival for Row key and Flight for Partition key
Another thing is that the we are not limited to select only two items. It says “Choose all that
apply”. So potentially it is possible to create a composite keys for both, partition and row.
Based on https://msdn.microsoft.com/en-us/library/azure/hh508997.aspx I would answer
WasLate and Airline for partition and Arrival and Flight for the row key.
It will be Exact match on PartitionKey and Partial march on the RowKey.
Any better idea?
Composite key total sense for the real world, just wonder what the actual answer is the sake of this exam..!
I see everywhere it as Airline and Flight, and can’t decide if everyone is getting it wrong, or if it is the answer for this question
I guess this is just a case study, not a real life situation. Composite keys are a little over-thinking. The answer options should include the composite key clearly, and they do not. For the exam I would go with Airline and Flight ( see question 70)
C & F is correct in my opinion!
Correct : E and F
Correct : E and F