Free Microsoft PL-300 Practice Exam with Questions & Answers | Set: 4

You have a Power Bl semantic model that contains the following tables.

All the tables use the same data source.

You need to reduce the number of limited relationships in the model by changing the storage mode of certain tables. The solution must NOT affect the latency of the data.

Which storage mode should you select for the Customer and Geography tables? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You have a collection of reports for the HR department of your company.

You need to create a visualization for the HR department that shows historical employee counts and predicts trends during the next six months.

Which type of visualization should you use?

You are building a Power Bl report.

Users will view the report by using their mobile device.

You need to configure the report to display data based on each user s location.

Which two actions should you perform? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

You have a semantic model.

You need to configure row level security (RLS) to restrict data access for users that have the Viewer permissions.

Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to tie answer area and arrange them in the correct order.

You are using the key influencers visual to identify which factors affect the quantity of items sold in an order.

You add the following fields to the Explain By field:

* Customer Country

* Product Category

* Supplier Country

* Sales Employee

* Supplier Name

* Product Name

* Customer City

The key influencers visual returns the results shown in the following exhibit.

What can you identify from the visual?

You are building a financial report by using Power BI.

You have a table named financials that contains a column named Date and a column named Sales.

You need to create a measure that calculates the relative change in sales as compared to the previous quarter.

How should you complete the measure? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You a-e using Power Bl Desktop 10 profile data in Power Query Editor.

You need to review the percentage of errors and the maximum value of each column.

Which options should you use in Power Query Editor? To answer, drag the appropriate options to the correct requirements. Each option 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.

ion have a Power BI dataset that contains a table named Temperature Readings. Temperature Readings contains the columns shown in the following table.

The table has 12 million rows. All the columns are needed for analysis.

You need to optimize the dataset to decrease the model size. The solution must not affect the precision of the data.

What should you do?

You import a large dataset to Power Query Editor.

You need to identify whether a column contains only unique values.

Which two Data Preview options can you use? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point

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.