Analyzing Data with Microsoft Power BI

Here you have the best Microsoft DA-100 practice exam questions

You have 94 total questions across 19 pages (5 per page)
These questions were last updated on February 13, 2026
This site is not affiliated with or endorsed by Microsoft.

Question 1 of 94

You have a custom connector that returns ID, From, To, Subject, Body, and Has Attachments for every email sent during the past year. More than 10 million records are returned.
You build a report analyzing the internal networks of employees based on whom they send emails to.
You need to prevent report recipients from reading the analyzed emails. The solution must minimize the model size.
What should you do?

Implement row-level security (RLS) so that the report recipients can only see results based on the emails they sent.

Remove the Subject and Body columns during the import.

From Model view, set the Subject and Body columns to Hidden.

Question 2 of 94

You have the tables shown in the following table.
Exam DA-100: Question 2 - Image 1

The Impressions table contains approximately 30 million records per month.
You need to create an ad analytics system to meet the following requirements:
✑ Present ad impression counts for the day, campaign, and Site_name. The analytics for the last year are required.
✑ Minimize the data model size.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

Group the impressions by Ad_id, Site_name, and Impression_date. Aggregate by using the CountRows function.

Create one-to-many relationships between the tables.

Create a calculated measure that aggregates by using the COUNTROWS function.

Create a calculated table that contains Ad_id, Site_name, and Impression_date.

Question 3 of 94

Your company has training videos that are published to Microsoft Stream.
You need to surface the videos directly in a Microsoft Power BI dashboard.
Which type of tile should you add?

video

custom streaming data

text box

web content

Question 4 of 94

You open a query in Power Query Editor.
You need to identify the percentage of empty values in each column as quickly as possible.
Which Data Preview option should you select?

Show whitespace

Column profile

Column distribution

Column quality

Question 5 of 94

You have a prospective customer list that contains 1,500 rows of data. The list contains the following fields:
✑ First name
✑ Last name
✑ Email address
✑ State/Region
✑ Phone number
You import the list into Power Query Editor.
You need to ensure that the list contains records for each State/Region to which you want to target a marketing campaign.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

Open the Advanced Editor.

Select Column quality.

Enable Column profiling based on entire dataset.

Select Column distribution.

Select Column profile.

About the Microsoft DA-100 Certification Exam

About the Exam

The Microsoft DA-100 (Analyzing Data with Microsoft Power BI) validates your knowledge and skills. Passing demonstrates proficiency and can boost your career prospects in the field.

How to Prepare

Work through all 94 practice questions across 19 pages. Focus on understanding the reasoning behind each answer rather than memorizing responses to be ready for any variation on the real exam.

Why Practice Exams?

Practice exams help you familiarize yourself with the question format, manage your time, and reduce anxiety on the test day. Our DA-100 questions are regularly updated to reflect the latest exam objectives.