Question 31

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 32

You have a Power BI data model that analyzes product sales ever time. The data model contains the following tables.

A one-to-many relationship exists between the tables.
The auto date/time option for the data model enabled.
You need to reduce the size of the data model while maintaining the ability to analyze product sales by month and quarter.
Which two actions should you perform?
  • Question 33

    You have a Power Bl report
    You have a table named Dalai that contains 10 million rows. Data is used in the following visuals:
    * A card that shows the number of records
    * A bar chart that snows total transaction amount by territory
    * A scatter plot that shows transaction amount and profit amount on the axes and points colored by territory You need to modify the scatter plot to make it easier for users to identify meaningful patterns. The solution must not affect the accuracy of the other visuals-What should you do?
  • Question 34

    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 35

    You have a query that returns the data shown in the following exhibit.

    You need to configure the query to display the data as shown in the following exhibit.

    Which step should you use in the query?