Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Question 9 of 134
Free Preview · 134 of 444 · questions 1–134 of 444 are free. Sign up free to sync your progress across devices.
Drag & Drop Scenario
Read the scenario requirements and decide your answer. Click Check Answer below to see the marked solution.
Hotspot Solution:
Import Table1 and Table2 – Bring both tables into Power Query. Append Table2 to Table1 – Combine rows from both tables into one query. Remove duplicates – Ensure the final column has unique product values. This sequence creates a single list of products without duplicates for analysis.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
4-5-2 import --- append ---- remove duplicates
Import Table1 and Table2 – Bring both tables into Power Query. Append Table2 to Table1 – Combine rows from both tables into one query. Remove duplicates – Ensure the final column has unique product values. This sequence creates a single list of products without duplicates for analysis.
Import Append table 2 to 1 Remove Duplicates