PL-300 Exam Question 206

DRAG DROP
You build a report about warehouse inventory data. The dataset has more than 10 million product records from 200 warehouses worldwide.
You have a table named Products that contains the columns shown in the following table.

Warehouse managers report that it is difficult to use the report because the report uses only the product name in tables and visuals. The product name is contained within the ProductDescription column and is always the fourth value.
You need to modify the report to support the warehouse managers requirement to explore inventory levels at different levels of the product hierarchy. The solution must minimize the model size.
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.

PL-300 Exam Question 207

You have a Power Bl model that contains two tables named Population and Date.
The Population table contains two columns named Population Amount and Date Key.
DateKey contains date values that represent the first day of a year and are used to create a many-to The Power Bl model contains two measures that have the following definitions.
Total Population = Sum ('Population'[Population Amount])
2023 Population = CALCULATE ([Total Population]"Date'[Year] = 2023)
You create a table visual that displays Date[Year] and [2023 Population].
What will the table visual show?
  • PL-300 Exam Question 208

    Your company plans to use Power BI for 20 users in the sales department. The users will perform the following tasks:
    Access a published Power BI app
    Modify reports in an app workspace
    Share dashboards created in My Workspace
    You need to identify which Power BI licenses are required for the tasks. The solution must use the Power BI (free) licenses, whenever possible.
    Which license should you identify for each task? To answer, select the appropriate options in the answer area.
    NOTE: Each correct selection is worth one point.

    PL-300 Exam Question 209

    You have a dataset named Pens that contains the following columns:
    Unit Price
    Quantity Ordered
    You need to create a visualization that shows the relationship between Unit Price and Quantity Ordered. The solution must highlight orders that have a similar unit price and ordered quantity.
    Which type of visualization and which feature should you use? To answer, select the appropriate options in the answer area.
    NOTE: Each correct selection is worth one point.

    PL-300 Exam Question 210

    You need to create a measure that will return the percentage of late orders.
    How should you complete the DAX expression? To answer, select the appropriate options in the answer area.
    NOTE: Each correct selection is worth one point.