DRAG DROP -You are preparing a financial report in Power BI.You connect to the data stored in a Microsoft Excel spreadsheet by using Power Query Editor as shown in the following exhibit.You need to prepare the data to support the following:✑ Visualizations that include all measures in the data over time✑ Year-over-year calculations for all the measuresWhich four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.Select and Place:
HOTSPOT -You are creating a quick measure as shown in the following exhibit.You need to create a monthly rolling average measure for Sales over time.How should you configure the quick measure calculation? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point.Hot Area:
You have four sales regions. Each region has multiple sales managers.You implement row-level security (RLS) in a data model. You assign the relevant distribution lists to each role.You have sales reports that enable analysis by region. The sales managers can view the sales records of their region. The sales managers are prevented from viewing records from other regions.A sales manager changes to a different region.You need to ensure that the sales manager can see the correct sales data.What should you do?
DRAG DROP -You have a Microsoft Power BI data model that contains three tables named Sales, Product, and Date.The Sales table has an existing measure named [Total Sales] that sums the total sales from the Sales table.You need to write a calculation that returns the percentage of total sales that a selected ProductCategoryName value represents. The calculation must respect any slicers on ProductCategoryName and must show the percentage of visible total sales. For example, if there are four ProductCategoryName values, and a user filters one out, a table showing ProductCategoryName and the calculation must sum up to 100 percent.How should you complete the calculation? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.NOTE: Each correct selection is worth one point.Select and Place:
You have sales data in a star schema that contains four tables named Sales, Customer, Date, and Product. The Sales table contains purchase and ship dates.Most often, you will use the purchase date to analyze the data, but you will analyze the data by both dates independently and together.You need to design an imported dataset to support the analysis. The solution must minimize the model size and the number of queries against the data source.Which data modeling design should you use?
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?
