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

Page: 1 / 14
Total 295 questions

Question 1

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.

From Power Query Editor, you profile the data shown in the following exhibit.

The IOT ID columns are unique to each row in query.

You need to analyze 10T events by the hour and day of the year. The solution must improve dataset performance.

Solution: You change the IOT DateTime column to the Date data type.

Does this meet the goal?



Answer : A

Question 2

You have a Power B1 model that contains a table named Date. The table has the following columns.



Answer : A

Question 3

You have a Power BI report named Report' and a dashboard named Dashboard'. Report1 contains a line chart named Sales by month.

You pin the Sales by month visual to Dashboard1.

In Report1, you change the Sales by month visual to a bar chart.

You need to ensure that the bar chart displays on Dashboard',

What should you do?



Answer : A

Question 4

You have a Power Bl report named Report1 and a dashboard named Dashboard1, Report1 contains a line chart named Sales by month.

You pin the Sales by month visual to Dashboard1.

In Report1, you change the Sales by month visual to a bar chart.

You need to ensure that bar chart displays on Dashboard1.

What should you do?



Answer : D

Question 5

You need to create a Power BI 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?



Answer : B

Question 6

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

* Store Name

* Open Date

* Status

* State

* City

You need to create a calculated column named Active Store Name that meets the following requirements:



Answer : A

Question 7

The Sales table contains records of sales by day from the last five years up until today's date.

You plan to create a measure to return the total sales Of March 2021 when March 2022 is selected.

Which DAX expression should you use?



Answer : B

Page:    1 / 14   
Total 295 questions