Exam Preparation Quiz

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.