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 maintains a transaction log that records details about every change made to a table, including the number of records in each file. This allows the system to efficiently calculate the total number of records without needing to scan all the data files.
Transaction log provides statistics about the delta table.
Delta Lake maintains a transaction log that records details about every change made to a table. When you execute a count operation on a Delta table, Delta Lake can use the information in the transaction log to calculate the total number of records without having to scan all the data files. This is because the transaction log includes information about the number of records in each file, allowing for an efficient aggregation of these counts to get the total number of records in the table.
Answer C https://delta.io/blog/2023-04-19-faster-aggregations-metadata/#:~:text=You%20can%20get%20the%20number,a%20given%20Delta%20table%20version.
total rows will be calculated from delta logs
C - transaction logs contains info about files rows count
The answer is C
The answer should be C
Delta transaction log