Exam Prep
Microsoft Azure · AI-200 · Study references

Developing AI Cloud Solutions on Azure

The vendor’s own documentation for each objective of the exam, free to use.

Develop AI solutions by using Azure data management services12 objectives

Connect to Azure Cosmos DB for NoSQL by using the SDK and run queries5 pages

  • Azure Cosmos DB ContainerProxy API

    Reference for the Python Azure Cosmos DB ContainerProxy class, listing its methods and parameters for container item operations.

  • Azure Cosmos DB Python Quickstart

    Shows how to get started with Azure Cosmos DB in Python, covering client packages, authentication, and retrieving databases, containers, and items.

  • Cosmos DB Query - Overview

    Introduces the Cosmos DB query language, outlining its SQL-like syntax for working with flexible JSON documents, nested properties, and operators.

  • CosmosClient Class Constructor and Methods

    Reference for the Python Azure Cosmos DB CosmosClient class, covering its constructor parameters, connection options, and database methods.

  • DatabaseProxy class API

    Reference for the Python Azure Cosmos DB DatabaseProxy class, describing its system properties and methods for creating and managing containers.

Optimize query performance and Request Units (RUs) consumption by using indexing policies and consistency levels6 pages

  • Azure Cosmos DB Indexing Overview

    Explains how Azure Cosmos DB indexes item properties by default, the index types supported, and which query patterns depend on specific index types.

  • Azure Cosmos DB Indexing Policies

    Describes the indexing policy settings in Azure Cosmos DB, including indexing modes, path syntax for indexed properties, and handling of system properties.

  • Azure Cosmos DB Partitioning

    Explains how partition keys divide Azure Cosmos DB data into logical and physical partitions, and how to choose and manage partition key values.

  • Azure Cosmos DB Request Unit Costs

    Explains how request unit costs arise for Azure Cosmos DB reads and writes and which factors, such as consistency and indexing, affect them.

  • Consistency Levels Azure Cosmos DB

    Compares the consistency levels available in Azure Cosmos DB, explaining their guarantees, how defaults apply, and how they affect reads across regions.

  • Cosmos DB - Request Units

    Explains request units as the throughput and cost currency for Azure Cosmos DB, and compares provisioned, serverless, and autoscale throughput modes.

Store and retrieve embeddings and execute vector similarity search for semantic retrieval in Cosmos DB5 pages

  • FULLTEXTSCORE Query Function

    Describes the FULLTEXTSCORE query function, its syntax, required Full Text Index and feature enrollment, and where it may be used in Cosmos DB queries.

  • ORDER BY RANK Clause

    Explains the ORDER BY RANK clause in Cosmos DB, covering result sorting by scoring functions such as vector distance, full-text score, and RRF.

  • RRF Query Language Function

    Describes the RRF query function for fusing multiple scores in Cosmos DB, covering its syntax, weighting argument, prerequisites, and clause restrictions.

  • Vector Search Azure Cosmos DB

    Explains how to run vector searches in Azure Cosmos DB, covering the query function, supported vector types, distance functions, and vector index options.

  • VECTORDISTANCE Function

    Describes the VECTORDISTANCE function in Cosmos DB, including its arguments, supported input types, and tuning options for distance calculation and indexed search.

Implement a change feed processor to detect and handle new or updated items2 pages

  • Change Feed in Azure Cosmos DB

    Explains the Azure Cosmos DB change feed, its modes, and how it orders and delivers changes for building event-driven data processing.

  • Change Feed Processor

    Shows how to implement the change feed processor in Azure Cosmos DB, covering builder setup, instance and lease configuration, and SDK language support.

Connect and query Azure Database for PostgreSQL by using SDKs1 page

  • Azure Database for PostgreSQL - Connect Python

    Shows how to connect a Python application to Azure Database for PostgreSQL, covering passwordless Microsoft Entra and password authentication, required libraries, and network access setup.

