Question 41

In Power BI Desktop, you are building a sales report that contains two tables. Both tables have row-level security (RLS) configured.
You need to create a relationship between the tables. The solution must ensure that bidirectional cross-filtering honors the RLS settings.
What should you do?
  • Question 42

    You have a line chart that shows the number of employees in a department over time.
    You need to see the total salary costs of the employees when you hover over a data point.
    What is possible way to achieve this goal?
  • Question 43

    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 powerbi.com, set RLS role membership, and distribute the dataset and related reports to the salespeople.
    A salesperson reports that she believes she should see more data.
    You need to verify what data the salesperson currently sees.
    What should you do?
  • Question 44

    You need to create the Top Customers report.
    Which type of filter should you use, and at which level should you apply the filter?
    To answer, select the appropriate options in the answer area.
    NOTE; Each correct selection is worth one point.

    Question 45

    You need to design the data model and the relationships for the Customer Details worksheet and the Orders table by using Power BI. The solution must meet the report requirements.
    For each of the following statement, select Yes if the statement is true, Otherwise, select No.
    NOTE: Each correct selection is worth one point.