exam questions

Exam PL-300 All Questions

View all questions & answers for the PL-300 exam

Exam PL-300 topic 1 question 41 discussion

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

You use Power Query Editor to preview a column named Date as shown in the following exhibit.



You need to change the Date column to contain only the year. The solution must minimize administrative effort.

What should you do?

  • A. Split the column by delimiter.
  • B. Split the column by number of characters.
  • C. Extract the text after the delimiter.
  • D. Transform the column to contain only the year.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️

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
BhavnishM
2 months, 1 week ago
Selected Answer: D
all 4 solutions will lead to the desired result. But A,B,C will require additional steps.
upvoted 1 times
...
Fatima300
4 months, 1 week ago
Selected Answer: D
D. Transform the column to contain only the year. You can do this by selecting the "Date" column, then choosing Transform > Date > Year in Power Query Editor, which will automatically convert the column to show only the year.
upvoted 3 times
...
ee0625a
4 months, 2 weeks ago
Selected Answer: D
D. Transform the column to contain only the year is the fastest and most efficient method in Power Query.
upvoted 1 times
...
a5de5a2
5 months ago
Selected Answer: A
Option A If we need to minimize administrative efforts , we ideally should use built in delimeter in power query
upvoted 3 times
...
Ricky_lm
6 months ago
Selected Answer: D
Select Column - Transform - Date - Year - Year
upvoted 2 times
...
ChopChop007
8 months ago
Selected Answer: D
D it is.
upvoted 3 times
...
Davery
8 months, 2 weeks ago
Selected Answer: D
D is the correct answer - Transform the column to contain only the year. This approach directly modifies the column to display only the year, without the need for additional steps like splitting or extracting text.
upvoted 3 times
LuluSkyy
8 months, 1 week ago
I agree.
upvoted 1 times
...
...
b92fc92
8 months, 2 weeks ago
Selected Answer: D
Why A? the column is Date type, so D is possible, D in my opinion
upvoted 4 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
Loading ...