Model schemas and implement indexing strategies, including designing tables and choosing appropriate data types12 pages

  • Azure HorizonDB Vector Index Types

    Compares the vector index types available in HorizonDB, helping readers choose an index based on dimensionality, recall, filtering, and memory needs.

  • azure_ai Extension Configuration

    Explains how to install and configure the azure_ai extension in Azure Database for PostgreSQL to call Azure AI services from the database, covering setup commands and configuration settings.

  • DiskANN vector indexing

    Shows how to create and use DiskANN vector indexes in HorizonDB, including extension setup, supported column types, operator classes, and distance query operators.

  • Fabric Delta Table Maintenance

    Learn how to maintain and optimize Delta tables across Spark, SQL analytics endpoint, Power BI Direct Lake, Warehouse, and Mirroring workloads in Microsoft Fabric.

  • Multitenant SaaS Database Patterns

    Learn how to design your SaaS database for scale with PostgreSQL so you can efficiently support thousands of tenants.

  • Multitenant SaaS on Citus

    End-to-end guide to modeling, distributing, and operating multitenant SaaS workloads on Citus.

  • pgvector Extension in PostgreSQL

    Shows how to install, configure, and use the vector extension in PostgreSQL, covering setup steps, distance operators, and vector syntax for similarity search.

  • PostgreSQL - How To Optimize Performance Pgvector

    Provides guidance on optimizing pgvector query performance in PostgreSQL, covering index types, query plan analysis, dimension limits, and parameter tuning for vector search workloads.

  • PostgreSQL Extensions and Modules

    Learn about the extension considerations specific to Azure Database for PostgreSQL flexible server.

  • PostgreSQL Recommendation System Tutorial

    Learn how to build a recommendation system by using Azure Database for PostgreSQL and Azure OpenAI.

  • PostgreSQL Semantic Search Tutorial

    Learn how to build a semantic search application by using Azure Database for PostgreSQL and Azure OpenAI.

  • Vector stores in PostgreSQL

    Explains how vector embeddings and vector search work and why storing them in Azure Database for PostgreSQL helps, for readers evaluating vector stores for AI applications.

Implement indexing strategies, including optimizing query latency and reducing pgvector compute overhead2 pages

  • Autonomous tuning PostgreSQL

    Describes the autonomous index tuning feature for Azure Database for PostgreSQL, listing its server parameters and how it analyzes workloads to recommend or manage indexes.

  • PostgreSQL - How To Optimize Performance Pgvector

    Provides guidance on optimizing pgvector query performance in PostgreSQL, covering index types, query plan analysis, dimension limits, and parameter tuning for vector search workloads.

Configure compute, memory, and storage resources to support vector workloads3 pages

  • Azure PostgreSQL Compute Options

    Describes the compute tiers and vCore options for Azure Database for PostgreSQL flexible server, including memory ratios, storage ranges, backup retention, and scaling behavior for sizing decisions.

  • PostgreSQL Flexible Server Storage

    Describes storage options for Azure Database for PostgreSQL flexible server, comparing Premium SSD and Premium SSD v2 disk characteristics to guide storage sizing and performance planning.

  • Vector Storage Optimization Techniques

    Learn about the vector compression options in Azure AI Search, and how to reduce storage through narrow data types, built-in scalar or quantization, truncated dimensions, and elimination of redundant storage.

Run vector similarity search in PostgreSQL, including storing embeddings, semantic retrieval, and implementing RAG patterns by using metadata filters3 pages

Implement connection optimization to improve throughput and minimize latency2 pages

  • PgBouncer Azure PostgreSQL Configuration

    Describes the built-in PgBouncer feature in Azure Database for PostgreSQL, covering its server parameters, supported compute tiers, and configuration options for tuning connection pooling.

  • PgBouncer Connection Pooling Strategy

    Explains PgBouncer connection pooling modes and deployment patterns for PostgreSQL, helping readers choose a pooling mode and deployment approach for their application architecture.

Implement Azure Managed Redis data operations, including caching, expiration, and invalidation10 pages

  • Azure Cache for Redis Overview

    Compares Azure Cache for Redis tiers by features, clustering support, and service-level agreement coverage, to help choose a tier for a workload.

  • Azure Managed Redis data loss troubleshooting

    Guides troubleshooting of unexpected data loss in Azure Managed Redis, explaining commands, INFO metrics, eviction, and replication behavior that help diagnose missing keys.

  • Azure Managed Redis Modules

    Lists the Redis modules available in Azure Managed Redis by tier, with notes on enablement timing, compatibility, and configuration, for planning which modules a deployment needs.

  • Azure Managed Redis Overview

    Overviews Azure Managed Redis, comparing its tiers, size ranges, and supported versions to help readers choose the right tier for their caching workload.

  • Cache-Aside Pattern: Redis & PostgreSQL

    Design a cache-aside workload for an Azure web application that uses Azure Managed Redis to reduce repeated reads from Azure Database for PostgreSQL.

  • Caching Guidance Documentation

    Learn how caching can improve the performance and scalability of a system by copying frequently accessed data to fast storage close to the application.

  • Event-driven Redis cache updates architecture

    Describes an event-driven architecture that keeps a Redis cache in sync with Azure Cosmos DB changes, covering change feed, deletes, versioning, and race conditions.

  • PostgreSQL Caching Patterns

    Describes caching patterns for PostgreSQL with Redis, including cache-aside, write-through, prefetching, and event-driven invalidation, with code examples for implementing each approach.

  • Redis - Best Practices Development

    Learn how to develop code for Azure Managed Redis.

  • Write-through Caching Architecture

    Learn how to design a write-through caching workload that uses Azure App Service, Azure Functions, Azure SQL Database, and Azure Managed Redis.

