Câu 35: PL-300: Microsoft Power BI Data Analyst

You import two Microsoft Excel tables named Customer and Address into Power Query. Customer contains the following columns: ✑ Customer ID ✑ Customer Name ✑ Phone ✑ Email Address ✑ Address IDAddress contains the following columns: ✑ Address ID ✑ Address Line 1 ✑ Address Line 2 ✑ City ✑ State/Region ✑ Country ✑ Postal CodeEach Customer ID represents a unique customer in the Customer table. Each Address ID represents a unique address in the Address table. You need to create a query that has one row per customer. Each row must contain City, State/Region, and Country for each customer. What should you do?

1. A. Merge the Customer and Address tables. — đáp án hiện tại
2. B. Group the Customer and Address tables by the Address ID column.
3. C. Transpose the Customer and Address tables.
4. D. Append the Customer and Address tables.