2 packs: 15% off with code BUY2. 3 or more: 20% off with code BUY3.

Microsoft DP-800 Exam Practice Questions, practice question pack
MICROSOFT · DP-800

Microsoft DP-800 Exam Practice Questions

99% pass rateUpdated 1 Nov 2026101 questions2 PDFs by email

US$39

Every question with the correct answer and why the other options are wrong.

Download the free sample

Card, Apple Pay, Google Pay or PayPal. Your PDF is prepared and emailed to you after checkout, usually within a few hours.

99% pass rate. Pass or your money back.Fail the exam after using this pack and we refund it, or swap it for any other pack. How the guarantee works
Category:
TRY BEFORE YOU BUY

Three of the 101 questions in this pack

Question 1

You have an Azure SQL database that contains tables named dbo. ProductDocs and dbo. ProductDocsEmbeddings. dbo. ProductDocs contains product documentation and the following columns: DocID (int) Title (nvarchar(200)) Body (nvarchar(max)) LastModified (datetime2) The documentation is edited throughout the day. dbo. ProductDocsEmbeddings contains the following columns: DocID (int) ChunkOrder (int) ChunkText (nvarchar(max)) Embedding (vector(1536)) The current embedding pipeline runs once per night. You need to ensure that embeddings are updated every time the underlying documentation content changes. The solution must NOT require a nightly batch process. What should you include in the solution?

  1. fixed-size chunking
  2. a smaller embedding model
  3. table triggers
  4. change tracking on dbo. ProductDocs
Show answer and explanation

Correct answer: C. table triggers

Table triggers provide the mechanism to execute code immediately when dbo.ProductDocs is modified, enabling real-time embedding updates without requiring a nightly batch process. When a trigger fires on INSERT, UPDATE, or DELETE operations, it can invoke an Azure SQL Database external language procedure or application logic to regenerate and update the corresponding embeddings in dbo.ProductDocsEmbeddings synchronously with the documentation changes.

Why the other options are wrong

  • A. Fixed-size chunking is a data preparation technique unrelated to triggering updates; it does not solve the problem of detecting and responding to content changes in real time.
  • B. A smaller embedding model reduces computational overhead but does not address the core requirement of updating embeddings automatically when documentation changes.
  • D. Change tracking enables detection of modified rows but does not automatically trigger embedding regeneration; it requires a separate process to poll and act on tracked changes, still necessitating scheduled intervention rather than real-time updates.

Question 2

Your team is developing an Azure SQL dataset solution from a locally cloned GitHub repository by using Microsoft Visual Studio Code and GitHub Copilot Chat. You need to disable the GitHub Copilot repository-level instructions for yourself without affecting other users. What should you do?

  1. From Visual Studio Code, modify your GitHub Copilot Chat user settings.
  2. Add a --debug flag when you start the GitHub Copilot Chat extension.
  3. Delete .github/copilot-instructions.md.
Show answer and explanation

Correct answer: A. From Visual Studio Code, modify your GitHub Copilot Chat user settings.

GitHub Copilot repository-level instructions in .github/copilot-instructions.md apply to all users of that repository. To disable them for yourself without affecting others, you modify your personal GitHub Copilot Chat user settings in Visual Studio Code, which allows individual configuration overrides.

Why the other options are wrong

  • B. The --debug flag is for debugging output and does not control instruction behavior.
  • C. Deleting the file would affect all users in the repository, not just yourself.

Question 3

You have an Azure SQL database. You deploy Data API builder (DAB) to Azure Container Apps by using the mcr.microsoft.com/azure-databases/data-api-builder:latest image. You have the following Container Apps secrets: MSSQL_CONNECTION_STRING that maps to the SQL connection string DAB_CONFIG_BASE64 that maps to the DAB configuration You need to initialize the DAB configuration to read the SQL connection string. Which command should you run?

  1. dab init --database-type mssql --connection-string “secretref:DAB_CONFIG_BASE64” --host-mode Production --config dab-config.json
  2. dab init --database-type mssql --connection-string “@env(‘MSSQL_CONNECTION_STRING’)” --host-mode Production --config dab-config.json
  3. dab init --database-type mssql --connection-string “secretref:mssql-connection-string” --host-mode Production --config dab-config.json
  4. dab init --database-type mssql --connection-string “@env(‘DAB_CONFIG_BASE64’)” --host-mode Production --config dab-config.json