Implement vector indexing in Azure Managed Redis to enable similarity search2 pages

  • Azure Managed Redis Modules

    Lists the Redis modules available in Azure Managed Redis by tier, with notes on enablement timing, compatibility, and configuration, for planning which modules a deployment needs.

  • Vector embeddings and search in Azure Managed Redis

    Explains vector embeddings and vector similarity search in Azure Managed Redis, covering index types, distance metrics, required modules, and configuration considerations for building search features.

Develop containerized solutions on Azure7 objectives

Build, store, version, and manage container images by using Azure Container Registry3 pages

  • Azure Container Registry Authentication

    Explains authentication options for Azure Container Registry, including Microsoft Entra tokens, service principals, and admin accounts, with token handling for Docker and Helm.

  • Container Registry - Concepts

    Introduces container registry concepts such as registries, repositories, tags, artifacts, and naming rules, providing vocabulary needed to work with Azure Container Registry.

  • Container Registry - Image Tag Version

    Describes image tagging strategies for container registries, comparing unique, stable, and build-based tag patterns to help readers choose a versioning approach.

Build and run images by using Azure Container Registry Tasks2 pages

  • ACR Tasks base image updates

    Explains how ACR Tasks detect and respond to base image updates, covering dependency detection, trigger timing, and tag requirements for rebuilds.

  • Azure Container Registry Tasks

    Overviews Azure Container Registry Tasks for building images from source, Git triggers, multi-step YAML workflows, and the access tokens needed for repositories.

Deploy containers to Azure App Service, including configuring App Service to supply environment variables and secrets3 pages

  • App Service - Configure Common

    Explains how to configure common App Service settings, covering app setting naming rules, nested key conversion, and CLI and PowerShell commands to manage them.

  • Azure App Service Custom Containers

    Shows how to deploy and configure custom Docker containers in App Service, covering supported base images, registry authentication, and commands to change the container image.

  • Key Vault References Configuration

    Explains how App Service Key Vault references work, covering reference string formats, identity selection for access, and how secret versions and updates are applied.

Deploy applications to Azure Container Apps, including environment configuration and revision management4 pages

  • Azure Container Apps Environments

    Explains Azure Container Apps environment types, networking, and logging setup, helping readers choose between environment options for hosting container apps.

  • Azure Container Apps Revisions

    Explains how Azure Container Apps revisions are created, what changes trigger them, and how single and multiple revision modes manage inactive revisions.

  • Azure Container Apps Secrets Management

    Covers managing secrets in Azure Container Apps, including how secret changes affect revisions, deletion ordering, and the roles that can list secret values.

  • Container Apps - Revisions Manage

    Shows how to manage Azure Container Apps revisions with the CLI, including listing, showing, copying, and updating revisions and controlling traffic.

Implement event-driven scaling by using Kubernetes Event-driven Autoscaling (KEDA) in Container Apps4 pages

Deploy and manage applications to Azure Kubernetes Service (AKS) by using manifest files8 pages

  • AKS - GitHub Actions for Kubernetes

    Lists GitHub Actions from Azure for deploying to AKS and Kubernetes, covering context setup, manifest deployment, Helm and kubectl setup, and container builds.

  • AKS Cluster Deployment Quickstart

    Learn how to deploy an Azure Kubernetes Service cluster (AKS) with default settings using Azure CLI and deploy a multi-container application.

  • AKS Cluster Deployment with PowerShell

    Learn how to quickly deploy a Kubernetes cluster and deploy an application in Azure Kubernetes Service (AKS) using PowerShell.

  • AKS Core Concepts

    Explains core AKS concepts including the AKS Automatic and Standard experiences, control plane and node components, and default managed elements.

  • AKS Developer Best Practices - Resource Management

    Gives AKS developer guidance on setting pod resource requests and limits, CPU and memory units, and the role of namespace quotas in cluster resource management.

  • AKS Internal Load Balancer

    Shows how to create and configure an internal load balancer for AKS services using annotations, covering IP assignment, Standard SKU requirements, and Private Link.

  • AKS Quickstart via Portal

    Learn how to quickly deploy a Kubernetes cluster and deploy an application in Azure Kubernetes Service (AKS) using the Azure portal.

  • Deploy Application to AKS

    In this Azure Kubernetes Service (AKS) tutorial, you deploy a multi-container application to your cluster using images stored in Azure Container Registry.

