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

Databricks Data Analyst Associate · free practice question

A data engineering team is evaluating the Databricks Data Intelligence Platform for the first time. A team member lists several platform components and assigns…

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 data engineering team is evaluating the Databricks Data Intelligence Platform for the first time. A team member lists several platform components and assigns each one a primary role. Which of the following descriptions CORRECTLY matches a platform component to its primary purpose?

  1. ALakeflow Spark Declarative Pipelines provides unified governance, access control and lineage tracking across the data and AI assets on the platform; it enforces fine-grained table permissions through ANSI SQL GRANT and REVOKE statements and supports cross-workspace data discovery through a centralized metadata catalog.
  2. BLakeflow Jobs is a declarative pipeline framework for defining and executing batch or streaming ETL transformations written in SQL or Python; its main contribution is the ability to define streaming tables and materialized views that refresh as new source data arrives, without hand-written trigger logic.
  3. CMosaic AI is the integrated AI and machine learning platform on Databricks for building, deploying and managing AI applications; it covers generative AI agents, Foundation Model APIs, Vector Search for RAG, AutoML for automated model training, Model Serving endpoints, and MLflow-based experiment tracking and model lifecycle management.
  4. DUnity Catalog is the performance-optimized query execution engine in the Databricks Runtime; it accelerates SQL and DataFrame workloads by replacing the standard Apache Spark execution engine with a vectorized native engine called Photon, which processes data at native CPU speed without code changes.
  5. EDatabricks SQL is a machine learning model registry and real-time deployment service; it stores trained model artifacts, manages model versions with approval workflows, and exposes LLMs and classic ML models as auto-scaling REST endpoints that serve inference traffic at low response latencies.
Answer & explanation

Correct answer: C

WHY C: Mosaic AI is the integrated AI and machine learning pillar of the Databricks Data Intelligence Platform. It spans the AI lifecycle: building generative AI applications (Agent Bricks, Agent Framework, AI Playground), accessing foundation models through the Foundation Model APIs, storing and retrieving embeddings with Vector Search for RAG, training classic ML models with AutoML and MLflow tracking, deploying models through Model Serving endpoints, and governing models with Unity Catalog.

WHY NOT A: Unified governance, access control, lineage, GRANT/REVOKE statements and a cross-workspace metadata catalog describe Unity Catalog. Lakeflow Spark Declarative Pipelines (formerly Delta Live Tables) is a framework for building batch and streaming pipelines with declarative SQL/Python, not a governance system.

WHY NOT B: A declarative pipeline framework with streaming tables and materialized views describes Lakeflow Spark Declarative Pipelines, not Lakeflow Jobs. Lakeflow Jobs is the workflow orchestration service: it schedules and runs notebooks, scripts and pipeline triggers on a cron or event-driven basis. They are distinct products.

WHY NOT D: A vectorized query engine called Photon describes the Photon component of the Data Intelligence Engine, not Unity Catalog. Unity Catalog's role is data governance (access control, auditing, lineage, metadata management), not query acceleration.

WHY NOT E: Databricks SQL is the SQL analytics and BI layer: SQL warehouses, the SQL Editor, AI/BI Dashboards and Genie spaces for analysts to run queries and build dashboards. It is not a model registry or serving service; model serving and the MLflow model registry are functions of Mosaic AI.

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 →