Microsoft Power BI Data Analyst Practice Question

A reference query only contains a single line of M code that points to the result of another query. Because it depends on the original query, any future transformation steps added to that base query are automatically reflected in the reference. A duplicate query, on the other hand, copies the full list of existing steps so that the new query is independent; additional steps made to the original query do not flow through. Therefore, creating Sales_Summary as a reference ensures its aggregations always stay synchronized with Sales, while creating Sales_QualityCheck as a duplicate keeps its transformations isolated from later edits to Sales. Reversing the choices, or using the same query type for both, would not satisfy both requirements.