Home / Data Analyst practice test / Executing queries using Databricks SQL and Databricks SQL Warehouses / Question

Databricks Data Analyst Associate · free practice question

A data analyst opens a table result in a Databricks notebook and wants to automatically see summary statistics for all column types — including distributions…

Exam-style question on Executing queries using Databricks SQL and Databricks SQL Warehouses from the free Data Analyst practice test, with the answer and a full explanation below.

Updated November 10, 2026

Executing queries using Databricks SQL and Databricks SQL Warehouses

A data analyst opens a table result in a Databricks notebook and wants to automatically see summary statistics for all column types — including distributions, value counts, null percentages, and histograms — without writing any SQL. Which built-in Databricks feature provides this automatically?

  1. ARunning SELECT * FROM table LIMIT 100 — the result grid adds a statistics footer under each column that shows its distribution, distinct value count and null percentage for the returned rows
  2. BRunning DESCRIBE table_name — returns the column names and data types together with computed statistics for each column, including value distributions, null percentages and a histogram of values
  3. CThe data profile in a notebook result cell — computes summary statistics (min, max, mean, standard deviation, null count) for numeric columns, value frequencies for strings and a histogram per column
  4. DRunning SHOW CREATE TABLE table_name — outputs the table definition along with the column statistics collected at creation, such as value counts, null percentages and distribution histograms
  5. ERunning EXPLAIN EXTENDED on a SELECT query — returns the query plan together with per-column descriptive statistics, value counts and histograms that the optimizer renders in the result cell
Answer & explanation

Correct answer: C

WHY C: The notebook data profile (the profile tab in a result cell) computes and visualizes per-column summary statistics and distributions across column types: min, max, mean, standard deviation and null count for numeric columns, value frequencies for string columns, date range information for date columns, and a histogram per column. No SQL has to be written.

WHY NOT A: SELECT * with LIMIT returns a sample of raw rows; no summary statistics, distribution charts or null percentages are computed for the result grid.

WHY NOT B: DESCRIBE returns schema metadata (column names, data types, comments), not runtime statistics or distributions of column values.

WHY NOT D: SHOW CREATE TABLE returns the DDL that defines the schema, storage format and table properties; it is purely structural and holds no information about the data.

WHY NOT E: EXPLAIN EXTENDED returns the logical and physical plan with optimizer estimates, not human-readable per-column descriptive statistics or histograms.

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 →