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