ExamDumpster

Free DA-100 sample questions

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.

Try them in the simulator Same questions, with study, timed and flashcard modes.

Showing 4 of 8 free sample questions.

Question 1Choose one

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?

Question 2Choose one

You have a Power BI model that has a date table with a date column that displays the date in the format: 2019-12-01 You want the date column to display the date in the format of December 01, 2019. Which DAX formula should you use?

Question 3Choose one

You have the two Power Query M queries in Power BI Desktop. The one query retrieves a table named Customers from a Microsoft SQL Server database while the other query retrieves a table named _Customers from an Oracle database Both the Customers and the _Customers tables have the same columns. You need to combine the data from the two tables. Which Power Query function should you use?

Question 4Choose one

You have a table named Sales. Sales has a column named CustomerID. The CustomerID column contains a few non-numeric values. You want to replace the non-numeric values in the CustomerID column with the number 0.

4 more free samples are waiting

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

Create account