Exam DP-500 topic 1 question 175 discussion

Actual exam question from Microsoft's DP-500

Question #: 175
Topic #: 1

HOTSPOT
-

You deploy an 80-GB compressed data model to a Power BI Premium workspace.

You discover that the model has the following issues:

• The model recently increased excessively in size.
• Date columns are formatted inconsistently.
• Measures calculate slowly.

Which tool should you use to troubleshoot each issue? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Show Suggested Answer

Suggested Answer:

by Qordata at Dec. 14, 2023, 11:06 a.m.

Comments

Submit Cancel

tangerine141

1 year, 1 month ago

Power query diagnostic Tabular Editor Dax studio

upvoted 1 times

...

Momoanwar

1 year, 5 months ago

Chatgpt : To troubleshoot the issues in the Power BI data model, you would use the following tools: - The model has recently increased excessively in size: **DAX Studio** - DAX Studio can be used to analyze the model and its storage by using the VertiPaq Analyzer feature, which can identify large tables, columns, and relationships that may be contributing to the size increase. - Date columns are not consistently formatted: **Tabular Editor** - Tabular Editor can quickly inspect and update the formatting of date columns across the entire model. - Measures are calculating slowly: **DAX Studio** - DAX Studio can analyze the performance of DAX measures through query execution breakdowns and performance tuning features.

upvoted 1 times

...

MaryemSB

1 year, 5 months ago

DAX Studio Tabular Editor (using Best Practice Analyser) DAX Studio

upvoted 1 times

MaryemSB

1 year, 5 months ago

check below link: https://datamartin.ca/2022/09/29/tools-to-analyze-the-performance-of-your-power-bi-solution/

upvoted 1 times

...