Question 1

You need to get data from the Microsoft SQL Server tables. What should you use to configure the connection'

Accepted Answer

Correct answer: B

Question 2

You need to address the data concerns before creating the data model. What should you do in Power Query Editor?

Accepted Answer

Correct answer: C

Question 3

HOTSPOT - (Topic 2)
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.

Accepted Answer

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.

Question 4

Certshared now are offering 100% pass ensure PL-300 dumps!
/exam/PL-300/ (311 Q&As)
HOTSPOT - (Topic 2)
How should you distribute the reports to the board? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Accepted Answer

Box 1: Using a workspace membership Scenario:
The company wants to provide a single package of reports to the board that contains custom navigation and links to supplementary information.
Note: Workspace is a shared environment for a group of people. You can have multiple Power BI content in a workspace. One workspace can have hundreds of
dashboards, reports, and datasets in it.
Box 2: A mail-enabled security group Scenario: Security Requirements
The reports must be made available to the board from powerbi.com. A mail-enabled security group will be used to share information with the board.

Question 5

What is the minimum number of datasets and storage modes required to support the reports?

Accepted Answer

"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" => one dataset and two separate
workspaces Reason: All data can be imported into one dataset also if these are two logical models. Shared dimensions can be reconsumed in both models.
Reports and additional materials can be shared to the board with an app. The "profit and loss" data model needs RLS for the analysts and the analysts must have
just read access to the original workspace. In a separate workspace with contributer (or more rights) they can create new reports (with live connection to the
dataset). It is also stated that the new reports mustn't be shared so therefore no need to include them into the app. Import vs. DirectQuery: Due to RLS
requirements an imported dataset is needed. It is not possible with file sources and Sharepoint lists.

Question 6

HOTSPOT - (Topic 3)
You need to create the Top Customers report.
Which type of filter should you use, and at which level should you apply the filter? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Certshared now are offering 100% pass ensure PL-300 dumps!
/exam/PL-300/ (311 Q&As)

Accepted Answer

Box 1: Top N
Scenario: The Top Customers report will show the top 20 customers based on the highest sales amounts in a selected order month or quarter, product category,
and sales region.
Once you drag to SKU to Visual level filter you should get Top N option Note: The two most common filter types: automatic and manual.
Then there are more advanced filters.
Box 2: Visual
Once you drag to SKU to Visual level filter you should get Top N option.

Question 7

You need to design the data model to meet the report requirements. What should you do in Power BI Desktop?

Accepted Answer

Use Power Query to calculate calendar quarter and calendar month.
Scenario:
? A single dataset must support all three reports:
- The Top Customers report will show the top 20 customers based on the highest sales amounts in a selected order month or quarter, product category, and sales
region.
- The Top Products report will show the top 20 products based on the highest sales amounts sold in a selected order month or quarter, sales region, and product
category.
? The data model must minimize the size of the dataset as much as possible, while
meeting the report requirements and the technical requirements.

Question 8

HOTSPOT - (Topic 3)
You need to create a relationship in the dataset for RLS.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Accepted Answer

Description automatically generated Box 1: many-to-one
Each employee in the Sales Employees table is assigned to one sales region. Multiple employees can be assigned to each region.
The Suppliers table has a Region column. Box 2: Suppliers table

Question 9

You need to minimize me size of the dataset. The solution must meet the report requirements What should you do?

Accepted Answer

Correct answer: C

Question 10

HOTSPOT - (Topic 3)
You need to design the data model and the relationships for the Customer Details worksheet and the Orders table by using Power BI. The solution must meet the
report requirements.
For each of the following statement, select Yes if the statement is true, Otherwise, select No.
NOTE: Each correct selection is worth one point.

Certshared now are offering 100% pass ensure PL-300 dumps!
/exam/PL-300/ (311 Q&As)

Accepted Answer

Correct answer: A