PL-300 Exam Dumps - Microsoft Certified: Power BI Data Analyst Associate Questions and Answers

You need to create a solution to meet the notification requirements of the warehouse shipping department.

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

NOTE: Each correct select is worth one point:

You need to configure access for the sales department users. The solution must me meet the security requirements. What should you do?

You need to create a relationship in the dataset for RLS.

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

NOTE: Each correct selection is worth one point.

You use Power Query to import two tables named Order Header and Order Details from an Azure SQL database. The Order Header table relates to the Order Details table by using a column named Order ID in each table.

You need to combine the tables into a single query that contains the unique columns of each table.

What should you select in Power Query Editor?

You need to create a relationship in the data model for RLS.

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

NOTE: Each correct selection is worth one point.

You need to create the On-Time Shipping report. The report must include a visualization that shows the percentage of late orders.

Which type of visualization should you create?

You have a semantic model named Model1 that contains the following tables

There is an active relationship between SaleDate and Date.

There is an inactive relationship between ShippingDate and Date-

You need to create a new measure that will display the total amount of sales and support slicing by ShippingDate.

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.

You need to create a Power Bl theme that will be used in multiple reports. The theme will include corporate branding for font size, color, and bar chart

formatting.

What should you do?

You have a semantic model that contains a table named Sales. The table contains the following columns;

• Order ID

• Product ID

• Sales Dote

• Sales Amount

You need to create a DAX measure that will return the total sales amount for the same dates from the previous year. How should you complete the measure? To answer, select the appropriate options m the answer area.

NOTE: Each correct selection is worth one point.