Microsoft Certified: Azure Cosmos DB Developer Specialty

• Design and implement data models
• Design and implement data distribution
• Integrate an Azure Cosmos DB solution
• Optimize an Azure Cosmos DB solution
• Maintain an Azure Cosmos DB solution

Course Outline

Design and implement a non-relational data model for Azure Cosmos DB Core API

• develop a design by storing multiple entity types in the same container
•  develop a design by storing multiple related entities in the same document
• develop a model that denormalizes data across documents
• develop a design by referencing between documents
• identify primary and unique keys
• identify data and associated access patterns
• specify a default TTL on a container for a transactional store

Design a data partitioning strategy for Azure Cosmos DB Core API

• choose a partition strategy based on a specific workload
• choose a partition key
• plan for transactions when choosing a partition key
• evaluate the cost of using a cross-partition query
• calculate and evaluate data distribution based on partition key selection
• calculate and evaluate throughput distribution based on partition key selection
• construct and implement a synthetic partition key
• design partitioning for workloads that require multiple partition keys

Plan and implement sizing and scaling for a database created with Azure Cosmos DB

• evaluate the throughput and data storage requirements for a specific workload
• choose between serverless and provisioned models
• choose when to use database-level provisioned throughput

design for granular scale units and resource governance

• evaluate the cost of the global distribution of data
• configure throughput for Azure Cosmos DB by using the Azure portal

Implement client connectivity options in the Azure Cosmos DB SDK

• choose a connectivity mode (gateway versus direct)
• implement a connectivity mode
• create a connection to a database
• enable offline development by using the Azure Cosmos DB emulator
• handle connection errors
• implement a singleton for the client
• specify a region for global distribution
• configure client-side threading and parallelism options
• enable SDK logging

Implement data access by using the Azure Cosmos DB SQL language

• implement queries that use arrays, nested objects, aggregation, and ordering
• implement a correlated subquery
• implement queries that use array and type-checking functions
• implement queries that use mathematical, string, and date functions
• implement queries based on variable data

Implement data access by using the Azure Cosmos DB SQL language

• implement queries that use arrays, nested objects, aggregation, and ordering
• implement a correlated subquery
• implement queries that use array and type-checking functions
• implement queries that use mathematical, string, and date functions
• implement queries based on variable data

Implement data access by using SQL API SDKs

• choose when to use a point operation versus a query operation
• implement a point operation that creates, updates, and deletes documents
• implement an update by using a patch operation
• manage multi-document transactions using SDK Transactional Batch
• perform a multi-document load using SDK Bulk
• implement optimistic concurrency control using ETags
• implement session consistency by using session tokens
• implement a query operation that includes pagination
• implement a query operation by using a continuation token
• handle transient errors and 429s
• specify TTL for a document
• retrieve and use query metrics

Implement server-side programming in Azure Cosmos DB Core API by using JavaScript

•  write, deploy, and call a stored procedure
• design stored procedures to work with multiple items transactionally
• implement triggers
• implement a user-defined function

About The Exam