DP-203 Develop data processing Practice Question
Which TWO features of Azure Databricks help manage data governance and security for sensitive data?
⚠ Common exam trap
Candidates often confuse data processing features (Structured Streaming, Auto Loader, Delta Live Tables) with governance/security tools, because all are part of the Databricks ecosystem but serve fundamentally different purposes.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Secret Scopes
Secret Scopes (B) allow secure storage and referencing of sensitive credentials (e.g., API keys, database passwords) in Azure Databricks, preventing hardcoding in notebooks. Unity Catalog (E) provides fine-grained access control, data lineage, and centralized metadata management across workspaces, enabling governance of sensitive data through policies and auditing.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Structured Streaming
Why it's wrong here
Structured Streaming is a stream-processing engine for incremental data pipelines, providing no access control, masking or auditing. It is tempting because it handles sensitive event data in motion, but governance requires Unity Catalog, row filters and column masks.
- ✓
Secret Scopes
Why this is correct
Secret Scopes store credentials in Databricks-backed or Microsoft Entra ID-backed vaults, then expose them through redacted references in notebooks and jobs. This prevents hard-coded secrets in code, directly satisfying the governance requirement to protect sensitive authentication material used by analytics workloads.
- ✗
Auto Loader
Why it's wrong here
Auto Loader incrementally ingests new files from cloud storage into Delta tables; it enforces no access control, masking or auditing. It is tempting because it handles schema evolution and file notification at scale, which suits streaming ingestion scenarios, but governance of sensitive data requires Unity Catalog privileges and dynamic views instead.
- ✗
Delta Live Tables
Why it's wrong here
Delta Live Tables orchestrates declarative ETL pipelines with data-quality expectations, not access control or column-level masking. It is tempting because expectations can quarantine bad records, but that governs data quality, not governance of sensitive data; Unity Catalog and row filters/column masks are the features that restrict who sees what.
- ✓
Unity Catalog
Why this is correct
Unity Catalog provides a centralised metastore enforcing fine-grained access control, auditing and lineage across workspaces and clouds. It satisfies the governance requirement by letting administrators grant table, column and row-level privileges on sensitive data through one consistent permission model.
Go deeper
Related to this question
About these practice questions
This DP-203 question is part of Courseiva's 509-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This DP-203 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DP-203 exam.