DP-800 practice questions
Microsoft · DP-800 · 200 questions
Original practice questions for Exam DP-800: Developing AI-Enabled Database Solutions (Microsoft Certified: SQL AI Developer Associate), covering design and development of database objects and advanced T-SQL on Microsoft SQL platforms, securing/optimizing/deploying SQL solutions with CI/CD and Azure integration, and implementing AI capabilities (embeddings, vector/hybrid search, and RAG) — framed in civic and municipal scenarios such as city public-health databases, permitting systems, 311 / resident-service SQL apps, transit and water-utility ops, courts / clerk workflows, and housing authority casework. Content is original practice material aligned to the official exam domains and is not a brain-dump of actual exam questions.
This course contains the use of artificial intelligence.
About the DP-800 exam
- Time allowed
- 2 hours
- Languages
- English, Japanese, Chinese (Simplified), Chinese (Traditional), Korean, German, French, Italian, Portuguese (Brazil), Spanish
- Format
- Proctored, may include interactive components; Pearson VUE
Exam details published by the vendor, checked 6 November 2026. Vendors change fees and formats without notice — confirm on the vendor's own page before you book.
Practice Quizzes
Test your knowledge with standard 20-question practice sets.
Quiz 1
Quiz 2
Quiz 3
Quiz 4
Quiz 5
Quiz 6
Quiz 7
Quiz 8
Quiz 9
Quiz 10
Browse by Domain
Study specific topics at your own pace.
Design and develop database solutions · 75 questions
- A city permits office is designing an Azure SQL table for parcel IDs, fee amounts, and inspection dates. Which column design best fits those municipal permit fields?
- A county public-health casework table has grown into millions of encounter rows and analysts need fast rollups by clinic and month. Which indexing approach should the team choose?
- A transit ridership fact table must support chronological trip loads and frequent lookups by routeid for ops queries. How should the indexes be designed?
- A courts clerk system sees extreme docket check-in write spikes every morning calendar open. Which specialized table feature should the team use for those bursty transactional inserts?
- A housing authority must retain lease status change history for audits without building custom audit tables. Which specialized table feature should they implement?
- A county open-data team publishes GIS attribute extracts in blob storage and wants analysts to query them from Azure SQL without importing every file into the primary database. What should they design?
- City finance must keep tamper-evident records of grant disbursements tied to federal pass-through funds. Which specialized table capability should they choose?
- Emergency management wants to model facility–asset–incident relationships for graph-style traversals inside SQL. Which design should they use?
- A 311 intake system stores free-form request payloads and must filter efficiently by category keys inside those documents. What should the team implement?
- Permit applications must guarantee each applicationid is unique and that every application references a valid parcelid in the parcels table. Which constraints should be applied?
- Library card numbers must never collide across city branches. Which constraint should enforce that rule on patroncardnumber?
- A water utility meter-reading table must reject negative readingvalue entries and values outside the sensor’s valid range. Which constraint should enforce that rule?
- Parks reservation rows should start as Pending until staff confirm the booking. Which constraint best supplies that initial status automatically?
- A county clerk cash window needs sequential receipt numbers for payments without relying on an identity column on every related table. Which object should they implement?
- A public-health lab results table must speed purge of aged rows by sampledate. Which design should the team apply?
- City payroll staging stores employee badge codes and must avoid silent truncation when codes are loaded from HR feeds. What data-type sizing practice should they follow?
- Transit ops needs near-real-time lookups of active vehicles and wants a lean nonclustered index that ignores inactive fleet rows. Which index design fits?
- Courts evidence metadata must remain cryptographically verifiable when chain-of-custody attributes change. Which feature should they select?
- Housing advocates must review waitlist standing as it existed on a past effective date for appeal hearings. Which capability should the database provide?
- Open-data restaurant inspection documents are stored as JSON and analysts filter heavily on a nested attribute path. Which indexing approach should the team design?
- A permit fees table must archive old fiscal years quickly during year-end close. Which partitioning pattern should they use?
- Licensing must detect conflict-of-interest paths between licensed contractors and permitted job sites. How should those relationships be modeled in SQL?
- A 311 dashboard must join service requests to neighborhoods for reporting without exposing raw PII columns to analysts. What programmability object should the team create?
- Public-health clinic triage scripts need a reusable calculation that maps height and weight inputs to BMI bands. Which programmability object should they implement?
- Transit planners need a reusable query that returns stops within a given radius of a depot for planning sessions. Which programmability object should they create?
- A city permits counter app must calculate fees and update application status in one server-side call. Which database object should the team implement?
- A county courts system must append a row to an audit trail table whenever a new docket event is inserted. Which programmability object should they use?
- A water utility exposes meter identity through an updatable view, but meter swaps must be validated before base tables change. Which object should enforce that rule?
- Housing caseworkers call a procedure that advances case status and must receive the new queuenumber back to the client app. Which design meets that need?
- Library analytics needs a view of branch circulation totals that will later support an indexed view, so underlying columns must stay locked to the view definition. Which view option should they use?
- An emergency-ops dispatch console needs a reusable query that returns open shelters with remaining capacity as a result set. Which object should they create?
- The county assessor wants every application to format parcel APN strings the same way without copying formatting logic into each app. Which object should centralize that formatting?
- A 311 escalation procedure must reject unknown category codes with a structured error before any escalation row is written. Where should that validation live?
- Parks reservations must not allow overlapping bookings for the same facilityid and time range. Which programmability approach enforces that rule on insert?
- At close of business, the clerk’s cash-drawer process must total tender types and write one daily reconciliation row. Which object should implement that workflow?
- Public health wants open-data consumers to see encounter counts by clinic without exposing row-level PII. Which object should they publish?
- Transit maintenance needs a reusable list of vehicles due for inspection based on mileage thresholds. Which object should return that list?
- Courts analysts need to walk hierarchical case–motion relationships for a single docket number in T-SQL. Which construct should they use?
- A 311 triage board must rank open tickets by age within each neighborhood. Which T-SQL feature should produce that ranking?
- Permit applications store inspection checklists as JSON arrays that must become relational checklist rows. Which T-SQL function should shred those arrays?
- Housing intake stores applicant preferences as JSON and must read a single nested preference key for routing. Which function should extract that scalar value?
- A water-quality API must build JSON response objects and arrays for sensor readings entirely in T-SQL. Which functions should construct those payloads?
- County open data must publish each restaurant inspection with its violation codes collected into one JSON array. Which function should aggregate those codes?
- 311 operators must filter requests whose JSON payload contains a specific tag value. Which JSON function should they use in the predicate?
- Public-health intake must validate that phone numbers in free-text clinic notes match an expected pattern. Which T-SQL predicate function should they use?
- Permits staff must scrub OCR noise from address lines with a regex replacement before geocoding. Which function should transform the text?
- Courts need to pull the case-year token from mixed caption strings using a regular expression. Which function should extract that substring?
- Library acquisitions must locate where an ISBN-like token starts inside messy receiving notes. Which regex function returns that position?
- Transit safety analysts must count how many plate-like tokens appear in each incident narrative. Which regex function should they use?
- Emergency management stores multi-agency radio codes in a delimited string and must explode them into one row per code. Which regex function should they use?
- A housing authority needs to flag near-duplicate applicant names against a master resident index so clerks can merge files before waitlist placement. Which T-SQL function should the developer use to measure how many character edits separate two names?
- A 311 intake screen must suggest close street-name matches when residents mistype an address. Which T-SQL function returns a similarity score the team can threshold for civic address correction?
- A county clerk must merge vendor payee names that look alike but are not identical before issuing warrants. Which fuzzy-matching function is the best fit for comparing those municipal payee strings?
- Emergency management models facilities, contractors, and officials as SQL graph nodes and needs a query that finds contractors linked to both a jobsite and a conflicted official. Which T-SQL construct should the developer use?
- A water-billing stored procedure inserts new meter rows and must handle unique-key collisions without aborting the whole batch. Which T-SQL pattern should the developer implement?
- Parks planners need cumulative reservation hours per facility over a season. Which approach combines a CTE with a window aggregate for that civic utilization metric?
- A FOIA export review must surface every email-like token in free-text notes so redaction staff can inspect them. Which regex function returns the set of matches for that municipal review?
- Public-health analysts want clinics ranked by outbreak case counts within each district without skipping ranks after ties. Which window function should they use?
- Transit ops must build a nested JSON array of stop names per route for a mobile API. Which combination best produces that civic route payload?
- A courts clerk ops procedure catches failures and must persist diagnostic details for after-hours triage. Which values should the CATCH block typically log into the municipal error table?
- A city Azure SQL team plans to enable GitHub Copilot against municipal schema in a shared repo. What security impact should leaders evaluate first?
- County warehouse developers building SQL on clinic tables in Microsoft Fabric need in-product SQL assistance. What should they enable?
- A permits SQL Database Project team wants AI pair-programming inside the GitHub workspace for that repo. What should the organization enable?
- A 311 platform team uses Copilot chat with MCP tools and must harden the session for safer civic development. What should they configure?
- A housing authority wants Copilot to consistently follow civic PII handling rules when suggesting T-SQL. What should the team create?
- Courts developers want Copilot MCP assistance against docket schemas without touching production. How should they connect MCP?
- Open-data engineers need Copilot helpers against lakehouse SQL for civic extracts. Which MCP endpoint type should they connect?
- Transit DevSecOps reviews Copilot suggestions in a municipal repo. Which risk should they specifically watch for?
- Public-health staging must let Copilot discover objects through MCP without mutating data. How should MCP tools be configured?
- A clerk team wants Copilot suggestions to favor safe query patterns in municipal T-SQL. What should their instruction file emphasize?
- A water utility must enable Copilot for regulated billing code without exposing every city repo. Which enablement scope is most appropriate?
- Emergency operations staff are tempted to paste live incident rows into Copilot chat for faster queries. What is the correct guidance?
- Parks developers run SQL in local Docker and want Copilot MCP to reach that instance. What should they configure?
- County IT wants Copilot instruction files to stay aligned as the SQL Database Project evolves. What practice should they follow?
- A 311 platform team’s SQL work spans both a Fabric lakehouse and a GitHub-hosted SQL Database Project. How should they choose Copilot surfaces?
Secure, optimize, and deploy database solutions · 75 questions
- A county public-health clinic stores SSN-adjacent beneficiary identifiers that must stay encrypted even from database administrators viewing data pages. Which approach should the SQL AI developer choose?
- A city permits office must protect credit-card-on-file payment tokens in Azure SQL without treating full-disk encryption alone as sufficient. What should the developer implement?
- A 311 operations desk wants resident phone numbers partially obscured on agent screens without rewriting the intake application. Which feature should they configure?
- A housing authority needs caseworkers to retrieve only case rows for their assigned region. Which security feature should the developer implement?
- Courts IT must let clerks query docket summaries while blocking direct access to the underlying evidence metadata tables. What permission pattern should they use?
- A water utility billing app currently uses SQL authentication with passwords in config files. What change best aligns with passwordless secure access?
- County child-services adjacent case tables require a durable record of who read sensitive rows. Which capability should the team enable?
- Emergency management calls an external RAG model endpoint from SQL-related services and must avoid storing API keys in application settings. How should the endpoint be secured?
- A county open-data GraphQL endpoint in production must not allow anonymous clients to explore the full schema. What should operators enforce?
- Transit IT exposes fleet status through Data API builder REST endpoints. Before publishing, what security posture should they apply?
- Courts want Copilot-assisted SQL work against a staging database through an MCP endpoint. How should that MCP endpoint be secured?
- A library system must hide patron email details from most staff screens and also stop branch clerks from seeing other branches’ patrons. Which combination meets both goals?
- City finance uses Always Encrypted on grant disbursement identifiers and needs to understand what remains protected when backups leave the primary region. Which statement is correct?
- A public-health clinic must produce evidence of who accessed encounter tables for compliance reviews. How should SQL auditing be used?
- A permits vendor account was granted dbowner for convenience. What should county IT do to restore least privilege?
- Housing authority overnight batch jobs need to connect to Azure SQL without storing passwords in the job definition. Which approach should they use?
- Courts expose a model endpoint used by the docket API and must ensure only that API’s identity can call it. What should they configure?
- A 311 GraphQL API serves residents publicly but must keep internal priority-score fields out of public queries. What should developers enforce?
- A water utility must harden SCADA-adjacent REST endpoints that read operational SQL data. Which combination is most appropriate?
- County IT allows Copilot to use an MCP server against production SQL for read assistance but must prevent schema changes through that channel. What policy should they apply?
- After citywide query spikes, a transit DBA needs to tune Azure SQL for better parallel query behavior. Which action fits database configuration recommendations?
- Courts clerks concurrently update related docket rows and must choose a transaction isolation approach that preserves consistency under contention. What should the developer evaluate first?
- Permits analysts suspect applicationid lookups are scanning large tables. Which artifact should they inspect first to confirm the access method?
- During overnight 311 enrichment batches, operators need to see which wait types dominate. Which diagnostic approach should they use?
- Housing IT changed a fee-calculation stored procedure and fears query regressions. Which feature should they enable to track performance over time?
- A county public-health Azure SQL database is slow during morning clinic hours, and leaders want a portal view of the queries using the most CPU. Which Azure SQL feature should the SQL AI developer use?
- County clerk cashiers report freezes when the end-of-day close job runs while receipt inserts continue. Which performance issue should the SQL AI developer diagnose first?
- A water utility’s meter-insert job and a balance-update procedure repeatedly abort with deadlock errors during peak billing. What should the SQL AI developer focus on?
- A city library’s circulation database sees frequent reader/writer blocking during evening checkouts. Which isolation-related change should the SQL AI developer recommend?
- After a storm surge, emergency-management queries show large gaps between estimated and actual rows in execution plans on skewed incident tables. What problem should the team investigate?
- County open-data ETL loads large CSV extracts into Azure SQL and DMVs show elevated PAGEIOLATCH waits. What does that signal for the SQL AI developer?
- Parks reservation joins suddenly choose a poor plan after statistics shifts, and staff want the prior good plan restored quickly. Which Query Store capability should they use?
- Transit Azure SQL Query Performance Insight highlights expensive key lookups on vehicleid in active fleet queries. What should the SQL AI developer do next?
- A courts deadlock graph shows two clerk procedures accessing docket and payment tables in opposite order. How should the SQL AI developer reduce deadlocks?
- After migrating a municipal 311 database to a newer Azure SQL tier, the team wants modern cardinality estimation and optimizer behavior. Which configuration should they review?
- Housing waitlist updates under long SERIALIZABLE transactions cause widespread timeout storms for caseworkers. What should the SQL AI developer conclude?
- Permit counter OLTP spikes show high CXPACKET waits while short transactional queries run. Which action fits a careful performance response?
- A public-health blocked-session report shows long lock waits on encounter queries filtered by clinicid with scans. What root cause should the SQL AI developer suspect?
- A city SQL Database Project for permit fees needs automated checks that fee-calculation procedures return expected amounts. Which CI/CD practice should they add?
- County IT wants pipeline confidence that the clinic SQL Database Project deploys cleanly before API smoke checks. Which approach should they implement?
- The permits office needs fee-schedule lookup rows versioned with the schema so every environment gets the same reference values. Where should that data live?
- Housing authority developers are creating a modern SQL Database Project for case-management schema in CI. Which project style should they choose?
- Courts IT must put the SQL Database Project under Git with protected branches before clerks merge docket schema changes. What should they configure?
- 311 developers need a safe way to change request-table schema without committing straight to main. Which workflow should they follow?
- Two water-utility engineers edited the same meter table DDL on separate branches and Git reports a merge conflict. What should they do?
- Library CI pipelines need SQL connection secrets for deploy jobs. Where should those secrets be stored?
- Emergency-management production SQL has objects that are not in the Database Project model after hotfixes. What should the team detect and address?
- Open-data engineers add additive columns for new civic datasets and must ship them through the SQL Database Project. What is the correct sequence?
- Transit wants schema PRs that touch dbo objects to require designated reviewers before release. Which pipeline control should they use?
- The county clerk release pipeline must pause for human approval before a production dacpac deploy. Which control should they configure?
- A county public-health clinic SQL Database Project repo still allows engineers to push straight to main and skip review. Which pipeline control should the SQL AI developer enforce?
- Parks and recreation wants every pull request to prove the SDK-style SQL Database Project still builds before merge. Which CI step should they add?
- County finance wants the release pipeline to prove who is allowed to trigger production SQL Database Project deploys. Which control should they configure?
- A city’s 311 team needs neighborhood lookup rows available in every environment after SQL Database Project deploy. How should they ship that static data?
- Housing authority QA wants proof that Row-Level Security still filters case rows after each Database Project deploy to test. What should their integration suite assert?
- Courts operations discover hotfix DDL applied directly in production that never updated the SQL Database Project model. How should the pipeline respond to that drift?
- Water utility engineers open a pull request where one branch renames a meter column and another updates a dependent view that still references the old name. What is the correct conflict-resolution approach?
- County IT rotates deployment credentials used by GitHub Actions for SQL Database Project releases. Where should the updated secrets live?
- Transit wants weekend schema deploys to require on-call sign-off even when weekday approvals already exist. Which pipeline design fits?
- A public library SQL Database Project issues card numbers with a SEQUENCE and CHECK constraints. What should unit tests in the project cover?
- The permits bureau still maintains a mix of legacy and SDK-style SQL Database Projects and wants one standard. Which decision should the SQL AI developer recommend?
- City 311 wants Data API builder to expose request entities so mobile clients can page results and filter by status. Which DAB configuration focus is correct?
- Housing caseworkers need GraphQL queries that navigate from a case to related client records through Data API builder. What should developers configure?
- Courts expose infrequently changing statute lookup entities through Data API builder REST. How should they improve read performance for those lookups?
- An open-data portal must publish sanitized dataset metadata through Data API builder without exposing base tables that still hold PII. What should they expose?
- Transit needs a rider-alerts HTTP API backed by Azure SQL. Which deployment approach aligns with DP-800 Azure integration skills?
- Public-health API owners want telemetry on SQL-backed endpoints, including traces and queryable logs. Which Azure monitoring pairing should they recommend?
- Water utilities need meter reading changes to flow continuously into an Azure Function for downstream processing. Which SQL change technology fits best?
- Emergency management needs near-real-time incident table updates to fan out to operations dashboards. Which Azure SQL integration feature should they enable?
- The clerk’s office must incrementally sync docket headers to a search index without reloading the entire table each run. Which feature should they choose?
- Parks and recreation wants an Azure Function to react automatically when new reservation rows land in Azure SQL. Which binding approach should they implement?
- A city library wants branch managers notified when fine balances in SQL cross a configured threshold. Which Azure integration should they use?
- 311 product owners want Data API builder clients to run free-text search across request summary fields. What should developers configure?
- Housing GraphQL clients are failing intermittently and operations needs proactive notice when error rates spike. What should they configure?
- Permits applicants need fee quotes through an API, but the bureau does not want clients writing ad-hoc SQL against fee tables. How should they expose the logic via Data API builder?
Implement AI capabilities in database solutions · 50 questions
- A city evaluates external embedding models for multilingual 311 notes and must weigh model size against structured-output needs. What should the team do first?
- A public-health clinic needs models that can describe photo attachments from field visits, not only plain-text case notes. Which model choice fits?
- A permits bureau wants Azure SQL to call a registered embedding model for fee-policy text. What must developers create and manage?
- A housing authority needs embeddings refreshed when case narrative columns change without putting heavy work on every OLTP write. Which maintenance approach should they choose?
- A 311 desk needs embeddings refreshed immediately after request description edits. Which maintenance pattern fits that requirement?
- Transit ops want route-alert embeddings regenerated asynchronously when alert rows change in SQL. Which Azure pattern should they use?
- Courts IT wants nightly embedding rebuilds only for opinions that actually changed. How should they combine change capture with orchestration?
- Emergency management needs incident text changes fan out to an embedding worker without polling the database. What should they prefer?
- An open-data team is choosing a managed path to keep published dataset blurb embeddings current. Which option should they evaluate for that maintenance workflow?
- A library plans semantic search over the catalog and must pick which columns feed embeddings. What should they identify as inputs?
- A water utility must embed long lab narrative PDFs without exceeding model token limits. What design step is required?
- After the county clerk configures an external model, statute summary columns still lack vectors. What should they do next?
- Public-health plans to embed case narratives but must protect sensitive identifiers. Which guidance is correct?
- Parks policy documents have overlapping sections that must not lose context at chunk boundaries. What chunking strategy should they use?
- A housing authority wants amenity tags extracted as structured fields before those tags are embedded. What model capability should they evaluate?
- 311 receives English and Spanish resident notes and needs embeddings that respect language differences. How should external models be managed?
- Transit OLTP peaks make synchronous embedding work on every write too costly. Which maintenance tradeoff should they choose?
- County SQL AI developers must register an external model so T-SQL can call it. What configuration is required?
- Court clerks need exact statute section keyword lookups such as a precise section number string. Which search approach should they choose?
- 311 wants classic keyword search over request summaries in SQL. What should developers implement?
- Housing designers must store case-note embeddings in SQL for semantic search. What should they design for the vector columns?
- A library needs faster similarity search over catalog blurb embeddings. What should they create?
- Permits analysts want to rank fee-policy chunks by closeness to a natural-language question embedding. Which T-SQL function supports that ranking?
- A water utility compares lab-narrative embeddings and must avoid distance skew from unnormalized vectors. What should they apply before comparisons?
- Emergency management runbooks need to verify vector and index metadata in the ops database. Which function should they use?
- An open-data portal needs nearest-neighbor retrieval over dataset description embeddings in SQL. Which function should developers call?
- Transit must search a very large ridership-comment embedding corpus where approximate neighbors are acceptable. Which approach should they choose?
- A courts clerk must evaluate vector index types and distance metrics before opinion semantic search goes live. What should the team do?
- Public-health staff need semantic lookup over clinic FAQ embeddings inside SQL. What should developers implement?
- City 311 wants retrieval that combines keyword full-text hits with vector similarity over knowledge articles. What should they implement?
- Housing merges keyword and vector ranked lists for lease-policy assistants. Which fusion technique should they apply?
- Parks compares vector-only and hybrid search on recreation-policy documents before choosing a production pattern. What should they evaluate?
- Courts need exact nearest neighbors for a small docket-note embedding set where approximate results are not acceptable. Which search mode should they select?
- A library needs synonym-aware keyword search so “storytime” matches children’s program catalog names. What should they configure?
- A water utility needs hybrid search that still elevates exact chemical-name keyword hits while using vectors for narrative lab notes. How should they design it?
- Emergency management added a new vector index type and must check VECTORSEARCH responsiveness. What should operators measure?
- Permits store embedding vectors beside chunk text and must keep dimensions compatible with the chosen model. What should designers document and enforce?
- County residents ask fuzzy questions such as “why was my street flooded” where exact keyword matches are weak. Which search approach should the team favor?
- City 311 wants assistants that answer ordinance questions grounded in retrieved city policy text rather than free-form invention. Which pattern fits?
- Housing must call a language model from SQL as part of a RAG prompt flow for lease FAQs. Which procedure supports sending those prompts?
- Courts retrieve structured docket rows that must be packaged for language-model context in a RAG flow. What should developers do first?
- Public-health RAG must give the model both retrieved clinic-policy chunks and the staff question. What should the solution send?
- Transit receives a language-model payload for the rider-alert assistant and must surface the natural-language answer. What should developers do?
- A library RAG assistant must reduce hallucination risk on catalog-policy answers. What grounding discipline should they enforce?
- Water ops want sensor anomaly rows included in a RAG prompt’s context window for the language model. How should those rows be packaged?
- Emergency shelter SOPs change often and the team needs fast policy updates without model retraining. Which approach should they choose?
- Permits call an external language-model REST endpoint from SQL and must authenticate securely. What should they use?
- 311 receives structured JSON from the language model that includes reply text and citation chunk IDs. What should the app do?
- Housing residents need live transactional fee quotes calculated by existing stored procedures, not narrative policy summaries. When should the team avoid RAG?
- A courts clerk must summarize several related ordinance chunks with a language model in one RAG call. What should they assemble first?
These questions are original practice material and are NOT actual exam questions or brain-dump content. All vendor marks are trademarks of their respective owners. This site is not affiliated with, endorsed by, or sponsored by Microsoft Corporation.