Microsoft PL-300 Microsoft Power BI Data Analyst Exam Practice Test

You have the CSV file shown in the following table.

You use Power Query Editor to preview the data in the file.

You need to transform the data to meet the following requirements:

* The first column must contain the month.

* The second column must contain the year.

* The third column must contain the order amount for the month and year.

Which transformation should you use first?

You have a project management app that is fully hosted in Microsoft Teams. The app was developed by using Microsoft Power Apps.

You need to create a Power BI report that connects to the project management app.

Which connector should you select?

You have a Power BI data model that contains a table named Employees. The table has the following columns:

* Employee Name

* Email Address

* Start Date

* Job Title

You are implementing dynamic row-level security (RLS).

You need to create a table filter to meet the following requirements:

* Users must see only their own employee data

* The DAX expression must work in both Power 81 Desktop and the Power BI service.

Which expression should you use?

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.

You have five reports and two dashboards in a workspace.

You need to grant all organizational users read access to one dashboard and three reports

Solution: In Microsoft Azure Active Directory (Azure AD), part of Microsoft Entr

a. you create a group that contains all the users. You share each selected report and the one dashboard to the group.

Does this meet the goal?

You have a Power BI model that contains a table named Sales. The Sales table contains the following columns:

* Order Line ID

* Product ID

* Unit Price

* Order ID

* Quantity

Orders are uniquely identified by using the order ID and can have multiple order lines Each order line within an order contains a different product ID.

You need to write a DAX measure that counts the number of orders.

Which formula should you use?

You have a Power Bi model mat contains a table named Date. The Date table contains the fallowing columns:

* Date

* Fiscal year

* Fiscal Quartet

* Month Name

* Calendar Year

* Week Number

* Month Number

* Calendar Quarter

You need to create a calculated table based on the Date table. The calculated tab*e must contain only unique combinations of values for Calendar Year. Calendar Quarter and Calendar Month. Which DAX function should you include in the table deflation?

You have a Power Bl report that contains a page. The page contains the following:

* A shape named Shape 1

* A card named Sales Summary

* A clustered bar chart named Sales by Region

You need to ensure that Sales Summary renders on top of Shape 1. What should you modify?