Monitor and troubleshoot solutions on AKS and Container Apps by inspecting logs, events, and end-to-end connectivity6 pages

  • AKS Internal Load Balancer

    Shows how to create and configure an internal load balancer for AKS services using annotations, covering IP assignment, Standard SKU requirements, and Private Link.

  • AKS Monitoring Configuration

    Explains AKS monitoring options for Automatic and Standard clusters, including Prometheus, Container insights, diagnostic log modes, and audit level settings.

  • Azure Container Apps Log Analytics

    Describes the Log Analytics tables and columns used for Azure Container Apps system, console, and HTTP logs, guiding readers writing queries for troubleshooting.

  • Azure Container Apps Troubleshooting

    Troubleshooting guide for Azure Container Apps covering log streams, provisioning failures, and health probe defaults to diagnose failing revisions.

  • Container Apps - Log Options

    Explains the log categories and destinations available for Azure Container Apps, helping readers choose where application and system logs should be sent.

  • Container Insights - Log Queries

    Describes KQL log queries for Container Insights data in Kubernetes clusters, covering the main tables, prebuilt queries, and caveats when data collection settings change.

Connect to and consume Azure services4 objectives

Queue and process back-end operations by using Azure Service Bus, including dead-letter queue handling, messages, topics, and subscriptions11 pages

  • Azure CLI Service Bus Queue

    Explains Azure CLI options for creating and updating Service Bus queues, including duplicate detection, message expiration, size, auto-delete, and lock duration settings.

  • Message Broker Settlement Operations

    Explains message send, receive, and settlement behavior between clients and Azure Service Bus brokers, comparing receive modes and lock handling over AMQP.

  • Service Bus Dead-Letter Queues

    Describes Azure Service Bus dead-letter queues, including how to address and receive from them and what moves messages into them.

  • Service Bus Messaging Entities

    Explains Service Bus queues, topics, and subscriptions, comparing messaging patterns, delivery ordering, receive modes, processing guarantees, and subscription filtering.

  • Service Bus Topic Filters and Actions

    Describes Service Bus topic subscription filter types and rule actions, covering SQL and correlation filter syntax and how matching rules affect delivered messages.

  • ServiceBusClient Class API

    Documents the ServiceBusClient class in .NET, covering its constructors, authentication options, lifetime guidance, properties, and methods for creating senders.

  • ServiceBusProcessor class

    Documents the ServiceBusProcessor class in .NET, explaining how to configure message and error handlers, start processing, and manage message settlement and lifetime.

  • ServiceBusReceivedMessage Class

    Documents the ServiceBusReceivedMessage class in .NET, describing its properties for timing, sequencing, locking, and dead-letter information on received messages.

  • ServiceBusReceiver Class

    Documents the ServiceBusReceiver class in .NET, covering how to create it, receive and settle messages, cache it, and clean up resources.

  • ServiceBusReceiverOptions Class

    Describes the ServiceBusReceiverOptions class in .NET, listing configurable receiver settings such as identifier, prefetch, receive mode, and subqueue selection.

  • ServiceBusSender Class API

    Documents the ServiceBusSender class in .NET, covering how to create senders, their identifying properties, scheduled message cancellation, and resource cleanup.

Implement event-driven workflows by using Azure Event Grid, including filters, custom events, and retries8 pages

  • Azure Event Grid Event Schema

    Documents the required and optional properties of the Event Grid event schema, including validation rules for event arrays and payload size.

  • Azure Event Grid Event Subscriptions CLI

    Shows Azure CLI commands for creating, viewing, updating, and deleting Event Grid event subscriptions, with parameters for sources, endpoints, and delivery schemas.

  • Event Grid - Custom Event Quickstart

    Shows how to deploy an Event Grid custom topic and send a custom event, explaining the main event fields and template-based deployment options.

  • Event Grid - Event Filtering

    Describes how to filter Event Grid events by type, subject, and advanced field conditions, with the filter syntax for each event schema.

  • Event Grid Dead Letter and Retry

    Shows how to configure dead-letter destinations and retry limits for Event Grid event subscriptions, including storage permissions and blob path conventions.

  • Event Grid message delivery retry

    Explains how Event Grid retries undelivered messages and how to configure retry policies, batching, and delivery timing for event subscriptions.

  • Event Grid Push Delivery Concepts

    Defines core Event Grid push delivery terms and event concepts, including publishers, topics, event sources, partners, and supported event formats.

  • EventGridPublisherClient Class

    Documents the EventGridPublisherClient class in .NET, covering its constructors, authentication overloads, and methods for publishing custom schema events and CloudEvents.

