Microsoft PL-300 Exam Practice Test Instant Access

Question 1

You have a Power B1 report that contains three pages named Page1, Page2, and Page3. All the pages have the same slicers. You need to ensure that all the filters applied to Page1 apply to Page1 and Page3 only. What should you do?

ASync the slicers on Page1 and Page3

BOn each page, modify the interactions of the slicer.

CEnable visibility of the slicers on Page1 and Page3. Disable visibility of the slicer on Page2.

Answer : A

Question 2

In Power BI Desktop, you are building a sales report that contains two tables. Both tables have row-level security (RLS) configured.

You need to create a relationship between the tables. The solution must ensure that bidirectional cross-filtering honors the RLS settings.

What should you do?

ACreate an active relationship between the tables and select Assume referential integrity.

BCreate an inactive relationship between the tables and select Assume referential integrity.

CCreate an inactive relationship between the tables and select Apply security filter in both directions.

DCreate an active relationship between the tables and select Apply security filter in both directions.

Answer : D

By default, row-level security filtering uses single-directional filters, whether the relationships are set to single direction or bi-directional. You can manually enable bi-directional cross-filtering with row-level security by selecting the relationship and checking the Apply security filter in both directions checkbox. Select this option when you've also implemented dynamic row-level security at the server level, where row-level security is based on username or login ID.

https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls

Question 3

What should you create to meet the reporting requirements of the sales department?

Aa measure that uses a formula of SUM (Sales [sales_id])

Ba calculated column that use a formula of COUNTA(sales [sales_id])

Ca measure that uses a formula of COUNTROWS (Sales)

Da calculated column that uses a formula of SUM (Sales [sales_id])

Answer : C

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

The COUNTROWS function counts the number of rows in the specified table, or in a table defined by an expression.

https://docs.microsoft.com/en-us/dax/countrows-function-dax

Question 4

You are creating a Power BI report to analyze consumer purchasing patterns from a table named Transactions. The Transactions table contains a numeric field named Spend. You need to include a visual that identifies which fields have the greatest impact on Spend. Which type of visual should you use?

Adecomposition tree

BQ&A

Csmart narrative

Dkey influences

Answer : D

Question 5

For the sales department at your company, you publish a Power Bl report that imports data from a Microsoft Excel We located in a Microsoft SharePoint folder The data model contains several measures You need to create a Power Bl report from the existing dat

a. The solution must minimize development effort. Which type ol data source should you use?

Aa SharePoint folder

BPower Bl dataflows

Can Excel workbook

DPower Bl dataset

Answer : A

case states there is already a report published and the datamodel contains measures. therefore and to be able to use the measures in the datamodel you should connect to the existing dataset (which was created when you plublished the report) instead of starting from scratch with the files in the SharePoint folder.

Question 6

You have a Power BI semantic model named Model1 that contains two table named DimDate and FactSales. There is an active relationship between DimDate and FactSales. DimDate is marked as the date table. FactSales contains the following data.

Model1 contains the following measure:

You have a report that uses Model1. The report has a single report page that has a page level filter set to may 9, 2024. The result of the Previous Year measure is displayed in a card visual.

Which value appear in the card visual?

A10

B15

C35

D60

Answer : B

Question 7

You have a collection of reports for the HR department of your company. The datasets use row-level security (RLS). The company has multiple sales regions that each has an HR manager. You need to ensure that the HR managers can interact with the data from their region only. The HR managers must be prevented from changing the layout of the reports. How should you provision access to the reports for the HR managers?

ACreate a new workspace, copy the datasets and reports, and add the HR managers as members of the workspace.

BPublish the reports to a different workspace other than the one hosting the datasets.

CPublish the reports in an app and grant the HR managers access permission.

DAdd the HR managers as members of the existing workspace that hosts the reports and the datasets.

Answer : C

Note: Row-level security (RLS) with Power BI can be used to restrict data access for given users. Filters restrict data access at the row level, and you can define filters within roles. In the Power BI service, members of a workspace have access to datasets in the workspace. RLS doesn't restrict this data access.

https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls

Microsoft Power BI Data Analyst PL-300 Exam Practice Test