Question 31

You are building a dataset from a JSON file that contains an array of documents.
You need to import attributes as columns from all the documents in the JSON file. The solution must ensure that date attributes can be used as date hierarchies in Microsoft Power BI 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.

Question 32

You have a data model that contains many complex DAX expressions. The expressions contain frequent references to the RELATED and RELATEDTABLE functions.
You need to recommend a solution to minimize the use of the RELATED and RELATEDTABLE functions.
What should you recommend?
  • Question 33

    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 publish an app to the entire organization.
    Does this meet the goal?
  • Question 34

    You have the visual shown in the exhibit. (Click the Exhibit tab.)

    You need to show the relationship between Total Cost and Total Sales over time.
    What should you do?
  • Question 35

    You are creating an analytics report that will consume data from the tables shown in the following table.

    There is a relationship between the tables.
    There are no reporting requirements on employeejd and employee_photo.
    You need to optimize the data model
    What should you configure for employeejd and employee.photo? To answer, select the appropriate options in the answer area.