Keeping embeddings in sync with change tracking

DP-800 · Develop with SQL and AI features · Updated

Use change tracking, CDC, the Azure SQL trigger binding and Azure Functions to refresh embeddings when rows change without loading the database.

This lesson is part of full DP-800 access

The first 2 DP-800 lessons are free. Full access opens every lesson with its practice questions, and the exam-style DP-800 question bank.

In this lesson
  • Options compared
  • Change tracking
  • Azure SQL trigger binding
  • Refresh pattern
  • Exam traps
  • Practice questions

Get full access Try the free practice exam Log in

DP-800 course outline

All 7 lessons · Course overview
  1. The vector data type and similarity searchDesign SQL database solutions for AI Free
  2. Design choices - JSON, graph tables and partitioningDesign SQL database solutions for AI Free
  3. Generating embeddings with external modelsDevelop with SQL and AI features Full access
  4. Keeping embeddings in sync with change trackingDevelop with SQL and AI features Full access
  5. Hybrid search and RAG over SQL dataDevelop with SQL and AI features Full access
  6. Securing SQL AI solutionsSecure, optimize and maintain SQL AI solutions Full access
  7. Performance, blocking and CI/CD for SQL AISecure, optimize and maintain SQL AI solutions Full access