Ultimate access to all questions.
Answer-first summary for fast verification
Answer: No
The REFRESH TABLE command in Spark SQL is used to update the metadata cache for a table, ensuring that the latest schema and partition information is available for query execution. However, it does not provide any historical information about maintenance operations performed on the Delta table, such as VACUUM, OPTIMIZE, or ZORDER operations. The community discussion unanimously confirms this with 100% agreement on answer B, and the highest-rated comment (6 upvotes) explicitly states that REFRESH TABLE only ensures latest schema and data availability but gives no historical maintenance information. Therefore, this solution does not meet the goal of identifying whether maintenance tasks were performed.
Author: LeetQuiz Editorial Team
No comments yet.
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:
REFRESH TABLE customer;
REFRESH TABLE customer;
Does this solution achieve the goal?
A
Yes
B
No