Microsoft Exam Questions

You use Azure Table storage to store customer information for an application. The data contains cust

You use Azure Table storage to store customer information for an application. The data contains customer details and is partitioned by last name.

You need to create a query that returns all customers with the last name Smith.

Which code segment should you use?

A. TableQuery.GenerateFilterCondition(“PartitionKey”, Equals, “Smith”)
B. TableQuery.GenerateFilterCondition(“LastName”, Equals, “Smith”)

C. TableQuery.GenerateFilterCondition(“PartitionKey”, QueryComparisons.Equal, “Smith”)

D. TableQuery.GenerateFilterCondition(“LastName”, QueryComparisons.Equal, “Smith”)

Explanation:
Retrieve all entities in a partition. The following code example specifies a filter for entities where ‘Smith’ is the partition key. This example prints the fields of each entity in the query results to the console.
Construct the query operation for all customer entities where PartitionKey=”Smith”.

TableQuery query = new TableQuery().Where(TableQuery.GenerateFilterCondition(“PartitionKey”, QueryComparisons.Equal, “Smith”));

References:
https://docs.microsoft.com/en-us/azure/cosmos-db/table-storage-how-to-use-dotnet