Home / ML Associate practice test / Databricks Machine Learning / Question

Databricks Machine Learning Associate · free practice question

A data scientist wants to create a new Unity Catalog feature table for customer features using SQL. Which requirement must be satisfied for the table to…

Exam-style question on Databricks Machine Learning from the free ML Associate practice test, with the answer and a full explanation below.

Updated November 10, 2026

Databricks Machine Learning

A data scientist wants to create a new Unity Catalog feature table for customer features using SQL. Which requirement must be satisfied for the table to function as a feature table?

  1. AThe underlying Unity Catalog Delta table must include a primary key constraint, because feature tables in Unity Catalog are Delta tables identified by their governed key structure
  2. BThe table must be created as a temporary view first, because Unity Catalog feature tables are not allowed to be backed by permanent Delta tables when model lineage is enabled
  3. CThe table must be registered in the workspace model registry before any feature engineering API can recognize it, because model governance is the prerequisite for feature table metadata in Databricks
  4. DThe table must be created with Photon disabled, because Databricks Feature Engineering in Unity Catalog uses a non-Photon execution engine for all primary key enforcement and schema validation
  5. EThe table must contain at least one model prediction column at creation time, because Databricks will not classify a Delta table as a feature table unless a training target is already embedded in the schema
Answer & explanation

Correct answer: A

WHY A: UC feature tables are Delta tables and must have a primary key constraint. WHY NOT B: Permanent Delta tables are the normal backing object. WHY NOT C: Workspace model registry is unrelated. WHY NOT D: Photon is not a creation requirement. WHY NOT E: Feature tables do not require prediction or target columns.

Take the full ML Associate practice test free →

Would you pass today?

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

Start the free test →