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 ID
Address contains the following columns:
✑ Address ID
✑ Address Line 1
✑ Address Line 2
✑ City
✑ State/Region
✑ Country
✑ Postal Code
The Customer ID and Address ID columns represent unique rows.
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?
A . Merge the Customer and Address tables.
B . Transpose the Customer and Address tables.
C . Group the Customer and Address tables by the Address ID column.
D . Append the Customer and Address tables.
Answer: A
Explanation:
There are two primary ways of combining queries: merging and appending.
✑ When you have one or more columns that you’d like to add to another query, you merge the queries.
✑ When you have additional rows of data that you’d like to add to an existing query, you append the query.
Reference: https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data
Latest DA-100 Dumps Valid Version with 114 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund