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

Page: 1 / 14
Total 347 questions
Question 1

In Power BI Desktop, you have a dataset that contains a table.

You create a table visual on a Power BI report page as shown in the following exhibit

You need to configure the visual to display the referenced image instead of the URL in the Plant Image column.

What should you do?



Answer : A


Question 2

You have data in a Microsoft Excel worksheet as shown in the following table.

You need to use Power Query to clean and transform the dataset. The solution must meet the following requirements:

* If the discount column returns an error, a discount of 0.05 must be used.

* All the rows of data must be maintained.

* Administrative effort must be minimized.

What should you do in Power Query Editor?



Answer : C


Question 3

You are building a data model for a Power Bl report. You have data formatted as shown in the following table.

You need to create a clustered bar chart as shown in the following exhibit.

What should you do?



Answer : A


Question 4

You have a Microsoft SharePoint Online site that contains several document libraries.

One of the document libraries contains manufactunng reports saved as Microsoft Excel files. All the manufacturing reports have the same data structure.

You need to use Power Bl Desktop to load only the manufacturing reports to a table for analysis.

What should you do?



Answer : D


Question 5

You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date and time each compliant occurred. The data in Logged is in the fol-lowing format: 2018-12-31 at 08:59. You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy. What should you do?



Question 6

Remove unused columns from tables in the data model. This will reduce the size of your PBIX file and make your data model more efficient. You can use Power Query Editor to remove any columns that are not used in your report or calculations.

* Month

* Sales

* Year

'What should you select in Power Query Editor?



Answer : C

This will convert your column headers (Jan-20, Feb-20,...) into row values under a new column called Attribute. You can then rename this column as Month and change its data type to Date. You will also have a new column called Value that contains the sales amounts for each month. You can rename this column as Sales and change its data type to Decimal Number.


Question 7

You are creating a query to be used as a Country dimension in a star schema.

A snapshot of the source data is shown in the following table.

You need to create the dimension. The dimension must contain a list of unique countries.

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



Answer : A, D

To create a dimension table for Country from your source data, you need to perform these two actions34:

Delete the City column. You don't need this column for your Country dimension, as it is not a descriptive attribute of Country. You can create another dimension table for City if you want to use it in your analysis.

Remove duplicates from the Country column. You want to have a list of unique countries in your dimension table, so you need to remove any duplicate values from this column.


Page:    1 / 14   
Total 347 questions