Question 61

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 are modeling data by using Microsoft Power Bl. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records.
During the development process, you need to import a sample of the data from the Order table.
Solution: You write a DAX expression that uses the FILTER function.
Does this meet the goal?
  • Question 62

    You are modeling data in table named SalesDetail by using Microsoft Power Bl.
    You need to provide end users with access to the summary statistics about the SalesDetail data. The users require insights on the completeness of the data and the value distributions.
    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 63

    You have a table that contains the following three columns:
    City
    Total Sales
    Occupation
    You need to create a key influencers visualization as shown in the exhibit. (Click the Exhibit tab.)

    How should you configure the visualization? To answer, select the appropriate options in the answer area.
    NOTE: Each correct selection is worth one point.

    Question 64

    You have a prospective customer list that contains 1,500 rows of data. The list contains the following fields:
    * First name
    * Last name
    * Email address
    * State/Region
    * Phone number
    You import the list into Power Query Editor.
    You need to ensure that the list contains records for each State/Region to which you want to target a marketing campaign.
    Which two actions should you perform? Each correct answer presents part of the solution.
    NOTE: Each correct selection is worth one point.
  • Question 65

    You need to grant access to the business unit analysts.
    What should you configure? To answer, select the appropriate options in the answer area.
    NOTE: Each correct selection is worth one point.