PL-300 Practice Online

Question 1

You have a Power Bl report. You have the following tables.

You have the following DAX measure.

A : A table visual that displays the date hierarchy at the year level and the [Accounts] measure will show the total number of accounts that were live throughout the year.

B : A table visual that displays the date hierarchy at the month level and the [Accounts] measure will show the total number of accounts that were live throughout the month.

C : A table visual that displays the date hierarchy at the day level and the [Accounts] measure will show the total number of accounts that were live that day.

Answer: C

Question 2

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?

A : Yes

B : No

Answer: B

Question 3

You have a Power Bl query named Sates that imports the columns shown in the following table.

Usees only use the dale part of the Sales.Date field. Only rows with a Status of Finished are used in analysis. You need to reduce the load times of the query without affecting the analysis. Which two actions achieve this goal? Each correct answer presents a complete solution. NOTL Each correct selection is worth one pant.

A : Remove the rows in which sales [status] has a value of Canceled.

B : Change the data type of sale [Delivery_Time] to Integer

C : Removes (Canceled Date).

D : Split Sales [Sale_Date] into separate date and time columns.

E : Remove sales [Sales_Date].

Answer: A,D

Question 4

You have a Microsoft Excel file in a Microsoft OneDrive folder. The file must be imported to a Power Bi dataset You need to ensure that the dataset can be refreshed in powefbi.com. Which two connectors can you use to connect to the file? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point

A : Text/CSV

B : Folder

C : Excel Workbook

D : SharePoint folder

E : Web

Answer: B,C

Question 5

You have a report in Power Bl named report1 that is based on a shared dataset. You need to minimize the risk of data exfiltration for report1. The solution must prevent other reports from being affected. What should you do?

A : Clear Allow recipients to share your dashboard and Allow users to build new content using the underlying datasets for the dataset.

B : Select the Allow end users to export both summarized and underlying data from the service or Report Server Export data option for the report.

C : Select the Don't allow end users to export any data from the service or Report Server Export data option for the report

D : Apply row-level security (RLS) to the shared dataset.

Answer: C

Name:	Microsoft Certified Power BI Data Analyst Associate
Exam Code:	PL-300
Certification:	Data Analyst Associate
Vendor:	Microsoft
Total Questions:	465
Last Updated:	Oct 23, 2026

Download Demo PL-300 Dumps

Create Account

Password Recovery

Download Demo PL-300 Dumps

Member Login

Create Account

Password Recovery

PL-300 Practice Online