DP-500 · Question #116
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…
The correct answer is A. Yes. Removing high-cardinality unique identifier columns, such as IoT GUID or IoT ID, that are not necessary for the required time-based analysis, improves dataset performance.
Question
Exhibit
Options
- AYes
- BNo
How the community answered
(52 responses)- A75% (39)
- B25% (13)
Why each option
Removing high-cardinality unique identifier columns, such as IoT GUID or IoT ID, that are not necessary for the required time-based analysis, improves dataset performance.
High-cardinality unique identifier columns like IoT GUID and IoT ID consume significant memory in a Power BI dataset and negatively impact performance and compression. Since the analysis requires only 'hour' and 'day of the year' from the IoT DateTime column, removing these unneeded unique ID columns will effectively reduce dataset size and improve performance without affecting the required analysis.
Removing unique identifier columns that are not used for analysis is a common optimization technique in Power BI to reduce model size and improve query performance, thus stating 'No' would be incorrect.
Concept tested: Power Query data profiling and performance optimization
Source: https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-profiling-data
Topics
Community Discussion
No community discussion yet for this question.