Build serverless APIs by using Azure Functions, including implementing triggers and bindings2 pages

Configure and deploy function apps3 pages

  • Azure Functions App Management

    Shows how to view, set, and update application settings for Azure Functions apps with the Azure CLI and PowerShell, and how changes affect apps.

  • Azure Functions Deployment Technologies

    Compares deployment methods for Azure Functions across hosting plans, showing which packaging and publishing options each plan supports and what extra setup they need.

  • Azure Functions Flex Consumption Plan

    Describes the Flex Consumption hosting plan for Azure Functions, covering instance sizing, scale, and networking features, to help decide whether it fits an app.

Secure, monitor, and troubleshoot Azure solutions4 objectives

Secure secrets by using Azure Key Vault, including rotation and retrieval7 pages

  • Azure Key Vault Developer Guide

    Introduces the Azure Key Vault developer guide, covering control and data planes, Microsoft Entra authentication, managed identities, and SDK guidance for applications.

  • Azure Key Vault Secrets

    Describes Azure Key Vault secrets, including size limits, optional attributes for activation and expiration, and how operations behave outside the validity window.

  • Azure Key Vault Security Recommendations

    Lists security recommendations for Azure Key Vault, covering environment separation, data storage practices, network isolation with private links and firewalls, and managed identities.

  • Key Vault - Tutorial Rotation

    Walks through a Key Vault tutorial on automatically rotating secrets, using a function app and web app with PowerShell date and deployment setup.

  • Key Vault - Tutorial Rotation Dual

    Walks through a Key Vault tutorial on dual secret rotation with PowerShell, covering password conversion, date handling, and configuring the vault and resource group.

  • Key Vault Azure RBAC Access Control

    Explains Azure RBAC access control for Key Vault, covering control and data plane endpoints across clouds, authentication, and supported resource types.

  • Key Vault References Configuration

    Explains how App Service Key Vault references work, covering reference string formats, identity selection for access, and how secret versions and updates are applied.

Store and retrieve app configuration information by using Azure App Configuration3 pages

  • ASP.NET Core Dynamic Configuration

    Shows how to enable dynamic configuration refresh in an ASP.NET Core app using Azure App Configuration, including provider setup, selective keys, and middleware.

  • Azure App Configuration Keys Values

    Describes the rules for App Configuration key names, values, labels, and key-value query patterns, useful for filtering settings when reading or managing them.

  • Azure App Configuration Overview

    Introduces Azure App Configuration, covering centralized settings and feature flags, security, replay and comparison tools, and how it complements Key Vault.

Trace distributed systems by using OpenTelemetry SDKs2 pages

  • Azure Monitor OpenTelemetry Configuration

    Explains how to configure Azure Monitor OpenTelemetry in .NET, Java, and ASP.NET Core apps, covering connection strings, cloud role names, and sampling settings.

  • Azure Monitor OpenTelemetry Setup

    Explains how to enable OpenTelemetry-based Azure Monitor application monitoring across ASP.NET Core, .NET, Java, Node.js, and Python, with per-language setup steps and connection configuration.

Write KQL queries to analyze logs and metrics4 pages

  • Azure Monitor Log Queries

    Overviews log query language support in Azure Monitor, listing where log queries can run, client libraries, and KQL features that are unsupported or Azure-specific.

  • Azure Monitor Log Queries Fundamentals

    Introduces the basics of querying Azure Monitor Logs, covering the KQL and simple query modes, required permissions, and query-writing best practices.

  • Azure Monitor Logs query optimization

    Explains how to read query performance details in Log Analytics and optimize KQL queries to reduce CPU, memory, and execution time.

  • Container Insights - Log Queries

    Describes KQL log queries for Container Insights data in Kubernetes clusters, covering the main tables, prebuilt queries, and caveats when data collection settings change.

All certifications

Terms of use

  • This list is free to use. Every link goes to the vendor’s own site; we don’t control those pages and they may change or move.
  • Each page’s summary is ours, written to say what the page covers. It isn’t the vendor’s and may be imperfect. The list is provided as is, without warranty, and isn’t endorsed by any vendor.
  • We count visits and the links opened, against a random id kept in your browser. Nothing personal is recorded. If you sign up, that id is tied to your account so we can tell whether this list is useful.
  • Anything you submit to this list may be published.