Launch pricing — Azure certification prep for €19,95 €29,95

← All DP-900 topicsDP-900 · Analytics Workloads on Azure

DP-900 Power BI and Data Visualization Practice Questions

The DP-900 closes with data visualization in Power BI. Know the workflow from Power BI Desktop to the Power BI service, and the difference between a report and a dashboard, and between interactive and paginated reports.

Expect questions on data modeling (relationships, calculated columns versus measures, semantic models), connection modes such as Import and DirectQuery, choosing the right visual, and sharing securely with features like row-level security.

Below are 8 free questions on this topic. Try each one before you open the answer.

Question 1

Which Power BI connectivity mode downloads a full copy of the data into Power BI and stores it in memory, enabling fast query performance without hitting the source system?

  • A.DirectQuery
  • B.Live Connection
  • C.Import
  • D.Streaming
chevron_rightShow answer and explanation

Correct answer: C. Import

In Import mode, Power BI loads a snapshot of the data into its in-memory engine (VertiPaq). Queries run against this local copy, resulting in very fast performance. The trade-off is that data is only as fresh as the last scheduled refresh (up to 8 times per day on shared capacity). DirectQuery sends each query live to the source system, and Live Connection connects to an external Analysis Services model.

Question 2

A business analyst publishes a Power BI report to a workspace and wants to distribute it to 500 read-only consumers within the organization as a packaged, governed collection of reports and dashboards. Which Power BI feature should they use?

  • A.Power BI Desktop sharing
  • B.Power BI app
  • C.Power BI paginated report
  • D.Power BI dataflow
chevron_rightShow answer and explanation

Correct answer: B. Power BI app

A Power BI app is a published package of dashboards, reports, and datasets from a workspace, distributed to a broad audience within an organization. Apps provide a clean, governed end-user experience where consumers see only what they need without accessing the underlying workspace. This is the recommended distribution method for large read-only audiences. Direct workspace sharing is suited for collaborators, not mass read-only consumers.

Question 3

What is the key difference between a Power BI paginated report and a standard Power BI interactive report?

  • A.Paginated reports are designed to be printed or exported to PDF with precise pixel-perfect formatting across multiple pages, while interactive reports are designed for exploration and visual filtering
  • B.Paginated reports can only connect to Azure SQL Database, while interactive reports support any data source
  • C.Paginated reports use Import mode exclusively, while interactive reports use DirectQuery exclusively
  • D.Paginated reports are available only in Power BI Desktop, while interactive reports can be published to the Power BI service
chevron_rightShow answer and explanation

Correct answer: A. Paginated reports are designed to be printed or exported to PDF with precise pixel-perfect formatting across multiple pages, while interactive reports are designed for exploration and visual filtering

Power BI paginated reports (formerly SQL Server Reporting Services / SSRS reports) are optimized for scenarios where the output must be formatted precisely — such as invoices, financial statements, and operational reports that span many pages. They are rendered row by row and paginate automatically. Interactive Power BI reports, on the other hand, are canvas-based and designed for visual exploration with slicers, cross-filtering, and drill-through. Paginated reports are created in Power BI Report Builder, while interactive reports are created in Power BI Desktop.

Question 4

What is incremental refresh in Power BI, and what problem does it solve?

  • A.A feature that refreshes only the new or changed data partitions (e.g., recent months) instead of reloading the entire dataset, solving the problem of slow and resource-intensive full refreshes on large datasets
  • B.A feature that automatically detects schema changes in the source and updates the Power BI data model without manual intervention
  • C.A feature that streams data changes from the source system into Power BI in real time, eliminating the need for scheduled refresh windows
  • D.A feature that splits a large dataset across multiple Power BI workspaces to allow parallel refresh jobs
chevron_rightShow answer and explanation

Correct answer: A. A feature that refreshes only the new or changed data partitions (e.g., recent months) instead of reloading the entire dataset, solving the problem of slow and resource-intensive full refreshes on large datasets

For large datasets with years of historical data, a full refresh every day is expensive and slow. Incremental refresh solves this by dividing the dataset into date-based partitions. During each refresh cycle, only the recent partitions (e.g., the last 1–2 months) are re-queried from the source. Historical partitions are kept as-is in memory and are not refreshed. This dramatically reduces refresh duration and source system load. Incremental refresh is configured in Power BI Desktop using RangeStart and RangeEnd parameters, and requires Power BI Premium or Premium Per User for full functionality.

