Exam 70-778 topic 1 question 45 discussion

Actual exam question from Microsoft's 70-778

Question #: 45
Topic #: 1

HOTSPOT -
You have a query that retrieves data from a Microsoft Azure SQL database.
You discover that a column named ErrorCode has several values starting with a space character, and a column named SubStatus contains several non-printable characters.
You need to remove all the leading whitespaces from ErrorCode and all the non-printable characters from SubStatus. All other data must be retained.
What should you do on each column? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer

Suggested Answer:

References:
https://msdn.microsoft.com/en-us/library/mt260494.aspx
https://msdn.microsoft.com/en-us/library/mt253328.aspx

by cromastro at Aug. 26, 2020, 11:02 p.m.

Comments

Submit Cancel

CDL

4 years, 7 months ago

correct. https://docs.microsoft.com/en-us/powerquery-m/text-trim https://docs.microsoft.com/en-us/powerquery-m/text-clean also could do it via PQ editor Ribbon tab "transform" or simply select the target column and then "right click" and then select "transform".

upvoted 2 times

...

cromastro

4 years, 9 months ago

I don't know of any Format or Extract menus in Power Query, but there are Text.Clean and Text.Trim functions. So, I guess by using a little logic you can pick the right answers. Not sure where this question came from. Old version of Power Query?

upvoted 1 times

cromastro

4 years, 9 months ago

Transform>Text Column>Format ... Has both Clean and Trim ... Microsoft calls them Ribbons. That threw me off.

upvoted 2 times

...