Microsoft Power BI Microsoft Power BI 3 — Questions and Answers
Question 1: Which DAX function evaluates an expression in a context modified by filters?
- CALCULATE (Correct answer)
- SUMX
- RELATED
- VALUES
Correct answer: CALCULATE
CALCULATE changes the filter context in which an expression is evaluated.
Question 2: What type of relationship cardinality is most common between a dimension and a fact table?
- One-to-many (Correct answer)
- Many-to-many
- One-to-one
- No relationship
Correct answer: One-to-many
Star schemas typically use one-to-many relationships from dimension to fact tables.
Question 3: Which Power BI object refreshes scheduled data from on-premises sources?
- On-premises data gateway (Correct answer)
- Dataflow connector
- Power BI Mobile
- Bookmark pane
Correct answer: On-premises data gateway
The on-premises data gateway enables scheduled refresh from local data sources to the service.
Question 4: What does a measure differ from a calculated column in terms of evaluation?
- Measures evaluate at query time based on context (Correct answer)
- Measures are stored row-by-row
- Measures cannot use DAX
- Measures require Power Query
Correct answer: Measures evaluate at query time based on context
Measures are calculated dynamically at query time according to the current filter context.
Question 5: Which view in Power BI Desktop lets you manage relationships between tables?
- Model view (Correct answer)
- Report view
- Data view
- DAX view
Correct answer: Model view
Model view displays tables and lets you create or edit relationships visually.
Question 6: What feature allows reusable, cloud-based ETL logic shared across reports?
- Dataflows (Correct answer)
- Bookmarks
- Tooltips
- Sync slicers
Correct answer: Dataflows
Dataflows store Power Query transformations in the service for reuse across datasets.
Question 7: Which visual interaction lets a slicer filter all visuals on a page?
- Default cross-filtering / visual interactions (Correct answer)
- Drillthrough
- Export to PDF
- Pin to dashboard
Correct answer: Default cross-filtering / visual interactions
By default, slicers cross-filter other visuals through Power BI's visual interactions.
Microsoft Power BI Microsoft Power BI 3
Which DAX function evaluates an expression in a context modified by filters?