Exam PL-300 All Questions

View all questions & answers for the PL-300 exam

Exam PL-300 topic 1 question 24 discussion

Actual exam question from Microsoft's PL-300

Question #: 24
Topic #: 1

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

Suggested Answer:

by MarcoW91PL at April 4, 2023, 12:58 p.m.

Comments

Submit Cancel

RazaTheLegend

Highly Voted 2 years, 2 months ago

Given answers are correct

upvoted 47 times

...

Igetmyrole

Highly Voted 1 year, 9 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 2 months ago

Correct answer

upvoted 1 times

...

LuluSkyy

9 months ago

correct

upvoted 1 times

...

rcaliandro

10 months, 2 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

11 months, 2 weeks ago

correct answer

upvoted 1 times

...

PBI2916

1 year, 6 months ago

I tried "A"&1 to create custom column . It gives the same error as shown in the picture.

upvoted 2 times

...

KARELA

2 years, 1 month ago

can someone please share the resource from where this is referenced?

upvoted 2 times

...

Shalaleh

2 years, 1 month ago

Given answer is correct.

upvoted 5 times

...

dataguru08

2 years, 2 months ago

Can someone please explain why is it A1?

upvoted 2 times

joaowendling

2 years, 1 month 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 21 times

...