• Create a new Azure Cosmos DB for NoSQL account
• Create database, container, and item resources for an Azure Cosmos DB for NoSQL account

Evaluate various requirements of your application

• Compare the various service and throughput offerings for Azure Cosmos DB
• Migrate between standard and autoscale throughput

• Migrate data using Azure services
• Migrate data using Spark or Kafka

• Integrate the Microsoft.Azure.Cosmos SDK library from NuGet
• Connect to an Azure Cosmos DB for NoSQL account using the SDK and .NET

• Configure the SDK for offline development
• Troubleshoot common connection errors
• Implement parallelism in the SDK
• Configure logging using the SDK

• Perform CRUD operations using the SDK
• Configure TTL for a specific item

• Create a transactional batch and review results
• Implement optimistic concurrency control for an operation

Use C# task asynchronous programming model and “bulk” support in the Azure Cosmos DB for NoSQL .NET SDK

• Create and execute a SQL query
• Project query results
• Use built-in functions in a query

• Implement a correlated subquery
• Create a cross-product query

• Create and execute a SQL query
• Project query results
• Use built-in functions in a query

• Implement a correlated subquery
• Create a cross-product query

• Create a change feed processor in the .NET SDK
• Author a delegate to handle a batch of changes in a client-side application

Create an Azure Function using the Azure Cosmos DB trigger

Create an indexer to migrate data from Azure Cosmos DB for NoSQL to an Azure Cognitive Search index

• Determine access patterns for data.
• Apply data model and partitioning strategies to support an efficient and scalable NoSQL database.

• Manage relationships between data entities by using advanced modeling and partitioning strategies.
• Maintain the referential integrity of your data by using change feed.
• Implement pre-aggregating and denormalizing data strategies to improve data-model performance and scaling.
• Optimizing storage and compute by mixing entity types in a single container

• Distribute data across global data centers
• Configure automatic failover and perform a manual failover
• Configure the Azure Cosmos DB for NoSQL .NET SDK to use a specific region

• Configure default consistency level for an Azure Cosmos DB account
• Change the consistency level on a per-request basis

• Configure Azure Cosmos DB for multi-region write
• Use the .NET SDK to select a write region for operations.

• Customize an indexing policy for read-heavy workloads
• Customize an indexing policy for write-heavy workloads

• Tune an indexing policy for specific queries
• Measure the cost for a query or operation

• Implement the integrated cache
• Configure integrated cache options

• Understand how Azure Cosmos DB uses Azure Monitor to monitor server-side metrics
• Measure Cosmos DB’s throughput
• Observe rate-limiting events
• Query telemetry logs
• Measure cross-partition storage distribution throughput

• Review common response codes
• Understand transit errors
• Review rate-limiting errors
• Configure Alerts
• Audit Security

• Understand the different backup and restore options Azure Cosmos DB provides
• Evaluate periodic backups
• Configure continuous backups
• Do point in time recovery

• Implement network level access control
• Review data encryption options
• Use role-based access control (RBAC)
• Access Account Resources using Azure Active Directory
• Understand Always Encrypted

• View arguments, groups, and subgroups for a specific CLI command
• Create Azure Cosmos DB accounts, databases, and containers using the CLI
• Manage an indexing policy using the CLI
• Configure database or container throughput using the CLI
• Initiate failovers and manage failover regions using the CLI

• Identify the three most common resource types for Azure Cosmos DB for NoSQL accounts
• Create and deploy a JSON Azure Resource Manager template for an Azure Cosmos DB for NoSQL account, database, or container
• Create and deploy a Bicep template for an Azure Cosmos DB for NoSQL account, database, or container
• Manage throughput and index policies using JSON or Bicep templates

• Author stored procedure
• Rollback stored procedure transactions

• Create user-defined functions
• Create triggers

A: DP 420 Training is intended for developers and database professionals who want to specialize in building applications using Azure Cosmos DB. It is suitable for individuals who have a basic understanding of databases, SQL, and cloud computing concepts and want to deepen their expertise in working with Azure Cosmos DB.

A: To fully benefit from DP 420 Training, participants should have a foundational understanding of databases, SQL, and cloud computing. Familiarity with NoSQL databases, JSON, and Azure fundamentals will be helpful.

A: DP420 Training covers a wide range of topics, including understanding Azure Cosmos DB, data modeling, partitioning data for scalability, indexing strategies, querying data using SQL and APIs, optimizing performance, and implementing server-side programming with stored procedures, triggers, and user-defined functions.

A: The duration of DP420 Training can vary depending on the training provider and the format of the course. It can range from a few days to several weeks, with part-time or full-time study options available.

A: Yes, we offer DP-420 Training in an online format also, allowing you to learn at your own pace and convenience.

A: Yes, DP420 Training typically includes hands-on exercises that allow participants to practice designing and implementing solutions using Azure Cosmos DB. These exercises may involve tasks such as data modeling, partitioning data, writing queries, optimizing performance, and implementing server-side programming.

A: Yes, upon completing DP 420 Training, you may receive a certificate of completion or participation from the training provider. However, it’s important to note that the DP 420 certification is obtained by passing the official Microsoft DP 420 exam, which is separate from the training course.

A: DP420 Training is designed to cover the topics and concepts relevant to the DP420 exam. However, it is recommended to supplement the training with additional study materials, practice exams, and hands-on experience to ensure thorough preparation for the exam.

A: In addition to DP-420 Training, you can find additional study materials on the official Microsoft Learning website, including exam guides, documentation, and online resources. Microsoft also offers practice exams and official study guides specifically tailored for the DP-420 exam.