Answer-first summary for fast verification
Answer: Yes
The solution meets the goal because the DESCRIBE HISTORY command in Delta Lake (used in Microsoft Fabric) provides a detailed transaction history of the table, including maintenance operations such as OPTIMIZE and VACUUM. These operations are recorded in the table history and can be reviewed to determine if maintenance tasks were performed. The community discussion strongly supports this with 100% consensus on answer A, multiple upvoted comments referencing Microsoft documentation, and specific mentions that OPTIMIZE and VACUUM activities from the last 30 days are visible in the history. This makes DESCRIBE HISTORY the appropriate command to identify whether maintenance was performed on the Delta table.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
You have a Fabric tenant containing a lakehouse named Lakehouse1. Lakehouse1 includes a Delta table named Customer. Querying the Customer table is slow, and you suspect this is due to a lack of maintenance on the table.
You need to determine if maintenance tasks have been performed on the Customer table.
Proposed Solution: Run the following Spark SQL statement:
DESCRIBE HISTORY Customer;
DESCRIBE HISTORY Customer;
Does this solution meet the goal?
A
Yes
B
No