Physical Address
304 North Cardinal St.
Dorchester Center, MA 02124
Define and implement an indexing strategy for Azure Cosmos DB SQL API Microsoft Quiz Answers
Get Define and implement an indexing strategy for Azure Cosmos DB SQL API Microsoft Quiz Answers
Create custom indexing policies for Azure Cosmos DB SQL API containers.
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: Define indexes in Azure Cosmos DB SQL API
Discover indexes and indexing policies in Azure Cosmos DB SQL API.
Learning objectives:
After completing this module, you’ll be able to:
- Create and execute a SQL query
- Project query results
- Use built-in functions in a query
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 have created a bulk operation in Azure Cosmos DB SQL API that will insert hundreds of thousands of items into a container. You need to temporarily disable indexing and re-enable it after the bulk operation is complete. Prior to starting the bulk operation, which indexing mode should you configure in the indexing policy?
- None
- Consistent
- Automatic
Q2. You are authoring a new indexing policy for a container in Azure Cosmos DB SQL API. You would like to define an included path that includes all possible properties from the root of any JSON document. Which path expression should you use?
/*/[]/?
Module 2: Customize indexes in Azure Cosmos DB SQL API
Customize indexing policies for a container in Azure Cosmos DB SQL API.
Learning objectives:
After completing this module, you’ll be able to:
- Implement a correlated subquery
- Create a cross-product query
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 are writing a C# application that interfaces with Azure Cosmos DB SQL API and are now tasked with creating a custom indexing policy in code. Which class should you use to author your new indexing policy and customize the indexing mode, enable automatic updates, and set the include/exclude paths?
- IndexingPolicy
- ContainerProperties
- IndexingMode
Q2. The most used query in your Azure Comsos DB SQL API application is SELECT * FROM products p ORDER BY p.name ASC, p.price ASC. You would like to define a composite index to make the query more efficient and consume fewer RU/s. Which composite index should you use to support this query?
(price ASC, name ASC)(price DESC, name ASC)(name ASC, price ASC)
Conclusion:
I hope this Define and implement an indexing strategy for 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 >>
