Free Microsoft Power BI PL-300 Actual Exam Questions - Question 14 Discussion
You need to configure the query to display the data as shown in the following exhibit.
Which step should you use in the query?
B tbh doesn’t feel right since unpivoting usually turns columns into rows, but here they want to separate a single column into multiple class columns. A’s delimiter is off, so it probably fails. D relies on fixed character positions which is risky if the data isn’t uniform. C is the only one that splits by commas which matches the data format shown in the second image, so that makes the most sense to me.
Maybe D works since it splits the column by fixed positions, which could help if the classes are consistently formatted in fixed-width fields. The other options either try to split by commas or unpivot, but if the data's layout is more about fixed character lengths, D might actually produce cleaner columns matching the target output. It’s worth considering if commas aren’t reliable delimiters in this case.
Option C looks better because it specifically splits the "classes" column by commas, which matches the target output of separate class columns. The other choices either mess up delimiters or don’t split properly.
C imo, splitting the "classes" column by comma directly matches the shown output with separate class columns. The others seem off with either typos or using wrong split logic for this data.
I think option C makes the most sense here. Since the data in the classes column looks comma-separated, splitting by that delimiter directly breaks it into separate columns as shown in the target. Option A tries to expand a list, but if the data isn't already a list type, that won’t work. Also, the function in C is straightforward for splitting text columns by delimiter, which matches the example output. So I’d go with C.
D imo, splitting by fixed positions (option D) looks off since the data seems comma-separated. B makes less sense because unpivoting usually reshapes columns, not splitting list-like data.
A/C? Option A is about expanding a list column which fits the goal, but the delimiter issue is real. Option C splits by delimiter, which might also work if the data is comma-separated, but it lacks the expand step.
Option A looks like it’s splitting and expanding a list properly here.