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.
Microsoft Certified: Power BI Data Analyst Associate · Microsoft
Select one answer.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
MJ - MARY JANE ( spider man girlfriend ) merge is join
A merge the customer and address tables. You’d merge the Customer table with the Address table on Address ID.
Correct Answer: A. Merge the Customer and Address tables. Explanation: To get one row per customer with additional columns (City, State/Region, Country) from the Address table, you need to merge the two tables on the common key Address ID. Group is for aggregations, not joining. Transpose changes rows to columns, irrelevant here. Append stacks tables vertically, not what you need.