Question 26

You need to create a relationship between the Weekly_Returns table and the Date table to meet the reporting requirements of the regional managers. What should you do?
  • Question 27

    You have a Power Bl workspace that contains a single-page report named Sales.
    You need to add all the visuals from Sales to a dashboard. The solution must ensure that additional visuals added to the page are added automatically to the dashboard.
    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.

    Question 28

    You need to create the dataset. Which dataset mode should you use?
  • Question 29

    Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is the same in each question in this series.
    You have a Microsoft SQL Server database that contains the following tables.

    The following columns contain date information:
    - Date[Month] in the mmyyyy format
    - Date[Date_ID] in the ddmmyyyy format
    - Date[Date_name] in the mm/dd/yyyy format
    - Monthly_returns[Month_ID] in the mmyyyy format
    The Order table contains more than one million rows.
    The Store table has a relationship to the Monthly_returns table on the Store_ID column. This is the only relationship between the tables.
    You plan to use Power BI Desktop to create an analytics solution for the data.
    You need to create a relationship between the Order table and the Store table on the Store_ID column.
    What should you do before you create the relationship?
  • Question 30

    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 a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as numerical amount representing US dollars.
    You need to create a reference line to show which employees are above the median salary.
    Solution: You create a constant line and set the value to .5.
    Does this meet the goal?