Microsoft

DA-100 Analyzing Data with Microsoft Power BI

Use original educational practice content, randomized simulator sessions, score history and explanation review for DA-100.

Start Practice Test View Premium Plans

Practice questions are provided in English to match the language commonly used in IT certification exams.

QZ9 is an independent training platform. All practice questions are original and created for educational purposes only. We do not provide unauthorized vendor exam content. Microsoft, AWS, Cisco, CompTIA, PMI and other trademarks belong to their respective owners.

VendorMicrosoft

CodeDA-100

DurationDuration varies

Questions50 refs

Exam facts

Objective-based preparation without unauthorized content

Certification metadata is preserved from the legacy QZ9 catalog. Questions remain English-only.

Start Practice Test

1Find your exam

2Start the simulator

3Review results

QZ9Independent training platform

Free question preview

Exam simulator

Practice questions are provided in English to match the language commonly used in IT certification exams.

Question 1

You have a Microsoft Excel workbook with a spreadsheet named Sales. You want to use the Sales spreadsheet in a Power BI dashboard report. How should you prepare the data on Sales spreadsheet?

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 install SQL Server R Services on SQL01. Does this action allow you to use Microsoft R scripts in your visualization?

Question 3

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 4

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 5

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?