Question 46

You need to create a relationship in the dataset for RLS.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Question 47

You are creating a Power Bl report by using Power Bi Desktop.
You need to include a visual that shows trends and other useful information automatically. The visual must update based on selections in other visuals.
Which type of visual should you use?
  • Question 48

    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?
  • Question 49

    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 section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
    You create a parameter named DataSourceExcel that holds the file name and location of a Microsoft Excel data source.
    You need to update the query to reference the parameter instead of multiple hard-coded copies of the location within each query definition.
    Solution: You modify the source step of the queries to use DataSourceExcel as the file path.
    Does this meet the goal?
  • Question 50

    You build a Power Bl report that displays 10T temperature data streaming from a refrigerator.
    You publish the report to the Bl service.
    You need to be notified when the temperature rises above four degrees Celsius.
    What should you do?