PL-300 Free Practice Test

DRAG DROP - (Topic 4)
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.

Solution:


Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A

FILL IN THE BLANK - (Topic 4)
You have a Power Bl visual that uses indicators to show values that are out of range as shown in the following exhibit.

Solution:


Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A

- (Topic 4)
You have the tables shown in the following table.

The Impressions table contains approximately 30 million records per month. You need to create an ad analytics system to meet the following requirements:
✑ Present ad impression counts for the day, campaign, and Site_name. The
analytics for the last year are required.
✑ Minimize the data model size.
Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

1. A. Group the impressions by Ad_id, Site_name, and Impression_dat
2. B. Aggregate by using the CountRows function.
3. C. Create one-to-many relationships between the tables.
4. D. Create a calculated measure that aggregates by using the COUNTROWS function.
5. E. Create a calculated table that contains Ad_id, Site_name, and Impression_date.

Correct Answer: AB
Grouping in power query reduces the number of rows in the impression table that is gonna be loaded in the model. Creating relationships doesn't increase the size of the model.

DRAG DROP - (Topic 2)
Once the profit and loss dataset is created, which four actions should you perform in sequence to ensure that the business unit analysts see the appropriate profit and loss data? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Solution:

https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls https://docs.microsoft.com/en-us/power-bi/connect-data/service-datasets-build-permissions

Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A

- (Topic 1)
You need to create the required relationship for the executive's visual. What should you do before you can create the relationship?

1. A. Change the data type of Sales[region_id] to Whole Number.
2. B. In the Sales table, add a measure for sum(sales_amount).
3. C. Change the data type of sales[sales_id] to Text.
4. D. Change the data type of sales [region_id] to Decimal Number.

Correct Answer: A
Scenario: Executives require a visual that shows sales by region.
Need to change the sales_id column from Varchar to Whole Number (Integer).