You have a table in Power BI Desktop that contains the following data: You want to create a custom column that only displays the last four digits of the SSN column and masks all the other digits. Which Power Query M formula should you use?

Below are free DA-100 sample questions, each with the answer and an explanation. They cover Power Query data preparation, DAX measures and report design from the retired exam. Use them for Power BI review, then check the PL-300 outline before you book.
Showing 4 of 8 free sample questions.

Create a free account to unlock the whole DA-100 sample bank, or get full access to all 261 practice questions in the simulator.