DP-600 · Question #44
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 h
The correct answer is B. No. A Spark command that displays only the schema or basic properties of a table, rather than its operational history, would not identify maintenance tasks.
Question
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?
Options
- AYes
- BNo
How the community answered
(54 responses)- A19% (10)
- B81% (44)
Why each option
A Spark command that displays only the schema or basic properties of a table, rather than its operational history, would not identify maintenance tasks.
For the solution to meet the goal of identifying maintenance tasks, it would need to query the Delta Lake transaction log or operational history, which commands showing only table schema or basic properties do not provide.
A Spark command like `DESCRIBE TABLE <table_name>` or `SHOW TABLES` provides metadata such as column names, data types, and partitioning information, but it does not record or display the historical operations or maintenance actions performed on the Delta table.
Concept tested: Delta Lake table metadata vs. operational history
Source: https://spark.apache.org/docs/latest/sql-ref-syntax-aux-describe-table.html
Topics
Community Discussion
No community discussion yet for this question.