Microsoft Power BI Data Analyst PL-300 Exam Practice Test

Page: 1 / 14
Total 459 questions
Question 1

You have a Power Bl report

You have a table named Dalai that contains 10 million rows. Data is used in the following visuals:

* A card that shows the number of records

* A bar chart that snows total transaction amount by territory

* A scatter plot that shows transaction amount and profit amount on the axes and points colored by territory

You need to modify the scatter plot to make it easier for users to identify meaningful patterns. The solution must not affect the accuracy of the other visuals-What should you do?



Answer : B


Question 2

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

Answer is as below


Question 3

You have a Power Bl workspace named Workspace1 that contains a dataset named DS1 and a report named RPT1.

A user wants to create a report by using the data In DS1 and publish the report to another workspace.

You need to provide the user with the appropriate access. The solution must minimize the number of access permissions granted to the user.

What should you do?



Answer : D

Microsoft says: To copy a report to another workspace, and to create a report in another workspace based on a dataset in the current workspace, you need Build permission for the dataset. For datasets in the original workspace, if you have at least the Contributor role, you automatically have Build permission through your workspace role.

https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-roles-new-workspaces


Question 4

You have a table that contains sales data and approximately 1,000 rows.

You need to identify outliers in the table. Which type of visualization should you use?



Answer : C

Outliers are those data points that lie outside the overall pattern of distribution & the easiest way to detect outliers is though graphs. Box plots, Scatter plots can help detect them easily.


https://towardsdatascience.com/this-article-is-about-identifying-outliers-through-funnel-plots-using-the-microsoft-power-bi-d7ad16ac9ccc

Question 5

You are developing a sales report that will have multiple pages. Each page will answer a different business question.

You plan to have a menu page that will show all the business questions.

You need to ensure that users can click each business question and be directed to the page where the

question is answered. The solution must ensure that the menu page will work when deployed to any

workspace.

What should you include on the menu page?



Answer : B

When you create a bookmark, the following elements are saved with the bookmark: - The current page - Filters - Slicers, including slicer type (for example, dropdown or list) and slicer state - Visual selection state (such as cross-highlight filters) - Sort order - Drill location - Visibility of an object (by using the Selection pane) - The focus or Spotlight modes of any visible object


Question 6

You need to provide a user with the ability to add members to a workspace. The solution must use the principle of least privilege.

Which role should you assign to the user?



Answer : C

A Member can add members or others with lower permissions.

Note:


Question 7

You are creating a Power Bl report by using Power Bi Desktop.

You need to include a visual that shows trends and other useful information automatically. The visual must update based on selections in other visuals.

Which type of visual should you use?



Answer : D


Page:    1 / 14   
Total 459 questions