☎  076 959 6407✉  support@quizcrazepro.co.za
Learn. Practice. Build your future.
BlogHelpContact

PL-300 Microsoft Power BI Data Analyst Exam Actual Questions

388 Questions120 Minutes70% Passing Score▣ Updated: Sep 2026

Question 140 of 388

Single answer
Hotspot 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.

About this practice exam

Review 388 Microsoft questions with answers and explanations. Use the navigation to move through the exam at your own pace.