Question 166

You have a Power BI imported dataset that contains the data model 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.

Question 167

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 answer a question in this scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have several reports and dashboards in a workspace.
You need to grant all organizational users read access to a dashboard and several reports.
Solution: You assign all the users the Viewer role to the workspace.
Does this meet the goal?
  • Question 168

    You create a data model in Power BI.
    Report developers and users provide feedback that the data model is too complex.
    The model contains the following tables.

    The model has the following relationships:
    *There is a one-to-one relationship between Sales_Region and Region_Manager.
    *There are more records in Manager than in Region_Manager, but every record in Region_Manager has a corresponding record in Manager.
    *There are more records in Sales_Manager than in Sales_Region, but every record in Sales_Region has a corresponding record in Sales_Manager.
    You need to denormalize the model into a single table. Only managers who are associated to a sales region must be included in the reports.
    Which three 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.
    NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.

    Question 169

    You have a sales system that contains the tables shown in the following table.

    The Date table is marked as a date table.
    DatelD is the date data type. You need to create an annual sales growth percentage measure.
    Which DAX expression should you use?
  • Question 170

    You have the visual shown in the Original exhibit. {Click the Original tab.)

    You need to configure the visual as shown in the Modified exhibit. (Click the Modified tab.)

    What should you add to the visual?