Question 140 of 388
Single answerHotspot QuestionYou have two tables named Customers and Invoice in a Power BI model. The Customers table contains the following fields:CustomerIDCustomer CityCustomer StateCustomer NameCustomer Address 1Customer Address 2Customer Postal CodeThe Invoice table contains the following fields:Order IDInvoice IDInvoice DateCustomer ID Total AmountTotal Item CountThe 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 monthThe average invoice amount per customer in each postal codeYou 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.
✓ASee source PDF for answer choices.
BAdditional option
✓
Correct Answer: A
See source PDF for answer choices.
▥
Explanation
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Microsoft certification topics.