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?
Show 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.