Copy, Duplicate, And Reference Queries In Power Query
You are using Power Query Editor at MDFT Academy to transform data by creating several queries before importing to Power BI. The academy wants to reduce data size and minimize transformation steps for better performance.
Which option should you use in each scenario to efficiently manage and transform your queries?
Choose all correct answers from the options below.
Please select at least one answer!
Correct!
I'm sorry, your answers are not correct.
Explanations for each answer:
Use Copy or Duplicate to copy a query with all transformation steps but only changing the data source. is correct. Copy or Duplicate creates a new query with all steps, independent from the original, allowing you to change the data source.
Use Reference to create two queries with different steps, both sharing a set of initial steps. is correct. Reference creates a child query that shares initial steps with the original; changes to the original cascade to the child.
Use Copy to create a copy of a referencing query along with copies of all its source queries. is correct. Copy is the only option that copies a referencing query and all its source queries.
Use Copy or Duplicate to create a branch query from an original query, keeping complete isolation. is correct. Copy or Duplicate creates a completely independent branch query.
Use Reference to create a child query from an original query where changes to the original cascade to the child. is correct. Reference links the child query to the original, so changes to the original affect the child.