Microsoft Azure Cosmos DB Developer Specialty (DP-420) Cert Prep: 1 Design and Implement Data Models by Microsoft Press

Introduction

• Exam DP-420 Designing and implementing cloud-native applications using Microsoft Azure Cosmos DB: Introduction

1. Lesson 1: Design and Implement a Non-Relational Data Model for Azure Cosmos DB Core API

• Learning objectives
• 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 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

2. Lesson 2: Design a Data-Partitioning Strategy for Azure Cosmos DB Core API

• Learning objectives
• Choose a partition strategy based on a specific workload
• Plan for transactions when choosing a partition key
• Calculate and evaluate throughput distribution based on partition key selection
• Design partitioning for workloads that require multiple partition keys

3. Lesson 3: Plan and Implement Sizing and Scaling for a Database Created with Azure Cosmos DB

• Learning objectives
• 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 Azure Portal

4. Lesson 4: Implement Client Connectivity Options in the Azure Cosmos DB SDK

• Learning objectives
• Implement a connectivity mode
• Create a connection to a database
• Enable offline development by using the Azure Cosmos DB Emulator
• Handle connection errors
• Configure client-side threading and parallelism options
• Enable SDK logging

5. Lesson 5: Implement Data Access by Using the Azure Cosmos DB SQL Language

• Learning objectives
• 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

6. Lesson 6: Implement Data Access by Using SQL API SDKs

• Learning objectives
• 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

7. Lesson 7: Implement Server-Side Programming in Azure Cosmos DB Core API by Using JavaScript

• Learning objectives
• Design stored procedures to work with multiple items transactionally
• Implement triggers
• Implement a user-defined function