Microsoft Power BI Data Analyst Practice Question

Creating a reference of the Sales_Transactions query makes the new query start from the final results of Sales_Transactions without copying any existing steps. Because it points to the original query, it inherits any later edits in Sales_Transactions and does not duplicate the data in memory; both queries can still add their own additional transformations. A duplicate, by contrast, copies all steps into a separate query that is independent of future changes and stores a separate result set, consuming additional memory. Disabling load on one query or merging queries does not satisfy the requirement to create a separate table that stays in sync while conserving resources.