Analyzing and Visualizing Data with Microsoft Excel — Question 83

You import the data from two next files into a PowerPivot model to create two tables named Customers and Invoices. Each table contains a column named
CustomerID.
When you attempt to create a relationship between the Customers table and the Invoices table by using the CustomerID column from each table, the relationship cannot be created due to duplicate CustomerID values.
You need to ensure that you can create the relationship.
What should you do?

Answer options

• A. Add an index column to the Customers query
• B. Add an index column to the Invoices query
• C. Group the Customers query by CustomerID
• D. Sort the Invoices query by CustomerID, and then add a Fill Down step

Correct answer: C

Explanation

The correct answer is C because grouping the Customers query by CustomerID will eliminate duplicates, allowing a one-to-many relationship with the Invoices table. Options A and B do not address the issue of duplication, and option D does not resolve the relationship conflict either, as it does not affect the uniqueness of CustomerID values.