Question 45 of 388
Single answerYou have a query that returns the data shown in the following exhibit.You need to configure the query to display the data as shown in the following exhibit.Which step should you use in the query?
✓A= Table.ExpandListColumn(Table.TransformColumns(Source,{{"classes", Splitter.SplitTextByDelimiter(",", QuoteStyle.None),let itemType = (type nullable text) meta [Serialized.Text = true]in type {itemType}}}), "classes")
B= Table.Unpivot(Source, {"classes"}, "Attribute", "Value")
C= Table.SplitColumn(Source, "classes",Splitter.SplitTextByDelimiter(",", QuoteStyle.None),{"classes.1"})
D= Table.SplitColumn(Source, "classes",Splitter.SplitTextByPositions({10}), {"classes.1"})
✓
Correct Answer: A
= Table.ExpandListColumn(Table.TransformColumns(Source,{{"classes", Splitter.SplitTextByDelimiter(",", QuoteStyle.None),let itemType = (type nullable text) meta [Serialized.Text = true]in type {itemType}}}), "classes")
▥
Explanation
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Microsoft certification topics.