Notifications
Clear all
Topic starter
07/06/2022 11:47 pm
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")
Suggested Answer: C
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<CustomerEntity> query = new
TableQuery<CustomerEntity>().Where(TableQuery.GenerateFilterCondition("PartitionKey", QueryComparisons.Equal, "Smith"));
References: https://docs.microsoft.com/en-us/azure/cosmos-db/table-storage-how-to-use-dotnet
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<CustomerEntity> query = new
TableQuery<CustomerEntity>().Where(TableQuery.GenerateFilterCondition("PartitionKey", QueryComparisons.Equal, "Smith"));
References: https://docs.microsoft.com/en-us/azure/cosmos-db/table-storage-how-to-use-dotnet