Important Microsoft PL-300 Exam Questions

You plan to develop a Power BI report that has a bar chart to display the number of customers by location. You have a table named Customer that has the following columns:

* Customer ID

* CustomerName

* Address

* City

* ProvState

* Country

You need to allow users to drill down by location. The report will display the number of each customer by Country, and drill down to ProvState, and then to City. How should you configure the drill down in the bar chart?

You have a Microsoft SharePoint Online site that contains several document libraries. One of the document libraries contains manufacturing reports saved as Microsoft Excel files. All the manufacturing reports have the same data structure.

You need to load only the manufacturing reports to a table for analysis.

What should you do in Microsoft Power Bl Desktop?

You have a semantic model that contains a table named Employees. The table contains the following columns:

* Employee ID

* First Name

* Last Name

* Department

* Salary

Each employee is uniquely identified by using Employee ID.

You need to create a DAX measure that will calculate the average salary of all the employees in the sales department.

Which DAX expression should you use?

You use an R visual to produce a map of 500,000 customers. You include the values of CustomerID, Latitude, and Longitude in the fields sent to the visual. Each customer ID is unique.

In powerbi.com, when users load the visual, they only see some of the customers.

What is the cause of the issue?

You are creating a new semantic model in Microsoft Power Bl Desktop.

You connect to a recently used data source and receive an error message indicating that the password is expired.

You need to update the credentials for the data source.

What should you do?