PL-300 Exam Dumps - Microsoft Power BI Data Analyst

You need to provide a user with the ability to add members to a workspace. The solution must use the principle of least privilege.

Which role should you assign to the user?

You have a Power BI imported dataset that contains the data model shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.

NOTE: Each correct selection is worth one point.

You have a Power BI model that contains a table named Sales and a related date table. Sales contains a measure named Total Sales You need to create a measure that calculates the total sales from the equivalent month of the previous year.

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

NOTE: Each correct selection is worth one point.

You have sales data in a star schema that contains four tables named Sales, Customer, Date, and Product.

The Sales table contains purchase and ship dates.

Most often, you will use the purchase date to analyze the data, but you will analyze the data by both dates independently and together.

You need to design an imported dataset to support the analysis. The solution must minimize the model size and the number of queries against the data source.

Which data modeling design should you use?

You are configuring a Power BI report for accessibility as shown in the following table.

You need to change the default colors of all three visuals to make the report more accessible to users who have color vision deficiency.

Which two settings should you configure in the Customize theme window? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

You need to design the data model to meet the report requirements.

What should you do in Power BI Desktop?

You have the Power Bi dashboard shown in the Dashboard exhibit (Click the Dashboard tab.)

You need to ensure that when users view the dashboard on a mobile device, the dashboard appears as shown in the Mobile exhibit. (Click the Mobile tab.)

What should you do? To answer, select the appropriate options m the answer area

NOTE: Each correct selection is worth one point.

You have a table named DiMCountries that contains a column named Country as shown in the following table.

You plan to use DiMCountnes as a dimension m a report.

You new to ensure that the Country column in DiMCountnes lists each country only once.

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

NOTE: Each correct answer is worth one point.