ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam PL-300 All Questions

View all questions & answers for the PL-300 exam
Go to Exam

Exam PL-300 topic 1 question 35 discussion

Actual exam question from Microsoft's PL-300
Question #: 35
Topic #: 1
[All PL-300 Questions]

HOTSPOT
-

You use Power Query Editor to preview the data shown in the following exhibit.



You confirm that the data will always start on row 3, and row 3 will always contain the column names.

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

NOTE: Each correct selection is worth one point.

Show Suggested Answer Hide Answer
Suggested Answer:
by faruk3d at Sept. 4, 2024, 7:33 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
LuluSkyy
Highly Voted 7 months ago
Answer is correct Remove Top 2 rows Use first rows as headers
upvoted 9 times
...
rcaliandro
Most Recent 7 months, 4 weeks ago
The answer is correct. We need to remove top 2 rows first and then user first row as headers
upvoted 3 times
...
faruk3d
8 months ago
-remove top rows -use first row as headers
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago