Microsoft Exam DA-100 Topic 8 Question 21 Discussion

Actual exam question for Microsoft's DA-100 exam

Question #: 21
Topic #: 8

You 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.ExpandListColum(Table.TransformColunins(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.SplitTextByDelimiterf',', QuoteStyle.None), {'classes.1'})

D= Table.SplitColumn(Source, 'classes'. Splitter.SplitTextByPositions({10}), {'classes.1'})

Show Suggested Answer

Suggested Answer: D

by Kenneth at May 03, 2022, 03:30 PM

Limited Time Offer

25%

Off

Get Premium DA-100 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

KA FAI MICAHEL LAI

2 years ago

The answer should be A. Tale.SplitColumn only splits the string into extra columns. Splitting strings into rows should be done by ExpandListColumn.

upvoted 1 times

...