Secure, optimize, and deploy database solutions — Microsoft Certified: SQL AI Developer Associate

Official references for this objective

• Microsoft — Add a connection to Azure SQL Database - Visual Studio (Windows) | Microsoft Learn

  Choose whether you want the connection string stored in a local secrets file, or in Azure Key Vault , and then choose Next .

• Microsoft — Microsoft Certified: Azure Database Administrator Associate - Certifications | Microsoft Learn

  You’re responsible for the following concerning database solutions: Management Availability Security Performance monitoring and optimization

• Microsoft — Microsoft Applied Skills: Build AI-powered solutions by using Microsoft Azure Database for PostgreSQL - Applied Skills | Microsoft Learn

  Generate document embeddings Implement semantic search Apply Retrieval Augmented Generation (RAG)

• Microsoft — Microsoft Applied Skills: Configure and migrate to Azure Database for PostgreSQL - Applied Skills | Microsoft Learn

  should understand PostgreSQL query processing, procedures and functions in PostgreSQL, Azure Database for PostgreSQL security, and Azure networking.

• Microsoft — Microsoft Applied Skills: Develop data-driven applications by using Microsoft Azure SQL Database - Applied Skills | Microsoft Learn

  Develop a data API Enable a read-only Azure SQL Database Import data by using an external REST endpoint

• Microsoft — Microsoft Certified: Azure Cosmos DB Developer Specialty - Certifications | Microsoft Learn

  Write efficient SQL queries for the API. Create appropriate indexing policies. Interpret JSON.

• Microsoft — Microsoft Applied Skills: Migrate SQL Server workloads to Azure SQL Database - Applied Skills | Microsoft Learn

  Perform post-migration configuration Configure disaster recovery Assess and prepare databases for migration Migrate a database to an Azure SQL database