Free Preparation Discussions
MENU
Microsoft Exam DP-600 Topic 4 Question 21 Discussion
Topic #: 4
You have a Fabric tenant tha1 contains a takehouse 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:
EXPLAIN TABLE customer
Does this meet the goal?
The Table.Profile function in Power Query is used to generate column statistics such as count, average, null count, distinct count, and standard deviation. You can use this function as follows:
Invoke the Power Query Editor.
Apply the Table.Profile function to your table.
The result will be a table where each row represents a column from the original table, and each column in the result represents a different statistic such as those listed in the requirement.
Dudley
22 hours ago