Power BI Mastery Quiz — Quiz

Power Query, star schema modelling, DAX filter context, time intelligence and publishing. · 10 questions

Question 1 of 10

A depot file has one column per month (Apr, May, Jun...). Which Power Query transform turns them into `Month` and `Sales` columns?

aPivot ColumnsbUnpivot Other ColumnscMerge QueriesdTranspose

Question 2 of 10

You have three depot files with identical columns and want a single table containing all their rows. Which operation do you use?

aMerge QueriesbGroup BycAppend QueriesdUnpivot Columns

Question 3 of 10

In a star schema, `Product` (one side) is related to `Sales` (many side) with Single cross-filter direction. Which way do filters flow?

aFrom Product to SalesbFrom Sales to ProductcIn both directionsdFilters do not propagate across relationships

Question 4 of 10

Which object is computed row by row and physically stored in the model at refresh time?

aA measurebA slicercA report-level filterdA calculated column

Question 5 of 10

What does this measure return in a matrix sliced by `Product[Brand]` and `Store[Region]`?

Brand Share % =
DIVIDE (
    [Total Sales],
    CALCULATE ( [Total Sales], REMOVEFILTERS ( Product[Brand] ) )
)

aThe brand's share of all sales ever recorded, ignoring regionbAlways 100% because numerator and denominator matchcThe brand's share of sales within the current region and other filtersdAn error, because REMOVEFILTERS cannot be used inside DIVIDE

Question 6 of 10

What is the purpose of the `"31/3"` argument here?

Sales FYTD =
CALCULATE ( [Total Sales], DATESYTD ( 'Date'[Date], "31/3" ) )

aIt filters the result to 31 March onlybIt sets the fiscal year end to 31 March so the running total restarts on 1 AprilcIt formats the output as a datedIt limits the calculation to the year 2031

Question 7 of 10

A scheduled refresh of an Import model sourced from an on-premises SQL Server fails with a gateway error. What fixes it?

aInstall and configure the on-premises data gateway in standard mode and bind the data source to the modelbRepublish the .pbix from DesktopcSwitch the workspace licence from Pro to PremiumdGive report users Build permission on the semantic model

Question 8 of 10

Why does `RELATED` work in this calculated column on the `Sales` table?

Line MRP Value = Sales[Qty] * RELATED ( Product[MRP] )

aBecause RELATED works in any direction across any relationshipbBecause calculated columns always ignore relationshipscBecause Sales is the one side of the relationshipdBecause Sales is the many side, so each row has exactly one matching Product row

Question 9 of 10

An RLS role filters `Store[Region] = "Vidarbha"`, and a user assigned to that role is also a Member of the workspace. What do they see?

aOnly Vidarbha rows, because RLS always winsbNo data at all, because the two permissions conflictcAll rows — RLS is not applied to workspace Admins, Members or ContributorsdOnly Vidarbha rows in reports but all rows in the model

Question 10 of 10

On 12 September, `Total Sales` covers 12 days but `SAMEPERIODLASTYEAR` returns all 30 days of last September, making YoY look awful. What is the correct fix?

aRestrict the prior-year measure to the same number of elapsed days, e.g. by adding a filter up to EDATE(MAX(Sales[InvoiceDate]), -12)bReplace SAMEPERIODLASTYEAR with PREVIOUSYEARcSet the date table's end date to today so future days disappeardChange the relationship to bi-directional so filters flow back to the date table