Answer-first summary for fast verification
Answer: No
The goal is to identify whether maintenance tasks were performed on the Delta table 'Customer'. The proposed solution uses 'DESCRIBE DETAIL customer', which provides general metadata about the table (e.g., format, location, schema) but does not include maintenance history. Community discussion (with high upvotes) confirms that 'DESCRIBE DETAIL' is insufficient for this purpose and suggests using 'DESCRIBE HISTORY' instead, as it specifically shows historical operations like OPTIMIZE and VACUUM. Therefore, the solution does not meet the goal.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
You have a Fabric tenant containing a lakehouse named Lakehouse1, which 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 DETAIL customer
DESCRIBE DETAIL customer
Does this solution meet the goal?
A
Yes
B
No
No comments yet.