DA-100 Sample Questions & Answers
Modeling data and writing DAX measures carries the most weight, alongside visualizing it through reports and dashboards, getting and profiling data from different sources, and deploying by managing datasets and workspaces.
Launch the full DA-100 simulator →Showing 4 of 8 free samples.
- Question 1
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?
Show answer & explanation
Correct answer: A
Explanation: By default, Power BI Desktop doesn't include, deploy, or install the R engine. To run R scripts in Power BI Desktop, you must separately install Microsoft R on your local computer.References: https://docs.microsoft.com/en-us/power-bi/desktop-r-visuals
- Question 2
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?
Show answer & explanation
Correct answer: B
Explanation: By default, Power BI Desktop doesn't include, deploy, or install the R engine. To run R scripts in Power BI Desktop, you must separately install Microsoft R on your local computer.References: https://docs.microsoft.com/en-us/power-bi/desktop-r-visuals
- Question 3
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?
Show answer & explanation
Correct answer: A
The Text.Replace function combined with Text.Start is the correct approach for masking SSN data. Text.Start([SSN],6) extracts the first 6 characters (xxx-xx portion) that need to be replaced, while Text.Replace substitutes them with the mask characters. This preserves the last 4 digits while hiding the sensitive portion. The other options use incorrect functions: Text.ReplaceRange has wrong parameters, Replacer.ReplaceText is not a valid M function, and Text.TrimStart only removes characters without replacement.
- Question 4
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?
Show answer & explanation
Correct answer: D
Explanation: The DAX FORMAT function converts a value to text according to the specified format.
Syntax: FORMAT((value), (format_string))References: https://docs.microsoft.com/en-us/dax/format-function-dax
Ready for the real thing?
The full DA-100 simulator has every exam-style question, timed mode, and instant scoring.