Free Preparation Discussions
MENU
Microsoft Exam DP-600 Topic 2 Question 27 Discussion
Topic #: 2
You have a Fabric tenant that 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:
DESCRIBE HISTORY customer
Does this meet the goal?
To identify surrogate key columns with the 'Summarize By' property set to a value other than 'None,' the Best Practice Analyzer in Tabular Editor is the most efficient tool. The Best Practice Analyzer can analyze the entire model and provide a report on all columns that do not meet a specified best practice, such as having the 'Summarize By' property set correctly for surrogate key columns. Here's how you would proceed:
Open your Power BI model in Tabular Editor.
Go to the Advanced Scripting window.
Write or use an existing script that checks the 'Summarize By' property of each column.
Execute the script to get a report on the surrogate key columns that do not have their 'Summarize By' property set to 'None'.
You can then review and adjust the properties of the columns directly within the Tabular Editor.
Rashad
6 hours ago