Free Online Microsoft PL-300 Practice Test

You import a Power Bl dataset that contains the following tables:Date

• Product

• Product Inventory

The Product inventory table contains 25 million rows. A sample of the data is shown in the following table

The Product Inventory table relates to the Date table by using the DateKey column. The Product inventory table relates to the Product table by using the ProductKey column. You need to reduce the size of the data model without losing information. What should you do?

You have a dataset that is used infrequently and refreshes every hour. You receive a notification that the refresh was disabled due to inactivity. Which two actions will cause the scheduled refresh schedule to resume? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

You need to create a relationship between the Weekly_Returns table and the Date table to meet the reporting

requirements of the regional managers. What should you do?

Note: This question is part of a series of questions that present the same scenario. Each question in the series

contains a unique solution that might meet the stated goals. Some question sets might have more than one

correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions

will not appear in the review screen.

From Power Query Editor, you profile the data shown in the following exhibit.

The IOT ID columns are unique to each row in query.

You need to analyze 10T events by the hour and day of the year. The solution must improve dataset

performance.

Solution: You create a custom column that concatenates the 10T GUID column and the IoT ID column and

then delete the IoT GUID and IoT ID columns.

Does this meet the goal?

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?