Question 66

You have a Microsoft Power Bl dashboard. The report used to create the dashboard uses an imported dataset from a Microsoft SQL Server data source. The dashboard is shown in the exhibit. (Click the Exhibit tab.)

What occurred at 12:03:06 PM?
  • Question 67

    You need to create the Top Customers report.
    Which type of filter should you use, and at which level should you apply the filter? To answer, select the appropriate options in the answer area.
    NOTE; Each correct selection is worth one point.

    Question 68

    You need to create a visualization to meet the reporting requirements of the sales managers.
    How should you create the visualization? To answer, select the appropriate options in the answer area.
    NOTE: Each correct selection is worth one point.

    Question 69

    You have a Microsoft Power BI data model that contains three tables named Orders, Date, and City. There is a one-to-many relationship between Date and Orders and between City and Orders.
    The model contains two row-level security (RLS) roles named Role1 and Role2. Role1 contains the following filter.
    City[State Province] = "Kentucky"
    Role2 contains the following filter.
    Date[Calendar Year] = 2020
    If a user is a member of both Role1 and Role2, what data will they see in a report that uses the model?
  • Question 70

    You are configuring a Microsoft Power Bl data model to enable users to ask natural language questions by using Q&A.
    You have a table named Customer that has the following measure.
    Customer Count = DISTINCTCOUNT(Customer[CustomerID])
    Users frequently refer to customers as subscribers.
    You need to ensure that the users can get a useful result for "subscriber count" by using Q&A. The solution must minimize the size of the model.
    What should you do?