PL-300 V3

You need to create relationships to meet the reporting requirements of the customer service department. What should you create?A . an additional date table named ShipDate, a one-to-many relationship from Sales[sales_date_id] to Date[date_id], and a one-to-many relationship from Sales[sales_ship_date_id] to ShipDate[date_id] B. an additional date table named ShipDate, a many-to-many...

CORRECT TEXT You have a Power Bl visual that uses indicators to show values that are out of range as shown in the following exhibit. View AnswerAnswer:

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...

You need to address the data concerns before creating the data model . What should you do in Power Query Editor?A . Select Column distribution. B. Select the sales_amount column and apply a number filter. C. Select Column profile, and then select the sales_amount column. D. Transform the sales_amount column...

You have five sales regions. Each region is assigned a single salesperson. You have an imported dataset that has a dynamic row-level security (RLS) role named Sales. The Sales role filters sales transaction data by salesperson. Salespeople must see only the data from their region. You publish the dataset to...

HOTSPOT You need to create a visualization to meet the reporting requirements of the sales managers. How should you create the visualization? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Scenario: The sales managers require a visual...

You build a report to help the sales team understand its performance and the drivers of sales. The team needs to have a single visualization to identify which factors affect success . Which type of visualization should you use?A . Key influences B. Funnel chart C. Q&A D. Line and...

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 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...

You need to design the data model to meet the report requirements. What should you do in Power BI Desktop?A . From Power Query, use a DAX expression to add columns to the Orders table to calculate the calendar quarter of the OrderDate column, the calendar month of the OrderDate...