Home / Data Analyst practice test / Understanding of Databricks Data Intelligence Platform / Question

Databricks Data Analyst Associate · free practice question

A solutions architect is designing a new data platform on Databricks. She has three distinct requirements: (1) ingest streaming events from Apache Kafka and…

Exam-style question on Understanding of Databricks Data Intelligence Platform from the free Data Analyst practice test, with the answer and a full explanation below.

Updated November 10, 2026

Understanding of Databricks Data Intelligence Platform

A solutions architect is designing a new data platform on Databricks. She has three distinct requirements: (1) ingest streaming events from Apache Kafka and declaratively apply multi-hop transformations before writing clean data to Delta tables, (2) enforce fine-grained column-level access controls and capture data lineage across all data assets, and (3) schedule and orchestrate a nightly batch aggregation job that depends on the successful completion of the streaming pipeline. Which combination of Databricks platform components BEST maps to these three requirements, in order?

  1. ARequirement 1: Databricks SQL, which runs streaming SQL queries on SQL warehouses to ingest Kafka events and apply multi-hop transformations; Requirement 2: Delta Lake, which has built-in row-level and column-level access policies that integrate with LDAP directories and record lineage in the transaction log; Requirement 3: Mosaic AI, which provides MLOps-style orchestration for scheduling batch aggregation pipelines as recurring training jobs.
  2. BRequirement 1: Lakeflow Spark Declarative Pipelines, a declarative SQL/Python framework for multi-hop batch and streaming pipelines with a Kafka source connector; Requirement 2: Unity Catalog, which enforces fine-grained access with column masks and row filters and captures column-level lineage; Requirement 3: Lakeflow Jobs, which orchestrates workflows with task dependencies and starts runs on cron schedules or on upstream task success.
  3. CRequirement 1: Lakeflow Jobs, which consumes Kafka events in real time and applies streaming transformations through long-running background tasks; Requirement 2: Mosaic AI, which manages access permissions and lineage for features and tables through its Feature Store governance layer; Requirement 3: Delta Lake, which has a built-in cron scheduler that starts OPTIMIZE and aggregation jobs when new data partitions are detected.
  4. DRequirement 1: Unity Catalog, which has built-in Kafka ingestion connectors that route incoming messages to the right schema according to access control policies; Requirement 2: Databricks SQL, which offers a visual column masking editor in the SQL Editor and generates lineage diagrams from query patterns; Requirement 3: Lakeflow Spark Declarative Pipelines, the recommended scheduler for nightly compaction and aggregation batches.
  5. ERequirement 1: Delta Lake, which provides native Apache Kafka consumer clients that ingest streaming events and apply schema enforcement before writing transactions; Requirement 2: Lakeflow Jobs, which manages column-level security by running identity-aware job clusters that restrict columns to the job owner's permissions; Requirement 3: Unity Catalog, which has a built-in cron trigger that schedules nightly aggregation workflows on registered tables.
Answer & explanation

Correct answer: B

WHY B: Each requirement maps to the described component. (1) Lakeflow Spark Declarative Pipelines (formerly Delta Live Tables) is a declarative framework for batch and streaming pipelines in Python/SQL. It includes connectors for sources such as Apache Kafka, Amazon Kinesis, and Google Pub/Sub, and supports multi-hop transformations through Bronze, Silver, and Gold layer patterns. (2) Unity Catalog is the unified governance layer that enforces column-level masking and row-level security through dynamic views and table policies, and it tracks column-level lineage, capturing which upstream tables, views, and notebooks produced each output column. (3) Lakeflow Jobs is the workflow orchestration service that schedules and runs tasks (notebooks, pipelines, SQL queries, Python scripts) with dependency chains, cron triggers, and retry logic.

WHY NOT A: Databricks SQL is designed for BI analytics queries and dashboards, not for stateful streaming ingestion from Kafka; SQL warehouses are not long-running Kafka consumers. Delta Lake is a storage format with transaction support and has no access policy enforcement engine; that role belongs to Unity Catalog. Mosaic AI is the AI/ML platform, not a workflow scheduling service.

WHY NOT C: Lakeflow Jobs is an orchestration service for scheduling tasks; it does not act as a Kafka streaming consumer or apply streaming transformations. Mosaic AI's Feature Store manages ML features, not general-purpose table access controls. Delta Lake has no built-in cron scheduler; scheduling is handled by Lakeflow Jobs.

WHY NOT D: Unity Catalog is a governance layer and has no Kafka connectors or streaming ingestion capabilities. Databricks SQL does not provide a visual column masking editor that generates lineage; column masking is configured through Unity Catalog policies. Lakeflow Spark Declarative Pipelines is a pipeline framework, not a job scheduler for triggering batch compaction runs.

WHY NOT E: Delta Lake is a storage layer format (ACID transactions, time travel, schema enforcement) and has no Kafka consumer clients; the ingestion framework with Kafka connectivity is Lakeflow Spark Declarative Pipelines. Lakeflow Jobs applies cluster-level access modes but does not enforce column-level security, which is Unity Catalog's role. Unity Catalog is a governance system, not a pipeline scheduler.

Take the full Data Analyst practice test free →

Would you pass today?

This question is one of 45 in the free, timed Databricks Data Analyst Associate practice test. Take it and get a section-by-section score.

Start the free test →