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.
Given answers are correct
This was on the exam today
With sitting the exam so recently, how did you find it and are you finding these questions align closely to the real exam?
Much better than the microsoft practice exam. Generally I really rate examtopics. There are just no other useful resources IMO
did u study question after the 22nd page also
I found the official Measure Up practice paper useless. I was also disappointed with Skillcertpro's practice papers. From narrowly missing the pass mark, I can say, many of these questions are identical. Have you attempted the exam yet?
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.
This was on the exam
Given answer is correct.
This was on exam yesterday
can someone explain the syntax? where did the "&" come from? what does the { } mean"
given answers are correct
Correct Answer
Can someone please explain why is it A1?
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"
can someone please share the resource from where this is referenced?
I tried "A"&1 to create custom column . It gives the same error as shown in the picture.
De acuerdo con la respuesta
correct answer