Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Microsoft Certified: Power BI Data Analyst Associate · Microsoft
Select one answer.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
✅ Yes, this solution meets the goal. 🧠 Here's why: IoT GUID and IoT ID are both unique identifiers, meaning they likely have high cardinality (i.e., nearly every row has a distinct value). High-cardinality columns consume more memory and compress poorly in Power BI’s in-memory engine (VertiPaq). If only one of them is needed for analysis or relationships (in this case, IoT ID), then removing the other (IoT GUID) helps reduce dataset size and improve performance — without affecting the ability to analyze events by hour or day.
Yes improves dataset performance
this doesn't address the time or date