Implementing Analytics Solutions Using Microsoft Fabric — Question 47

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a Fabric tenant that contains a lakehouse named Lakehouse1. Lakehouse1 contains a Delta table named Customer.
When you query Customer, you discover that the query is slow to execute. You suspect that maintenance was NOT performed on the table.
You need to identify whether maintenance tasks were performed on Customer.
Solution: You run the following Spark SQL statement:

REFRESH TABLE customer -
Does this meet the goal?

Answer options

Correct answer: B

Explanation

The correct answer is B because the REFRESH TABLE command is used to refresh the metadata of a table, but it does not perform maintenance tasks such as vacuuming or optimizing the table. Therefore, while it may help with query execution, it does not confirm if maintenance tasks have been conducted on the Customer table.