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?
Answer

Suggested Answer

The suggested answer is B.

To prevent report recipients from reading the analyzed emails while also minimizing the model size, you should remove the Subject and Body columns during the import. This eliminates unnecessary data, directly reducing the model size and avoiding any unwanted visibility of email contents. Simply hiding columns or implementing row-level security would not reduce the model size, they only affect data visibility while keeping the underlying data in the model.

Community Votes6 votes
BSuggested
100%
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.
Answer

Suggested Answer

The suggested answer is A, B.

To meet the requirements of presenting ad impression counts for the day, campaign, and Site_name while minimizing the data model size, you should group the impressions by Ad_id, Site_name, and Impression_date and aggregate by using the CountRows function to reduce the size of the data upfront. Additionally, creating one-to-many relationships between the tables will ensure the data is properly related and can be analyzed across the different dimensions (campaigns, ads, and impressions). This combination will help achieve the required analytics with a minimized data model.

Community Votes15 votes
ABSuggested
100%
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?
Answer

Suggested Answer

The suggested answer is D.

To surface videos directly in a Microsoft Power BI dashboard from Microsoft Stream, a 'Web Content' tile should be used. This allows embedding of any web content, including videos, by using the embed code provided by Microsoft Stream. Power BI does not have a specific 'video' tile, and 'custom streaming data' is used for real-time data streams, not for embedding pre-recorded videos. The 'text box' option is not relevant for embedding videos.

Community Votes23 votes
DSuggested
74%
A
17%
B
9%
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?
Answer

Suggested Answer

The suggested answer is D.

Column quality: This option provides immediate visibility into the percentage of valid, error, and empty data values for each column in a table within the Power Query Editor. This functionality is especially useful for quickly identifying empty values, fulfilling the requirement specified in the question.

Community Votes7 votes
DSuggested
100%
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.
Answer

Suggested Answer

The suggested answer is C, E.

To ensure that the list contains records for each State/Region to which you want to target a marketing campaign, you should enable column profiling based on the entire dataset and select column profile. Column profiling based on the entire dataset is required because the customer list contains 1,500 rows, exceeding the 1,000 rows typically analyzed by default. Enabling this option ensures that the analysis includes all rows. Selecting column profile provides distinct and unique counts of values in columns, which is crucial for confirming the presence of records for each target State/Region.

Community Votes31 votes
CESuggested
94%
CD
6%

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.