HOTSPOT -You have a Power BI report.You need to create a calculated table to return the 100 highest spending customers.How should you complete the DAX expression? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point.Hot Area:
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 CodeThe Invoice table contains the following fields:✑ Order ID✑ Invoice ID✑ Invoice Date✑ Customer ID✑ Total Amount✑ Total 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 month✑ The 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.Hot Area:
You have a Microsoft Power BI data model that contains three tables named Orders, Date, and City. There is a one-to-many relationship between Date andOrders and between City and Orders.The model contains two row-level security (RLS) roles named Role1 and Role2. Role1 contains the following filter.City[State Province] = "Kentucky"Role2 contains the following filter.Date[Calendar Year] = 2020 -If a user is a member of both Role1 and Role2, what data will they see in a report that uses the model?
HOTSPOT -Your company has affiliates who help the company acquire customers.You build a report for the affiliate managers at the company to assist them in understanding affiliate performance.The managers request a visual showing the total sales value of the latest 50 transactions for each affiliate. You have a data model that contains the following tables.The Affiliate table has a one-to-many relationship to the Transactions table based on the AffiliateID column.You need to develop a measure to support the visual.How should you complete the DAX expression? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point.Hot Area:
You are configuring a Microsoft Power BI data model to enable users to ask natural language questions by using Q&A.You have a table named Customer that has the following measure.Customer Count = DISTINCTCOUNT(Customer[CustomerID])Users frequently refer to customers as subscribers.You need to ensure that the users can get a useful result for "subscriber count" by using Q&A. The solution must minimize the size of the model.What should you do?
You have a custom connector that returns ID, From, To, Subject, Body, and Has Attachments for every email sent during the past year. More than 10 million records are returned.You build a report analyzing the internal networks of employees based on whom they send emails to.You need to prevent report recipients from reading the analyzed emails. The solution must minimize the model size.What should you do?
