Exam PL-300 topic 1 question 51 discussion

Actual exam question from Microsoft's PL-300

Question #: 51
Topic #: 1

HOTSPOT
-

You have a query that contains customer data in Power Query Editor as 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 bp_a_user at June 14, 2025, 8:05 a.m.

Comments

Submit Cancel

c42611c

1 month, 3 weeks ago

1. Customer Name 2. Extract the last 12 characters -Customer Name because it has a greater number of distinct vs unique values in the column. This implies that there are repeating values in it. -Second statement requires 10 digits in the phone number. If choose "extract the text after the ")" delimiter", it will leave a leading whitespace for certain rows since there is a space after the ")" in certain rows and this counts as a digit which would make it 11 digits which does NOT meet the requirement. BUT, if we use the other option "Extract the last 12 characters", then it will NOT include the leading whitespace and correctly satisfy the 10 digit requirement as well as not including whitespace which can throw off calculations, sort orders, etc.

upvoted 3 times

...

bp_a_user

2 months ago

correct!

upvoted 1 times

...