DP-750 practice questions
Microsoft · DP-750 · 200 questions
Original practice questions for Exam DP-750: Implementing Data Engineering Solutions Using Azure Databricks (Microsoft Certified: Azure Databricks Data Engineer Associate), covering Azure Databricks environment setup and compute, Unity Catalog security and governance, data preparation and processing (ingestion, modeling, cleansing, quality), and deploying and maintaining Lakeflow pipelines and workloads — framed in civic and municipal scenarios such as city open-data lakehouses, 311 analytics, public-health records, permitting pipelines, 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-750 exam
- Passing score
- 700 (scaled, 1-1000)
Exam details published by the vendor, checked 23 October 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.
Set up and configure an Azure Databricks environment · 35 questions
- A city open-data team runs nightly batch transforms for 311 tickets and needs compute that starts for the job and shuts down when the run finishes. Which compute should they select?
- County public-health analysts need interactive SQL dashboards over clinic case metrics without managing classic Spark clusters. Which Azure Databricks compute should they use?
- Transit operations wants ad-hoc notebook exploration of ridership without leaving idle clusters burning budget overnight. Which compute choice best fits?
- Housing authority data engineers need a workspace cluster that several developers can attach to while collaboratively building lease-enrichment notebooks. Which compute pattern should they choose?
- Emergency management weather-alert joins spill memory during peak storms. What compute change should the data engineer make first?
- The permits office schedules weekend PDF-extract backfills that vary sharply in volume. How should they configure compute scaling?
- Library analytics leaves all-purpose clusters running after analysts disconnect, driving idle charges. Which setting should they apply?
- A water utility runs recurring IoT ingest jobs and wants shorter cold-start time for sensor backfills. Which compute feature should they use?
- City finance runs warehouse SQL that aggregates high-volume parking citation facts and needs faster query execution. Which feature should they enable?
- County IT must keep fraud-flag feature-prep notebooks reproducible across deploys. What should they pin on the compute configuration?
- A public-health notebook trains a simple clinic no-show model alongside ETL feature prep. Which runtime should the team select?
- The 311 pipeline must standardize addresses in-process on the job cluster. What should the data engineer do?
- Courts clerk leadership must limit who can attach to a cluster that processes sensitive case-index data. What should they configure?
- Parks department BI authors only write SQL against park visitation Delta tables. Which compute should the data engineer prefer?
- School-district attendance ETL must burst during enrollment week without unbounded spend. How should worker counts be set?
- Municipal architecture standards require different node traits for permit OCR enrichment versus wide resident-service joins. What selection principle should engineers follow?
- Open-data stewards need a connector library available to every notebook on a shared civic cluster without copying jars into each notebook. What should they do?
- County security asks who should be allowed to restart a production job cluster that processes resident PII extracts. What is the appropriate approach?
- A city lakehouse must keep permit silver tables from colliding across stages. How should Unity Catalog objects be named?
- A regional transit consortium will share anonymized ridership aggregates with external partners. What Unity Catalog naming consideration matters most when creating the catalog?
- A housing authority needs one top-level Unity Catalog boundary to hold all resident-services schemas. What object should they create first?
- Public works wants water-main break events organized separately from wastewater under the utilities catalog. What should they create?
- The clerk of courts needs Unity Catalog storage for scanned PDF evidence packages that enrichment jobs will read as files. Which object should they create?
- The 311 team wants analysts to query curated ticket outcomes without seeing internal disposition codes stored on the base table. How should they expose the data?
- Transit BI needs dashboards that stay fast during rush reporting on hourly boardings. Which Unity Catalog object should they use for pre-aggregated metrics?
- A county finance team needs Azure Databricks analysts to query live tables in an existing SQL Server permitting database without copying every table into the lakehouse first. Which Unity Catalog approach should they implement?
- Open-data engineers need a durable Unity Catalog table for published park schedules that Databricks manages end to end. Which action should they take?
- Emergency management already stores historical storm CSVs in ADLS and wants Azure Databricks to query them without rewriting the files. Which Unity Catalog object should they create?
- A city wants resident analysts using AI/BI Genie to discover the correct 311 domain tables when they ask natural-language questions about ticket metrics. What should data engineers configure?
- A municipal architecture board wants gold citizen-service metrics fully lifecycle-managed by Azure Databricks under Unity Catalog. Which table choice should they standardize on?
- A water utility lands raw IoT sensor files in ADLS and later produces cleansed silver readings for analytics. How should they mix Unity Catalog table types across layers?
- A library system receives periodic MARC export file drops that notebooks must read before loading catalog Delta tables. Which Unity Catalog object should they create for the landing files?
- A permits team wants Unity Catalog to reflect medallion layers for permit data under one subject-area boundary. How should they organize objects?
- County IT wants engineers to experiment with Unity Catalog objects for civic pipelines without risking production tables. Which approach should they take?
- A health department must keep PHI schemas separable from public open-data schemas inside the same Unity Catalog metastore. What naming practice should they adopt?
Secure and govern Unity Catalog objects · 35 questions
- A city wants resident-services analysts to read gold 311 metrics while parks volunteers must not access that table. Which Unity Catalog action should administrators take?
- A transit ridership pipeline runs as a service principal that must write silver tables without broader administrative power. How should Unity Catalog privileges be assigned?
- Housing caseworkers need case status fields from a resident table but must not read Social Security numbers in that same table. Which control should the data team apply?
- Courts analytics must ensure each clerk office sees only cases for its own jurisdiction code in a shared Unity Catalog table. What should they implement?
- Water utility notebooks must read ADLS without embedding storage keys in source code. How should secrets be obtained from within Azure Databricks?
- Permits ETL must call source APIs on a schedule without depending on an interactive engineer session. Which authentication approach should they use?
- County 311 streaming ingest must reach a restricted Azure Event Hubs namespace from Azure Databricks compute. Which access method should they prefer?
- A public-health steward must give one auditor temporary access to use a clinic staging schema without elevating them to metastore administrator. What should they grant?
- An open-data portal must read published gold tables while only engineering may write them. How should Unity Catalog privileges be separated?
- Emergency management shares some operational tables with mutual-aid partners but must keep internal after-action notes private. Which Unity Catalog control should they use?
- Library IT stores a vendor API token in Azure Key Vault for catalog ingest and must limit who can retrieve it for Databricks jobs. What should they configure?
- A school-district attendance pipeline must run under a non-human identity that is granted Unity Catalog access to attendance schemas. Which pattern should they implement?
- City security requires Azure Databricks to read sealed permit archives behind a storage firewall without distributing shared account keys. Which approach should they choose?
- After a mistaken truncate on 311 bronze landing tables, the platform team must correct who can change those tables. What Unity Catalog action is most appropriate?
- A housing authority needs analysts to compute case load counts without viewing encrypted national ID columns in the same resident table. Which control should they select?
- A transit agency stores high-sensitivity vehicle GPS breadcrumbs in Unity Catalog and must allow only the mobility-science group to read that table. What should the data engineer do?
- A county permitting office wants analysts to discover fee fields quickly in Catalog Explorer. What should stewards add to the Unity Catalog tables and columns?
- Public works wants attribute-based access so sensitivity and department attributes decide who can read utility datasets. What should they configure in Unity Catalog?
- A public-health department must stop epidemiologists outside a region from querying other regions’ case rows in the same Unity Catalog table. What should they apply?
- Courts analytics must let junior analysts query docket tables while redacting defendant dates of birth. Which Unity Catalog control should they configure?
- An open-data team must delete raw 311 attachment files after a mandated municipal retention window. What should they apply in Unity Catalog governance?
- Finance auditors need to see which jobs and upstream tables feed the published parking-revenue gold table. Where should they look in Azure Databricks?
- City security must determine who queried resident address tables last quarter. What should the team enable for Unity Catalog access?
- A regional metropolitan planning organization must share anonymized ridership aggregates with peer cities without granting them direct metastore access. What strategy should they use?
- Parks stewards need Catalog Explorer to show who last changed trail-closure schemas. Which governance metadata should they rely on?
- A 311 platform must block the sandbox group from reading production PII tables using department and environment attributes together. What should engineers configure?
- A housing authority must keep gold case metrics for statutory reporting longer than bronze chat transcripts. How should retention be designed?
- A clerk of courts wants to confirm that a gold docket summary depends on silver hearings and bronze CMS extracts. What should they examine?
- A county health office must give a university partner de-identified clinic visit counts without opening the county metastore. What should they implement?
- Security operations sees an unusual principal enumerating many Unity Catalog schemas overnight. Which artifact should they review first?
- Transit wants analysts and Genie to interpret delay reason code enums correctly. What should stewards maintain on the ridership delay table?
- Public health needs epidemiology heatmaps by ZIP3 while hiding patient ZIP+4 detail from general analysts. What should they configure?
- A city tags open-data tables as public and needs anonymous-facing service principals to read only those datasets. What should governance use?
- Emergency management lands raw CAD streams with precise coordinates and must minimize how long that sensitive data remains. What should they apply?
- Architecture must choose Unity Catalog controls for a multi-agency courts data product that needs row isolation, redaction, tagged policies, and partner exchange. Which combination fits?
Prepare and process data · 65 questions
- A city must land nightly permit CSV drops for batch analytics and also capture live counter submissions from Event Hubs. How should extraction be designed?
- A county archives cold historical 311 tickets for rare compliance reads while keeping active silver tickets ready for ACID merges. Which format choice fits?
- Transit partners require an open table format for a shared lake while city pipelines remain Azure Databricks–native. What should the data engineer evaluate?
- A water utility stores high-volume IoT readings and needs prune-friendly filters for leak investigations by date and facility. What modeling choice should they make?
- A housing authority must keep auditable history when apartment eligibility status changes over time. Which slowly changing dimension approach should they use?
- A 311 analytics team needs gold tables that support daily SLA dashboards. Which grain should they choose?
- Courts need to record how ordinance fee schedules change over time so prior assessments remain explainable. What should they implement?
- An open-data team maintains a large citations table with evolving filter patterns and wants to avoid managing many static partitions. What should they adopt?
- Finance analysts repeatedly filter a payments fact table by citizen-id and period. How should they improve file locality for those filters?
- A public-health clinic must fulfill targeted resident erasure requests on large Delta fact tables without rewriting entire files. What should they enable?
- A library wants curated catalog facts under Unity Catalog lifecycle control and raw vendor MARC landings left in an external path. How should tables be chosen?
- Emergency management must land raw CAD JSON then promote typed operational events for analytics. Which ingest and modeling flow fits?
- A permits office must orchestrate extracts from on-prem SQL into ADLS before Databricks refine. Which tool should they select for that hybrid orchestration?
- A city prefers managed ingest of a SaaS citizen-CRM export into Unity Catalog with less custom notebook glue. What should they choose?
- Analysts need to prototype permit transforms quickly, then promote stable logic into production pipelines. How should notebooks be used?
- Transit planning can wait for nightly ridership totals, but service alerts must refresh continuously. How should load methods be chosen?
- A 311 team must pull the prior day's closed tickets into bronze with managed batch ingest. Which approach fits?
- A water utility needs near-real-time valve telemetry landed into Unity Catalog. What should they configure?
- Parks engineers receive weekend CSV drops of reservation exports and need them in a Delta bronze table. What should they use?
- Emergency management must consume a continuous weather-alert topic into a live Delta sink from engineering notebooks. What pattern should they use?
- An open-data team wants to materialize a new parks table from a cleaned staging query in SQL. Which statement pattern should they use?
- A county must refresh a reference fee table from the latest validated extract while replacing prior contents cleanly. Which SQL approach fits?
- Finance receives new parking citation files and must load them into an existing Delta table with repeatable, idempotent semantics. What should they use?
- Housing needs silver case records to reflect inserts, updates, and deletes from the case-management OLTP system. Which ingest approach should they apply?
- Transit must continuously append AVL vehicle positions into a bronze Delta path. Which technology should they build on?
- City 311 needs live queue-depth metrics from event streams into Databricks. Which Azure messaging source should feed the pipeline?
- Public works wants an incremental load of streetlight outages managed as a pipeline with declarative table definitions. What should they create?
- A library volume receives new MARC file drops that should be ingested with schema inference as files arrive. What should they use inside declarative pipelines?
- A permits team re-runs fee file drops and must avoid double-counting when the same files land again. Which SQL ingest choice is best?
- County health runs Structured Streaming for clinic event feeds and must keep replays from duplicating ops metrics. What operational need should they recognize?
- Open-data permit status webhooks arrive through Azure Event Hubs as JSON. What should the silver path do next?
- School attendance CDC includes soft-deletes for withdrawn students. How should gold enrollment counts stay accurate?
- City hydrant inspections need an ongoing production ingest, not a one-time backfill. Which tool choice fits best?
- A 311 team must design cleansing rules for category codes. What should they do first?
- Courts engineers are typing fine amounts and hearing times for silver case tables. Which typing choice is appropriate?
- Housing CRM exports sometimes repeat the same household under new surrogate IDs. What should silver cleansing do?
- Public-health vaccination dates are sometimes missing in clinic extracts. How should the pipeline handle those nulls?
- Transit reliability gold needs mean delay by route after removing test bus IDs. Which transform sequence fits?
- Permits silver must enrich applications with parcel keys and combine multiple historical years. Which approach is correct?
- Finance wants parcel IDs that appear in both delinquency and lien datasets for targeted outreach. Which set operation fits?
- Open-data must publish a flat CSV citation extract for the portal. What transform is appropriate?
- Emergency management needs resource-type counts by incident as columns on a command dashboard. What should they do?
- Library nightly feeds include new acquisitions and updates to existing catalog items. Which load pattern should silver use?
- Parks captures reservation events for bronze and needs a current-state silver table. How should load styles differ by layer?
- After cash-office audits, county finance must land corrected fee rows in a quarantined adjustments table. Which pattern fits?
- Many 311 tickets arrive with null category codes but usable free-text descriptions. How should cleansing resolve those nulls?
- Water utility IoT readings arrive as strings and sometimes include non-numeric spikes. What should the transform do?
- Courts must publish a public calendar without sealed case IDs. Which set approach is correct?
- Before building permit SLA gold metrics, the city wants to understand turnaround-day outliers. What should engineers do?
- Housing pipelines treat householdid as a required key. How should nullability be enforced?
- Transit reference data must keep each vehicle on at most one active depot assignment. What quality check fits?
- Public-health clinic streams include body-temperature readings that can be impossible. What should quality controls do?
- Finance fee amount columns must remain DECIMAL through the load. Which quality practice is correct?
- A permits vendor CSV sometimes adds unexpected columns. What should bronze ingest do?
- Open-data citation feeds add optional fields over time. How should schema drift be managed?
- A city's 311 Lakeflow Spark Declarative Pipeline must drop tickets whose priority is not in {P1, P2, P3} into quarantine. What should the team configure?
- Emergency management wants high null GPS rates on CAD events to warn operators without failing the entire streaming pipeline. Which expectation behavior fits?
- A library must validate ISBN-like identifiers' format before merging rows into the catalog silver table. What quality step should they add?
- A county clinic queue dashboard breaks when wait-time metrics arrive as negative numbers. How should quality constraints treat those values?
- A water utility's IoT firmware adds new telemetry fields mid-season. How should the lakehouse team handle schema drift?
- Courts require both casenumber and filingdate to be non-null before a row may enter gold calendars. What should the quality gate enforce?
- A city streaming micro-batch must not land duplicate ticketid values inside the same window. How should uniqueness be enforced?
- Housing wants bad enum values quarantined differently from orphan parcel IDs that fail referential checks. How should quality be layered?
- Parks must document which expectations are fatal for public open-data drops versus those that only warn on internal silver. What principle applies?
- Transit sees repeated failed expectations for AVL vendor null spikes in the pipeline UI. What should engineers do next?
Deploy and maintain data pipelines and workloads · 65 questions
- A city 311 medallion flow must ensure SLA metrics never read uncleansed tickets. How should stages be ordered?
- Housing needs reliable incremental SCD merges for eligibility history. Notebook DAG maintenance has become brittle. What should they choose?
- Transit must ingest AVL, then enrich, then publish—and later tasks must wait on earlier ones. How should the Lakeflow Job be designed?
- Public-health notebooks sometimes hit parse errors on clinic rows. What error-handling pattern should they use?
- A permits Lakeflow Job must not run the fee-publish task after a failed extract. What should be configured?
- Open-data wants a multi-task job of notebooks where profiling finishes before transform starts. What should they create?
- A water utility needs a managed graph for sensor bronze and silver tables with expectations attached. What should they create?
- Emergency management requires enrichment only after geocoding so alerts never publish without required coordinates. How should the pipeline enforce this?
- Library staff explore MARC cleanses in notebooks but need stable production MARC loads. How should tooling be split?
- A county API extract times out occasionally. Retries must not double-write successful gold publishes. What design is appropriate?
- A 311 job must keep human quarantine review separate from automatic gold publish. How should tasks be structured?
- Finance must stop before any MERGE when schema enforcement errors exceed a threshold. What pipeline behavior fits?
- Parks needs always-on incremental reservation facts plus a rare annual archive purge. How should pipeline styles be chosen?
- Courts must land sealed PDFs to a volume, extract metadata, load a Unity Catalog table, then share a restricted view. What order is correct?
- A city wants production hydrant inspection loads to carry durable quality rules rather than one-off notebook asserts. What should they prefer?
- A transit authority builds a ridership star schema job and must keep dimension loads ahead of fact publishes. What should the job DAG enforce?
- A housing authority needs a nightly eligibility SCD on Azure Databricks. What is the appropriate first job setup step?
- A 311 desk wants processing to start when new ticket exports land in cloud storage. Which Lakeflow Jobs capability should they configure?
- An open-data team must refresh published park facility tables every day at 02:00 local time. What should they configure?
- Public-health clinic ETL must notify on-call engineers if the job fails before morning rounds. What should they configure on the Lakeflow Job?
- A water utility streaming-adjacent job sometimes dies on transient network blips. What resilience setting should they enable?
- Courts need a cron-like docket publish that must wait until the CMS extract task finishes. How should the Lakeflow Job be designed?
- Transit needs notice when ridership backfill runs overrun the morning-rush reporting SLA. What alert should they use?
- A library production job must respect city cost guards instead of borrowing an oversized interactive cluster. What should job setup use?
- During a declared incident, emergency management needs weather-alert enrichment to keep running with minimal gaps. Which trigger mode fits best?
- Permits fee-publish jobs flood inboxes with success mail and bury real failures. How should alerts be tuned?
- A county pipeline hits a poisoned schema and keeps restarting overnight. What restart policy change is needed?
- A city wants the same notebooks to support daily runs and historical backfills by passing a rundate. What should the multi-task Lakeflow Job use?
- Housing needs a weekly full refresh and a nightly incremental eligibility path with clear ownership. How should jobs be bounded?
- Finance gold revenue publish failures must reach Azure Monitor–aware municipal ops. What practice should they follow?
- Parks must run a one-time fiscal-year rollover without changing the standing daily schedule. What should they do?
- A 311 production job must not reuse interactive development clusters that analysts keep busy. What isolation practice is correct?
- A city wants notebooks and pipeline definitions reviewed before production deploy. What SDLC practice should they apply?
- Transit engineers change AVL enrichment logic and need peer review before merge. Which Git workflow should they use?
- Two public-health engineers edit overlapping clinic transform notebooks and hit a Git merge conflict. What should they do?
- Housing wants confidence in SCD helper functions before they enter the eligibility pipeline. What testing step should come first?
- Open-data wants automated checks that sample CSVs land and silver schemas match in a dev catalog. What test type fits?
- Courts want confidence from CMS extract through gold calendar publish before promoting a change. Where should end-to-end tests run?
- A library plans to cut over catalog search extracts and needs staff confirmation the results look right. What testing gate should they include?
- A county wants repeatable deploys of workspace jobs and notebooks across environments. What packaging approach should they use?
- A city CI pipeline must deploy a Databricks Asset Bundle into the production workspace after merge. Which approach matches the Azure Databricks CLI deployment path?
- Emergency management wants the enterprise pipeline tool to push Asset Bundle updates without relying on an interactive CLI session. What should they use?
- A permits team wants production Databricks deploys gated so broken transforms never ship on merge alone. What should gate the deploy?
- A water utility needs hotfix branches for broken sensor parsers that do not block ongoing feature work. Which branching practice fits?
- A 311 Asset Bundle must point sandbox and production at different Unity Catalog catalogs without rewriting job logic. What should the team use?
- Finance wants peer review to catch both notebook logic and job orchestration changes before merge. What should reviewers examine together?
- Parks wants a lightweight integration test that proves a COPY INTO replay does not double picnic-permit rows. What should the test assert?
- A school-district CI must keep Azure Databricks CLI production deploys tightly governed. Which control is appropriate?
- After a quiet season, a city wants to rightsize workers for 311 Lakeflow Jobs based on measured use. What should they monitor first?
- A housing Lakeflow Job fails on a late eligibility task after upstream bronze and silver tasks succeeded. What recovery action fits best?
- Transit AVL enrich notebooks OOM during wide joins. Beyond hoping it stops, what should engineers tune?
- Public-health aggregations stall because a few giant clinic facilities dominate shuffle. What problem should they diagnose?
- Finance sees Spark UI spill-to-disk during year-end payment reconciliations. What does that signal, and what should they address?
- Open-data needs to find an expensive shuffle before gold citation publish. Which tooling path should they use?
- Permits silver applications accumulate many tiny files after heavy updates. Which Delta maintenance command should they run to compact?
- Courts finished retention-approved cleanup of obsolete bronze PDF path files and need to reclaim storage. Which command fits?
- A water utility wants Databricks/Spark diagnostic logs queryable alongside other Azure ops signals. What should they implement?
- Emergency management needs timely notice when Databricks job failure metrics rise during storm season. What should they configure?
- Library batch jobs cache a MARC landing set, but each run reads changing drops so cache hits stay poor. What should they conclude?
- A 311 query profile shows a shuffle-heavy join to a small category dimension. What mitigation fits?
- County analysis shows executor loss on a noisy-neighbor pool leaving a workload stuck. What operational response fits?
- A city wants lower cost and faster parking-citation dashboards by combining compute and Delta maintenance improvements. Which pairing fits?
- Housing discovers a runaway Lakeflow Job rewriting an entire gold table from a bad parameter. What control should they use immediately?
- Transit morning SLAs slip and ops has both Azure Monitor metrics and Spark UI stage data. How should they investigate?
- Public works must schedule OPTIMIZE and VACUUM without colliding with peak hydrant-inspection ingest. What planning approach fits?
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.