nerdexam
Microsoft

PL-300 · Question #209

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. There are two requirements to the question - improve the performance and enable the required analysis. Removing the GUID column will do exactly that - it will improve the performance because it is one less column of data to load but it still enables the required analysis given…

Submitted by miguelv· Apr 18, 2026Prepare the data

Question

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 have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. From Power Query Editor, you profile the data shown in the following exhibit. The IoT GUID and IoT ID columns are unique to each row in query. You need to analyze IoT events by the hour and day of the year. The solution must improve dataset performance. Solution: You remove the loT GUID column and retain the loT ID column. Does this meet the goal?

Exhibit

PL-300 question #209 exhibit

Options

  • AYes
  • BNo

How the community answered

(47 responses)
  • A
    79% (37)
  • B
    21% (10)

Explanation

There are two requirements to the question - improve the performance and enable the required analysis. Removing the GUID column will do exactly that - it will improve the performance because it is one less column of data to load but it still enables the required analysis given the IOT ID column is equally unique.

Topics

#Performance Optimization#Data Reduction#Column Management#Power Query

Community Discussion

No community discussion yet for this question.

Full PL-300 Practice