Microsoft PL-300 Exam Practice Test Instant Access

Question 1

You have a Power Bl report that uses row-level security (RLS).

You need to transfer RLS membership maintenance to an Azure network security team. The solution must NOT provide the Azure network security team with the ability to manage reports, datasets. or dashboards.

What should you do?

AAdd the Azure network security team as members of the RLS role.

BInstruct the Azure network security team to create security groups. Configure RLS to use the groups.

CConfigure custom instructions for the Request access feature that instructs users to contact the Azure network security team.

DGrant the Read and Build permissions for the Power Bl datasets to the Azure network security team.

Answer : B

It is common practice that the PBI developer creates RLS groups and instructs the network team to create the corresponding AD roles. Then the developer assigns the AD groups to the RLS groups.

Question 2

You attempt to open a PBiX file in Microsoft Power Bl Desktop and receive the following error message in Power Query Editor.

DataSource. Error: Could of not find file D:\Data.txt.

How should you resolve the issue?

AChange the file format to CSV.

BUse an on-premises data gateway.

CChange the file path of DataM

DUpdate the Microsoft OLE OS Provider client libraries on your client computer.

Answer : C

Question 3

You have a Power BI tenant.

You have reports that use financial datasets and are exported as PDF files.

You need to ensure that the reports are encrypted.

What should you implement?

Adataset certifications

Brow-level security (RLS)

Csensitivity labels

DMicrosoft Intune policies

Answer : C

General availability of sensitivity labels in Power BI.

Microsoft Information Protection sensitivity labels provide a simple way for your users to classify critical content in Power BI without compromising productivity or the ability to collaborate. Sensitivity labels can be applied on datasets, reports, dashboards, and dataflows. When data is exported from Power BI to Excel, PowerPoint or PDF files, Power BI automatically applies a sensitivity label on the exported file and protects it according to the label's file encryption settings. This way your sensitive data remains protected no matter where it is.

https://powerbi.microsoft.com/en-us/blog/announcing-power-bi-data-protection-ga-and-introducing-new-capabilities/

Question 4

You have a Fabric workspace named Workspace1 that contains two Power Bl reports named Report1 and Report2.

You create a workspace app that contains both reports.

You need to ensure that the app meets the following requirements:

* Report1 must be visible to all the users in your organization.

* Report2 must be visible to only a security group named Group1.

What should you do next?

AAssign Group1 the Viewer role for Workspace1.

BShare Report1 with the built-in All users security group.

CCreate an audience and assign Group1 to the audience.

DAllow access to the hidden content of the app.

Answer : C

Question 5

You plan to create a dashboard in the Power BI service that retrieves data from a Microsoft SQL Server database. The dashboard will be shared between the users in your organization.

You need to ensure that the users will see the current data when they view the dashboard.

How should you configure the connection to the data source?

ADeploy an on-premises data gateway (personal mode). Import the data by using the Import Data Connectivity mode.

BDeploy an on-premises data gateway. Import the data by using the Import Data Connectivity mode.

CDeploy an on-premises data gateway. Import the data by using the DirectQuery Data Connectivity mode.

DDeploy an on-premises data gateway (personal mode). Import the data by using the DirectQuery Data Connectivity mode.

Answer : D

Question 6

SIMULATION

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.

ASee the answer as below in explanation

Answer : A

Explanation.

Answer as below

Question 7

You import two Microsoft Excel tables named Customer and Address into Power Query Customer contains the following columns:

* Customer ID

* Customer Name

* Phone

* Email Address

* Address ID

Address contains the following columns:

* Address ID

* Address Line 1

* Address Line 2

* City

* State/Region

* Country

* Postal Code

Each Customer ID represents a unique customer m the Customer table. Each Address ID represents a unique address m the Address table. You need to create a query that has one row per customer. Each row must contain City. State/Region, and Country for each customer. What should you do?

AAppend the Customer and Address tables.

BTranspose the Customer and Address tables.

CGroup the Customer and Address tables by the Address ID column.

DMerge the Customer and Address tables.

Answer : D

Microsoft Power BI Data Analyst PL-300 Exam Practice Test