Home / Data Analyst practice test / Managing Data / Question

Databricks Data Analyst Associate · free practice question

A data analyst at a retail company wants to confidently use only high-quality, authoritative datasets for their quarterly revenue report. Their Databricks…

Exam-style question on Managing Data from the free Data Analyst practice test, with the answer and a full explanation below.

Updated November 10, 2026

Managing Data

A data analyst at a retail company wants to confidently use only high-quality, authoritative datasets for their quarterly revenue report. Their Databricks workspace is enabled for Unity Catalog. Which combination of Unity Catalog features and behaviors BEST supports the analyst in discovering trustworthy datasets, confirming their quality status, and querying them alongside internal tables?

  1. AThe analyst opens the Delta transaction log of each candidate table and checks the _delta_log directory for a JSON quality certificate entry appended by a data steward; tables whose log contains the entry are certified. Queries on certified tables then add a CERTIFIED ONLY keyword, which the Databricks Runtime uses to keep certified and uncertified data from being mixed in one SELECT statement.
  2. BThe analyst uses the workspace search bar or Catalog Explorer to browse tables across catalogs, filters by the 'Certified' endorsement that data stewards apply to tables meeting quality standards, and reads each table's description for context. The chosen tables are then queried with the standard three-part name (catalog.schema.table) in the SQL Editor or a notebook and joined with internal tables; certification is a trust signal, not a query restriction.
  3. CCertified datasets are stored in a dedicated system catalog named certified_data that Databricks provisions when a workspace is created. To query one, the analyst runs USE CATALOG certified_data before the SELECT; a statement that references a table from another catalog alongside a certified_data table raises a cross-catalog certification error, so such comparisons are written as separate queries and joined in Python.
  4. DUnity Catalog does not offer certification or quality endorsements at the table level; certification is a Databricks Marketplace feature for externally published datasets. Internal tables can carry a user-defined tag such as 'certified=true', but that tag is handled like other metadata tags and gets no special treatment in Catalog Explorer or search, so the analyst confirms quality by asking each table owner directly.
  5. EThe analyst asks a workspace administrator to run the CLI command databricks unity-catalog certify --table catalog.schema.table --force-quality-scan on each candidate table. The command starts a data profiling job that scores each column on a 0–100 completeness scale; tables scoring above 80 are promoted to the system.certified schema for querying, and the others are flagged with an UNCERTIFIED comment in INFORMATION_SCHEMA.
Answer & explanation

Correct answer: B

WHY B: Unity Catalog supports discovery through Catalog Explorer and the workspace search bar, where data stewards apply 'Certified' endorsements (also called quality labels or certifications) to tables validated as authoritative and high-quality. The endorsement appears as a visual indicator in Catalog Explorer next to the table's description, owner, tags and documentation, so analysts identify trustworthy datasets without opening data files or reading logs. The table is then queried with the standard three-part namespace (catalog.schema.table), the same syntax as any registered table. Certification is a discoverability and governance feature, not a query restriction: certified tables are queried like uncertified ones and can be joined freely with other Unity Catalog tables in one SQL statement.

WHY NOT A: Parsing the _delta_log directory is not a supported or documented way to identify certified datasets. Delta transaction logs record DML/DDL operations, schema evolution and file statistics and have no concept of a quality certificate entry. The CERTIFIED ONLY keyword does not exist in Databricks SQL.

WHY NOT C: There is no system-provisioned certified_data catalog; certified tables stay in their normal catalog and schema, and the endorsement can be applied to a registered table in any catalog. No cross-catalog certification restriction exists: Unity Catalog allows joining tables across catalogs in a single SQL query with the three-part namespace.

WHY NOT D: Unity Catalog does support quality endorsements and certification labels at the table level, a documented feature available through Catalog Explorer and the REST API. User-defined tags can also be applied, but the 'Certified' endorsement is a distinct, first-class UI feature with dedicated treatment in search and Catalog Explorer, not an arbitrary custom tag.

WHY NOT E: No databricks unity-catalog certify CLI command exists. Certification is managed through the Catalog Explorer UI or the REST API via the table properties endpoint, not through a CLI quality-scan pipeline, and tables are not moved to a system.certified schema on the basis of profiling scores.

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 →