Sign in

Free DA-100 sample questions

Real questions from the Analyzing Data with Power BI practice bank, with the correct answer and an explanation for each one. No junk, no filler.

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

Showing 4 of 8 free sample questions.

Question 1Choose one

You use Power BI Desktop to create a visualization using a database on SQL database server named SQL01. You want to be able to use Microsoft R scripts in your visualization. You install SQL Server R Services on SQL01. Does this action allow you to use Microsoft R scripts in your visualization?

Question 2Choose one

You use Power BI Desktop to create a visualization using a database on SQL database server named SQL01. You want to be able to use Microsoft R scripts in your visualization. You download and install Microsoft R Open on the computer that has Power BI Desktop installed. Does this action allow you to use Microsoft R scripts in your visualization?

Question 3Choose one

You use Power BI Desktop to create a visualization using a database on SQL database server named SQL01. You want to be able to use Microsoft R scripts in your visualization. You download and install Visual Studio on the computer that has Power BI Desktop installed. Does this action allow you to use Microsoft R scripts in your visualization?

Question 4Choose 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?

4 more free samples are waiting

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

Create account