Sample Renewal Exam questions
You are merging Orders and Orders Detail queries in Power Query Editor. Due to data quality issues, some rows in the Orders query do NOT have a matching row in the Order Details query. You need to select the appropriate join type to ensure that all the rows from the Orders query are shown. Which join type should you use? Select only one answer. a. Full Outer b. Inner c. Left Outer d. Right Anti ChatGPT said: ✅ Correct answer: c. Left Outer Explanation: When merging queries in Power Query: A Left Outer Join keeps all rows from the first (left) table — in this case, the Orders query — and only matching rows from the second (right) table — the Order Details query. If some orders do not have matching order details, those orders will still appear in the merged result, with null values for the unmatched columns. Summary of join types (for clarity): Inner → Only matching rows in both tables Left Outer → All rows from left + matching from right ✅ Right ...