Microsoft Power BI Data Analyst PL-300 Exam Questions with Experts Answers Updated Recently

You have a PBiX file that imports several tables from an Azure SQL database.

The data will be migrated to another Azure SQL database.

You need to change the connections in the PBIX file. The solution must minimize administrative effort.

What should you do?

You are profiting data by using Power Query Editor.

You have a table that contains a column named column1. Column statistics and Value distribution for column1 are shown in the following exhibit.

You have a prospective customer list that contains 1,500 rows of data. The list contains the following fields:

First name

Last name

Email address

State/Region

Phone number

You import the list into Power Query Editor.

You need to ensure that the list contains records for each State/Region to which you want to target a marketing campaign.

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

NOTE: Each correct selection is worth one point.

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?