Exam PL-300 topic 2 question 93 discussion

Actual exam question from Microsoft's PL-300

Question #: 93
Topic #: 2

HOTSPOT -

You use Power Query Editor to pull data from a Microsoft SharePoint Online list.

You plan to use Advanced Editor to build a Power Query M formula language query.

You need to create a query that loads the data, expands a column named location, and hides a column named CountryOrRegion from the dataset.

How should you complete the query? To answer, select the appropriate options in the answer area.

NOTE: Each correct answer is worth one point.

Show Suggested Answer

Suggested Answer:

by jiheneB at Sept. 4, 2024, 4:41 p.m.

Comments

Submit Cancel

jiheneB

Highly Voted 7 months, 3 weeks ago

Table.ExpandRecordColumn

upvoted 12 times

...

rcaliandro

Highly Voted 7 months, 3 weeks ago

ExpandRecordColumnn and RemoveColumns

upvoted 7 times

...

esrath

Most Recent 3 months, 2 weeks ago

Table.ExpandRecordColumn as it takes 4 arguments which makes sense if we look at the M Code. Table.ExpandRecordColumn("Table -> TableID", "Column to expand -> Location", "fieldNames => DisplayName", "Nullable new column name -> Location.DisplayName") RemoveColumns to remove/hide columns.

upvoted 2 times

...

jaume

5 months, 1 week ago

No doubt about Table.ExpandListColumn and Table.RemoveColumns for me based on the given options but, should it not be Table.HideColumns for the second one? Question is not about removing but hidding the column

upvoted 1 times

...

23042b9

6 months ago

Its correct.please guys read the question it says the location column in your SharePoint Online list is a list so the answer is correct

upvoted 3 times

...

Endeetheanalyst

7 months, 3 weeks ago

Answer should be Table.ExpandRecordColumn and Table.Removecolumns

upvoted 5 times

...

Exam PL-300 All Questions

View all questions & answers for the PL-300 exam