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 24 discussion

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

HOTSPOT
-

You attempt to use Power Query Editor to create a custom column and receive the error message shown in the following exhibit.



Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.

NOTE: Each correct selection is worth one point.

Show Suggested Answer Hide Answer
Suggested Answer:
by MarcoW91PL at April 4, 2023, 12:58 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
RazaTheLegend
Highly Voted 2 years ago
Given answers are correct
upvoted 46 times
...
Igetmyrole
Highly Voted 1 year, 8 months ago
Mismatched data types and A1 are the correct answers. The custom column expression is trying to concatenate (use the "&" operator) a text value and a number value, which are mismatched data types. In this case, the left side of the operator is a text value (e.g.,"A"), and the right side is a number value (e.g.,1). To achieve the desired outcome of the custom column as "A1", you should ensure that both sides of the "&" operator have the same data type, which is text in this case.
upvoted 20 times
...
BP215
Most Recent 5 days, 18 hours ago
Correct answer
upvoted 1 times
...
LuluSkyy
7 months ago
correct
upvoted 1 times
...
rcaliandro
8 months, 3 weeks ago
The error is caused by mismatched data types (text and number). The desired outcome of the custom column is A1. The given answer is OK
upvoted 2 times
...
Kiran37
9 months, 2 weeks ago
correct answer
upvoted 1 times
...
PBI2916
1 year, 4 months ago
I tried "A"&1 to create custom column . It gives the same error as shown in the picture.
upvoted 2 times
...
KARELA
1 year, 11 months ago
can someone please share the resource from where this is referenced?
upvoted 2 times
...
Shalaleh
2 years ago
Given answer is correct.
upvoted 5 times
...
dataguru08
2 years ago
Can someone please explain why is it A1?
upvoted 2 times
joaowendling
2 years ago
In the error message, you can see that we are trying to concatenate two "parts", the left one (which is "A") and the right one (which is the number 1). The "&" is how we are concatenating (in Power Query the syntax "abc"&"def" will result in "abcdef"
upvoted 20 times
...
...
lizbette
2 years ago
can someone explain the syntax? where did the "&" come from? what does the { } mean"
upvoted 5 times
...
abhishek15695121
2 years, 1 month ago
given answers are correct
upvoted 3 times
...
MarcoW91PL
2 years, 1 month ago
Correct Answer
upvoted 2 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