Show answer and explanation

Correct answer: B. dab init --database-type mssql --connection-string “@env(‘MSSQL_CONNECTION_STRING’)” --host-mode Production --config dab-config.json

In Azure Container Apps, container secrets are referenced using the @env() syntax to access environment variables. The MSSQL_CONNECTION_STRING secret should be referenced as @env('MSSQL_CONNECTION_STRING') to retrieve the SQL connection string value from the Container Apps secrets configuration.

Why the other options are wrong

  • A. The secretref syntax is incorrect for Container Apps; DAB_CONFIG_BASE64 is for the DAB configuration file, not the connection string.
  • C. The secretref syntax does not apply to Container Apps secrets; this is not the correct reference method.
  • D. DAB_CONFIG_BASE64 is the base64-encoded configuration file, not the connection string itself.

See all 12 free questions Get the full pack, US$39

How much of the Microsoft DP-800 bank is free?

101 questions in the bank

Each step includes the one before, so buying only adds new questions.

  • You are here10questionsFree sampleThree on this page, all ten as a PDF.Download the sample
  • 1212% of the bankPractice pageFree on the site, every answer explained.Go to the practice page
  • 1616% of the bankHalf PackFree by email, as one PDF, every answer explained.Get the Half Pack
  • 101100%, the whole bankFull pack, US$39Plus the questions-only PDF, monthly updates, refund if you fail.Get the full pack
ABOUT THIS PACK

What’s in the Microsoft DP-800 pack

  • 101 questions mapped to the DP-800 exam objectives
  • Answers and explanations for every question, including the wrong options
  • A questions-only PDF for timed practice runs
  • Delivered by email shortly after checkout
  • Free monthly updates for as long as the exam is live
  • Pass or your money back

A DP-800 attempt costs US$165 in the US. This pack is US$39, paid once.

What makes the DP-800 hard

DP-800 is the developer exam for the SQL platform, not the administrator one. Where DP-300 tests whether you can run Azure SQL, DP-800 tests whether you can build on SQL Server, Azure SQL and the SQL database in Microsoft Fabric, and then put AI inside it.

The T-SQL is current generation, and that is where people slip. The blueprint names the new JSON type and functions, the REGEXP family, fuzzy matching with EDIT_DISTANCE and JARO_WINKLER_DISTANCE, graph MATCH queries, and the native VECTOR type with VECTOR_DISTANCE, VECTOR_SEARCH, ANN versus ENN, hybrid search and reciprocal rank fusion. The AI domain adds external models, embedding maintenance through Change Tracking, CDC, change event streaming or Azure Functions, and RAG built with sp_invoke_external_rest_endpoint.

The middle domain is the modern delivery chain: Always Encrypted, RLS and Dynamic Data Masking, Query Store and DMVs, SQL Database Projects with SDK-style models and schema drift detection in CI/CD, Data API builder for REST and GraphQL, and GitHub Copilot with MCP servers pointed at SQL Server and Fabric lakehouses. Most of that did not exist when the older SQL exams were written, and because DP-800 is only a few months old there is very little study material in circulation yet.

About the exam

DP-800 (Developing AI-Enabled Database Solutions) leads to Microsoft Certified: SQL AI Developer Associate. It covers designing and developing database objects and advanced T-SQL across SQL Server, Azure SQL and Fabric SQL database, securing, optimising and deploying databases with SQL Database Projects and Data API builder, and implementing embeddings, vector and hybrid search and RAG inside the database. Associate level, no prerequisites. Skills measured as of 12 March 2026.

Questions before you buy

How quickly do I receive it?

Your PDF is prepared and sent to your email address after checkout, and you get a confirmation as soon as it is on its way.

Are updates included?

Yes. The pack is updated every month for as long as the exam is live, and updates are free for everyone who has bought it.

What if I fail the exam?

We refund the pack, or swap it for any other pack if you would rather keep studying. Sit the exam 7 to 30 days after buying, then send your official score report within 7 days of the exam date, as set out in the refund policy.

What is your pass rate?

99% of customers who prepare with a CertStash pack pass. If you do not, we refund the pack, or swap it for another pack.

Can I share it with colleagues?

Each purchase is licensed to one person. For a team, school or training organisation, email support@certstash.com for a licence that fits.

Related products