PrepAway - Latest Free Exam Questions & Answers

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

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


Leave a Reply