Microsoft Certified Azure Enterprise Data Analyst Associate · Free Practice Question Medium
Question 16
Does removing the IoT ID column and keeping the IoT GUID column from the Power Query Editor improve dataset performance while allowing for the analysis of IoT events by the hour and day of the year?
- A Yes
- B No
Reveal correct answer
Correct answer: A
Explanation
Yes, removing the IoT ID column and retaining the IoT GUID column in the Power Query Editor will meet the goal of analyzing IoT events by the hour and day of the year while improving dataset performance. Since the IoT GUID column is unique to each row in the query, it can still be used as a reliable identifier for the events. By removing the IoT ID column, which is not necessary for the analysis, the dataset becomes more streamlined and efficient, resulting in improved performance.Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
You must be logged in to post a comment.
