PL-300 exam

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you...

You need to create the required relationship for the executive's visual . What should you do before you can create the relationship?A . Change the data type of Sales[region_id] to Whole Number.B . In the Sales table, add a measure for sum(sales_amount).C . Change the data type of sales[sales_id] to...

You need to provide a solution to provide the sales managers with the required access. What should you include in the solution?A . Create a security role that has a table filter on the Sales_Manager table where username = UserName()B . Create a security role that has a table filter...

Topic 1, Litware, Inc. Case Study This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to...

What should you create to meet the reporting requirements of the sales department?A . a measure that uses a formula of SUM (Sales [sales_id])B . a calculated column that use a formula of COUNTA(sales [sales_id])C . a measure that uses a formula of COUNTROWS (Sales)D . a calculated column that...

You have multiple dashboards. You need to ensure that when users browse the available dashboards from powerbi.com. they can see which dashboards contain Personally Identifiable Information (Pll). The solution must minimize configuration effort and impact on the dashboard design. What should you use?A . Active Directory groupsB . tilesC ....

HOTSPOT You have a report page that contains the visuals shown in the following exhibit. Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Box 1: cross-filter...

HOTSPOT You need to calculate the last day of the month in the balance sheet data to ensure that you can relate the balance sheet data to the Date table . Which type of calculation and which formula should you use? To answer, select the appropriate options in the answer...

HOTSPOT You are creating a Microsoft Power Bl imported data model to perform basket analysis. The goal of the analysis is to identify which products are usually bought together in the same transaction across and within sales territories. You import a fact table named Sales as shown in the exhibit....

You have a collection of reports for the HR department of your company. The datasets use row-level security (RLS). The company has multiple sales regions that each has an HR manager. You need to ensure that the HR managers can interact with the data from their region only. The HR...