Question 5

In a Power BI data model, a fact table contains millions of rows of sales transactions. A dimension table contains product details. What type of relationship connects them, and how should it be structured for best performance?

  • A.A many-to-many relationship where both tables share a composite primary key
  • B.A one-to-many relationship from the dimension table (one product) to the fact table (many sales), forming a star schema
  • C.A one-to-one relationship where each sales row links to exactly one product row in both directions
  • D.A hierarchical relationship where the fact table is a child of the dimension table in a snowflake structure
chevron_rightShow answer and explanation

Correct answer: B. A one-to-many relationship from the dimension table (one product) to the fact table (many sales), forming a star schema

The star schema is the recommended data model pattern in Power BI. Fact tables (large, narrow tables with foreign keys and numeric measures) sit at the center. Dimension tables (smaller, descriptive tables with attributes like product name, category, supplier) surround them. The relationship flows from the dimension's primary key (one side) to the fact table's foreign key (many side). This one-to-many relationship allows Power BI's Vertipaq engine to filter efficiently from dimensions down to facts. A star schema outperforms a snowflake schema in Power BI because it minimizes the number of joins needed.

Question 6

Which DAX function is used to perform a calculation while overriding or extending the current filter context?

  • A.SUMX
  • B.RELATED
  • C.CALCULATE
  • D.LOOKUPVALUE
chevron_rightShow answer and explanation

Correct answer: C. CALCULATE

CALCULATE is one of the most fundamental and powerful DAX functions. It evaluates an expression (like a SUM) in a modified filter context. For example, CALCULATE(SUM(Sales[Amount]), Region[Name] = "North") computes the total sales but restricts the filter context to the North region — regardless of what slicers the user has applied. CALCULATE can add filters, remove filters (using ALL()), or swap existing filters. It is the primary mechanism in DAX for time intelligence patterns (e.g., year-to-date, same period last year) and for building more complex KPIs. SUMX and other iterator functions evaluate row by row but do not modify filter context.

Question 7

A multinational company uses Power BI to report on sales. Regional managers are responsible for their own data but share a single corporate dataset. The company wants to ensure that when a regional manager accidentally modifies a filter in the report, other regions' data is not exposed. Which Power BI feature enforces this boundary at the data model level?

  • A.Report-level filters, which prevent slicers from affecting other pages
  • B.Row-Level Security (RLS) roles assigned to each regional manager, ensuring the filter context always restricts to their own region
  • C.Workspace-level permissions that prevent users from editing reports they do not own
  • D.Sensitivity labels that encrypt data belonging to other regions
chevron_rightShow answer and explanation

Correct answer: B. Row-Level Security (RLS) roles assigned to each regional manager, ensuring the filter context always restricts to their own region

RLS enforces data boundaries at the model level — not just at the report visual level. Even if a regional manager modifies a slicer, clears all filters, or views the underlying data table, RLS ensures they only ever see rows for their own region. This is because the RLS filter is applied before any query reaches the data model. Report-level filters are a design choice that users can sometimes override, while RLS is a security boundary enforced by the Power BI engine regardless of how the user interacts with the report.

Question 8

Determine whether each statement about Microsoft Power BI is correct.

  1. 1.Power BI Desktop is a Windows application used to create data models and reports.
  2. 2.In Power BI, selecting a value in one visualisation automatically filters all other related visualisations in the same report.
  3. 3.The Power BI service provides more advanced data modelling functionality than Power BI Desktop.
chevron_rightShow answer and explanation
  1. Statement 1: Yes
  2. Statement 2: Yes
  3. Statement 3: No

Statement 1 is correct: Power BI Desktop is a Windows desktop application used for importing data, building data models, and designing reports. Statement 2 is correct: Power BI reports are interactive — clicking a data point or category in one visual automatically cross-filters and highlights other visuals on the same report page. Statement 3 is incorrect: Power BI Desktop offers more comprehensive data modelling capabilities; the Power BI service supports only basic modelling and editing via the browser, making Desktop the preferred tool for complex model development.

These are 8 of 33 Power BI and Data Visualization questions in the full bank

Practice all 400 DP-900 questions in exam format, including drag-and-drop and multi-select questions, with a mock exam and progress tracking.