Practice Free PL-300 Exam Online Questions

You need to create a visual that enables the adhoc exploration of data as shown in the following exhibit.

Which type of visual should you use?

Reveal Solution Hide Solution

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 scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as numerical amount representing US dollars.

You need to create a reference line to show which employees are above the median salary.

Solution: You create a median line by using the Salary measure.

Does this meet the goal?

Reveal Solution Hide Solution

You have a report that contains a donut chart and a clustered column chart. Interactions between the visuals use the default settings.

You need to modify the report so that when you select a column m the column chart, the donut chart redraws by using the data from the selected column.

What should you do?

Reveal Solution Hide Solution

Topic 1, Litware, Inc. Case Study

This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided.

To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study.

At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section.

To start the case study

To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question.

Overview

Litware, Inc. is an online retailer that uses Microsoft Power Bl dashboards and reports.

The company plans to leverage data from Microsoft SQL Server databases, Microsoft Excel files, text files, and several other data sources.

Litware uses Azure Active Directory (Azure AD) to authenticate users.

Existing Environment

Sales Data

Litware has online sales data that has the SQL schema shown in the following table.

In the Date table, the dateid column has a format of yyyymmdd and the month column has a format of yyyymm.

The week column in the Date table and the weekid column in the Weekly_Returns table have a format of yyyyww.

The regionid column can be managed by only one sales manager.

Data Concerns

You are concerned with the quality and completeness of the sales data. You plan to verify the sales data for negative sales amounts.

Reporting Requirements

Litware identifies the following technical requirements:

• Executives require a visual that shows sales by region.

• Regional managers require a visual to analyze weekly sales and returns.

• Sales managers must be able to see the sales data of their respective region only.

• The sales managers require a visual to analyze sales performance versus sales targets.

• The sale department requires reports that contain the number of sales transactions.

• Users must be able to see the month in reports as shown in the following example: Feb 2020.

• The customer service department requires a visual that can be filtered by both sales month and ship month independently.

You need to address the data concerns before creating the data model.

What should you do in Power Query Editor?

Reveal Solution Hide Solution

HOTSPOT

You have two CSV files named Products and Categories.

The Products file contains the following columns:

✑ ProductID

✑ ProductName

✑ SupplierID

✑ CategoryID

The Categories file contains the following columns:

✑ CategoryID

✑ CategoryName

✑ CategoryDescription

From Power BI Desktop, you import the files into Power Query Editor.

You need to create a Power BI dataset that will contain a single table named Product.

The Product will table includes the following columns:

✑ ProductID

✑ ProductName

✑ SupplierID

✑ CategoryID

✑ CategoryName

✑ CategoryDescription

How should you combine the queries, and what should you do on the Categories query? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Reveal Solution Hide Solution

Correct Answer:

DRAG DROP

Note: This question is a part of a series of questions that present the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.

Start of repeated scenario

You have a Microsoft SQL Server database that has the tables shown in the Database Diagram exhibit. (Click the Exhibit.)

You plan to develop a Power BI model as shown in the Power BI Model exhibit. (Click the Exhibit).

You plan to use Power BI to import data from 2013 to 2015.

Product Subcategory [Subcategory] contains NULL values.

End of repeated scenario.

You implement the Power BI model.

You need to edit the Product Category table query to match the desired Power BI model.

How should you complete the advanced query? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all.

You may need to frag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Reference:

https://msdn.microsoft.com/en-us/library/mt260776.aspx

https://msdn.microsoft.com/en-us/library/mt260808.aspx

You have a source that contains a comumn. The column contains case sensitive date. You have a Power BI semantic model in DirectQuery mode. You connect to the model and discover that it contains undefined values and errors. You need to resolve the issue.

Solution: You change the semantic model mode.

Does this meet the goal?

Reveal Solution Hide Solution

HOTSPOT

You need to grant access to the business unit analysts.

What should you configure? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Box 1: The Viewer role to the workspace

The Viewer role gives a read-only experience to its users. They can view dashboards, reports, or workbooks in the workspace, but can’t browse the datasets or dataflows. Use the Viewer role wherever you would previously use a classic workspace set to “Members can only view Power BI content”.

Box 2: Build

The analysts must be able to build new reports from the dataset that contains the profit and loss data.

Scenario: The reports must be made available to the board from powerbi.com.

The analysts responsible for each business unit must see all the data the board sees, except the profit and loss data, which must be restricted to only their business unit’s data. The analysts must be able to build new reports from the dataset that contains the profit and loss data, but any reports that the analysts build must not be included in the quarterly reports for the board. The analysts must not be able to share the quarterly reports with anyone.

Reference: https://www.nickyvv.com/2019/08/the-new-power-bi-workspace-viewer-role-explained.html

HOTSPOT

You have a Power Bl report that contains the visual shown in the following exhibit.

Reveal Solution Hide Solution

Correct Answer:

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 scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You have several reports and dashboards in a workspace.

You need to grant all organizational users read access to a dashboard and several reports.

Solution: You publish an app to the entire organization.

Does this meet the goal?

Reveal Solution Hide Solution