HOTSPOT You have two tables named Customers and Invoice in a Power BI model. The Customers table contains the following fields:
• CustomerID
• Customer City
• Customer State
• Customer Name
• Customer Address 1
• Customer Address 2
• Customer Postal Code The Invoice table contains the following fields:
• Order ID
• Invoice ID
• Invoice Date
• Customer ID
• Total Amount
• Total Item Count The Customers table is related to the Invoice table through the Customer ID columns. A customer can have many invoices within one month. The Power BI model must provide the following information:
• The number of customers invoiced in each state last month
• The average invoice amount per customer in each postal code You need to define the relationship from the Customers table to the Invoice table. The solution must optimize query performance. What should you configure? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Select one answer.
Purchase Full Access to view answer options & explanation
The first 134 questions in this bank are completely free. Unlock Full Access on the exam page to view all answer choices, verified answers, explanations, and community discussions for all 444 questions.
