Answer-first summary for fast verification
Answer: No
The EXPLAIN statement in Spark SQL is used to display the execution plan of a query, showing how Spark will process and execute the query. It provides details about operations, stages, and optimization strategies for query performance analysis. However, it does not provide historical information about maintenance tasks such as optimization, compaction, or vacuuming performed on Delta tables. To check maintenance history on a Delta table in Fabric, the correct approach is to use the DESCRIBE HISTORY command (e.g., DESCRIBE HISTORY customer), which shows a log of operations including maintenance tasks. The community discussion unanimously supports answer B (No), with the highest upvoted comment (8 upvotes) clearly explaining that EXPLAIN is for execution plans, not maintenance history. Other comments reinforce this with references to DESCRIBE HISTORY as the correct alternative.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
You have a Fabric tenant containing a lakehouse named Lakehouse1. Lakehouse1 has a Delta table named Customer. Querying the Customer table is slow, and you suspect that maintenance tasks were not performed on it.
You need to determine if maintenance was performed on the Customer table.
Proposed Solution: Run the following Spark SQL statement:
EXPLAIN TABLE Customer
EXPLAIN TABLE Customer
Does this solution meet the goal?
A
Yes
B
No
No comments yet.