Exam DA-100: Analyzing Data with Microsoft Power BI Practice Test
DA-100 focuses on analyzing data with Power BI, from preparing source data to building models and presenting findings in interactive reports. The practice bank samples report-authoring decisions such as choosing slicers, drill-through pages, hierarchies, field parameters, and tooltip details, alongside model settings for numeric formats and aggregation behavior.
Exam overview
About the Exam DA-100: Analyzing Data with Microsoft Power BI Exam
Power BI analysis work involves shaping imported data, defining relationships, and creating a semantic model that supports reliable calculations. Analysts use DAX measures to express business metrics, select appropriate data types and formats, and control how columns summarize in visuals. Report design then connects those calculations to clear visual encodings and interactions: filters narrow a view, hierarchies support movement between levels of detail, and drill-through opens a focused page for a selected record or category. Authors also need to distinguish report interactions from access controls, such as row-level security, and choose an appropriate way to share content with authorized users. The available question signals touch on these practical choices, including contextual tooltips and changing a visual’s displayed fields without duplicating the visual.
Sample Practice Questions
Review a selection from this exam's published US Practice Tests practice bank.
A published report is embedded in an internal web page for users who already have appropriate Power BI access. Which approach is intended for securely sharing the report within an organization?
Show answer
Correct answer: ASecure embedding and sharing options are designed for access-controlled use, subject to the organization's licensing and permissions. Publish to web makes content publicly accessible, so it is not appropriate for confidential internal data.
A report consumer wants to hover over a point in a chart and see additional details without navigating away or adding another full-size visual. What can the report author configure?
Show answer
Correct answer: AA report-page tooltip can display a designed page of contextual information when a user hovers over a data point.
A report page contains a chart of sales by month. You want viewers to choose a region and have the chart update to show only that region. Which report element is designed for this interaction?
Show answer
Correct answer: AA slicer is an interactive report control that lets viewers filter the data shown in visuals, such as selecting a region.
A report needs to show sales totals at the country level and let viewers expand the visual to see state and city levels. What should the author configure?
Show answer
Correct answer: AA hierarchy lets viewers navigate through levels of detail, such as country, state, and city, using drill actions in a visual. A concatenated column does not provide the same level-by-level exploration.
A report should be limited so that a manager sees only rows belonging to the manager's assigned territory. Which Power BI capability is intended for this kind of access control?
Show answer
Correct answer: ARow-level security applies filters to data access based on roles, which can be configured to restrict users to rows for particular territories.
A Power BI report includes a table visual with many rows. You want a user to select a row and open a separate report page showing details for that selection. Which feature is designed for this navigation?
Show answer
Correct answer: ADrillthrough passes the selected context to a detail page, allowing users to navigate from a summary visual to a page focused on the selected item.
A report author wants to let users switch a visual between viewing sales by product and sales by region, without creating separate copies of the visual. Which feature is intended to let users choose among fields or measures for a visual?
Show answer
Correct answer: AField parameters let authors define selectable fields or measures that users can switch in a visual, supporting flexible views without duplicating the visual.
How to use this practice test
The free practice session selects up to 20 random questions from the 50-question DA-100 bank. Submit your answers to see results after the session; use missed or uncertain items to identify which Power BI modeling, interaction, formatting, or sharing decisions need further review.
Preparation tips
- Practice writing DAX measures for common aggregations and compare their results with calculated columns in a model.
- Inspect a sample model’s data types, relationships, default summarization, and percentage or currency formats before building visuals.
- Create a report page with a slicer, a hierarchy, a drill-through destination, and a report-page tooltip; test how each interaction changes the view.
- Review the difference between row-level security and report filtering, then test how territory-based roles affect visible rows.
- Compare secure organizational sharing options with embedding a report for users who already have Power BI access.