Physical Address
304 North Cardinal St.
Dorchester Center, MA 02124
Optimize query and operation performance in Azure Cosmos DB SQL API Microsoft Quiz Answers
Get Optimize query and operation performance in Azure Cosmos DB SQL API Microsoft Quiz Answers
Optimize the performance of your queries and operations using Azure Cosmos DB SQL API.
This learning path helps prepare you for Exam DP-420: Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DB.
Prerequisites:
Before starting this learning path, you should have experience of building cloud applications with Microsoft C# or a similar programming language.
Module 1: Customize an indexing policy in Azure Cosmos DB SQL API
Tune the indexing policy based on your SQL queries in Azure Cosmos DB SQL API.
Learning objectives:
After completing this module, you’ll be able to:
- Customize an indexing policy for read-heavy workloads
- Customize an indexing policy for write-heavy workloads
Prerequisites:
Before starting this module, you should have experience of building cloud applications with Microsoft C# or a similar programming language.
Quiz 1: Knowledge check
Q1. Your team has written a SQL query for Azure Cosmos DB SQL API with the following text: SELECT * FROM c WHERE c.sku = 'RD3387G'. Which lookup method will the query engine use for the sku filter?
Full scanIndex scan.Index seek.
Q2. Which property of an indexing policy should you set to disable all indexing for a container?
indexingModeexcludedPathsautomatic
Module 2: Measure index performance in Azure Cosmos DB SQL API
Measure the performance of an indexing policy in Azure Cosmos DB SQL API.
Learning objectives:
After completing this module, you’ll be able to:
- Tune an indexing policy for specific queries
- Measure the cost for a query or operation
Prerequisites:
Before starting this module, you should have experience of building cloud applications with Microsoft C# or a similar programming language.
Quiz 1: Knowledge check
Q1. You’re creating a SQL query that will run in the .NET SDK. Which property of the QueryRequestOptions class should you configure to enable viewing recommendations on single and composite indexes along with the impact of utilized indexes?
MaxItemCountPopulateIndexMetricsEnableScanInQuery
Q2. You’ve created a SQL query in the .NET SDK and received the response in an object of type FeedResponse<>. Which property of the feed response should you use to determine how many request units were used per page of results?
IndexMetricsRequestChargeDiagnostics
Module 3: Implement integrated cache in Azure Cosmos DB SQL API
Implement, configure, and monitor integrated cache in Azure Cosmos DB SQL API.
Learning objectives:
After completing this module, you’ll be able to:
- Implement the integrated cache
- Configure integrated cache options
Prerequisites:
Before starting this module, you should have experience of building cloud applications with Microsoft C# or a similar programming language.
Quiz 1: Knowledge check
Q1. In the .NET SDK for Azure Cosmos DB SQL API, how should you configure the CosmosClientOptions.ConnectionMode property so that your application can use the integrated cache?
- Configure the connectivity mode to
ConnectionMode.Direct - Configure the connectivity mode to
ConnectionMode.Gateway - Leave the connectivity mode to the default value
Q2. Which property of the ItemRequestOptions class should you configure to manually adjust how long items will remain in the cache?
- SessionToken
- ConsistencyLevel
DedicatedGatewayRequestOptions.MaxIntegratedCacheStaleness
Conclusion:
I hope this Optimize query and operation performance in Azure Cosmos DB SQL API Microsoft Quiz Answers would be useful for you to learn something new from this problem. If it helped you then don’t forget to bookmark our site for more Coding Solutions.
This Problem is intended for audiences of all experiences who are interested in learning about Data Science in a business context; there are no prerequisites.
Keep Learning!
More Coding Solutions >>
