Databricks Certified Data Engineer - Professional
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
A Databricks SQL dashboard monitors the total record count of a Delta Lake table using the query SELECT COUNT(*) FROM table_name. How are the results efficiently generated when the dashboard is refreshed?*_
A
The record count is derived from the numRecords statistics stored within the Delta transaction log.
B
The row count is computed by performing a full data scan of all underlying Parquet files.
C
The record count is calculated by reading the metadata footers of every Parquet file in the table directory.
D
The record count is determined by querying statistics maintained in the Hive Metastore.
E
The results are exclusively returned from the Databricks SQL result cache, regardless of underlying data changes.