PL-300 Exam Question 36

In Power BI Desktop, you are creating a report that will contain three pages.
You need to create a custom tooltip page and prepare the page for use.
Which three actions should you perform? Each correct answer presents part of the solution.
  • PL-300 Exam Question 37

    You plan to create the Power Bl model shown in the exhibit. (Click the Exhibit tab.) The data has the following refresh requirements:
    * Customer must be refreshed daily.
    * Date must be refreshed once every three years.
    * Sales must be refreshed in near real time.
    * SalesAggregate must be refreshed once per week.
    You need to select the storage modes for the tables. The solution must meet the following requirements:

    PL-300 Exam Question 38

    You have two tables named Customers and Invoice in a Power BI model. The Customers table contains the following fields:
    CustomerID
    Customer City
    Customer State
    Customer Name
    Customer Address 1
    Customer Address 2
    Customer Postal Code
    The Invoice table contains the following fields:
    Order ID
    Invoice ID
    Invoice Date
    Customer ID
    Total Amount
    Total Item Count
    The Customers table is related to the Invoice table through the Customer ID columns. A customer can have many invoices within one month.
    The Power BI model must provide the following information:
    The number of customers invoiced in each state last month
    The average invoice amount per customer in each postal code
    You need to define the relationship from the Customers table to the Invoice table. The solution must optimize query performance.
    What should you configure? To answer, select the appropriate options in the answer area.
    NOTE: Each correct selection is worth one point.

    PL-300 Exam Question 39

    You have a Microsoft Power BI data model that contains three tables named Sales, Product, and Date.
    The Sales table has an existing measure named [Total Sales] that sums the total sales from the Sales table.
    You need to write a calculation that returns the percentage of total sales that a selected ProductCategoryName value represents. The calculation must respect any slicers on ProductCategoryName and must show the percentage of visible total sales. For example, if there are four ProductCategoryName values, and a user filters one out, a table showing ProductCategoryName and the calculation must sum up to 100 percent.
    How should you complete the calculation? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
    NOTE: Each correct selection is worth one point.

    PL-300 Exam Question 40

    You need to configure access for the sales department users. The solution must me meet the security requirements. What should you do?