Microsoft Power BI Flashcards
7 cards from real Microsoft Power BI practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 7 Microsoft Power BI flashcards as text
Which DAX function evaluates an expression in a context modified by filters?
Answer: CALCULATE
CALCULATE changes the filter context in which an expression is evaluated.
What type of relationship cardinality is most common between a dimension and a fact table?
Answer: One-to-many
Star schemas typically use one-to-many relationships from dimension to fact tables.
Which Power BI object refreshes scheduled data from on-premises sources?
Answer: On-premises data gateway
The on-premises data gateway enables scheduled refresh from local data sources to the service.
What does a measure differ from a calculated column in terms of evaluation?
Answer: Measures evaluate at query time based on context
Measures are calculated dynamically at query time according to the current filter context.
Which view in Power BI Desktop lets you manage relationships between tables?
Answer: Model view
Model view displays tables and lets you create or edit relationships visually.
What feature allows reusable, cloud-based ETL logic shared across reports?
Answer: Dataflows
Dataflows store Power Query transformations in the service for reuse across datasets.
Which visual interaction lets a slicer filter all visuals on a page?
Answer: Default cross-filtering / visual interactions
By default, slicers cross-filter other visuals through Power BI's visual interactions.