A Databricks SQL dashboard has been configured to monitor the total number of records present in a collection of Delta Lake tables using the following query pattern:
SELECT COUNT (*) FROM table -
Which of the following describes how results are generated each time the dashboard is updated?
The total count of records is calculated from the Delta transaction logs. Delta Lake optimizes COUNT(*) queries by storing the row counts in the transaction logs, thereby avoiding the need for a full table scan and significantly improving query performance.
I would've said C
Correct Answer: C
Delta Lake optimizes COUNT(*) queries by reading the row counts stored in the Delta transaction log. This eliminates the need for a full table scan, resulting in significantly faster query performance. pen_spark
C is correct
C is correct