Question 86

You need to create a solution to meet the notification requirements of the warehouse shipping department.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct select is worth one point:

Question 87

You have a Power Bl query named Sates that imports the columns shown in the following table.

Usees only use the dale part of the Sales.Date field. Only rows with a Status of Finished are used in analysis.
You need to reduce the load times of the query without affecting the analysis.
Which two actions achieve this goal? Each correct answer presents a complete solution.
NOTL Each correct selection is worth one pant.
  • Question 88

    You are creating a column chart visualization.
    You configure groups as shown in the Groups exhibit. {Click the Groups tab.)

    The visualization appears as shown in the Chart exhibit. (Click the Chart tab.)

    For each of the following statements, select Yes if the statement is true. Otherwise, select No.
    NOTE: Each correct selection is worth one point.

    Question 89

    You have the Power Bl model shown in the following exhibit.

    There are four departments in the Departments table.
    You need to ensure that users can see the data of their respective department only.
    What should you do?
  • Question 90

    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?