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 returns a related value from a table on the one side of a relationship?
Answer: RELATED
RELATED retrieves a value from the one side of a one-to-many relationship.
What is the purpose of a drillthrough page in a Power BI report?
Answer: Show detailed data for a selected item
Drillthrough pages display detailed context for a specific value the user right-clicks into.
Which security feature restricts data rows based on the user viewing the report?
Answer: Row-Level Security (RLS)
Row-Level Security filters table rows according to roles assigned to users.
What does the VertiPaq engine primarily do in Power BI?
Answer: Compresses and stores imported data in memory
VertiPaq is the columnar in-memory engine that compresses imported data for fast queries.
Which storage mode keeps queries running against the source without importing data?
Answer: DirectQuery
DirectQuery sends queries directly to the source so data is not cached in the model.
What Power BI Service object groups related dashboards and reports for an audience?
Answer: App
A Power BI app packages dashboards and reports from a workspace for distribution to users.
Which function would you use to iterate row by row and sum an expression?
Answer: SUMX
SUMX is an iterator that evaluates an expression per row and sums the results.