Free Microsoft PL-300 Exam Questions

Become Microsoft Certified with updated PL-300 exam questions and correct answers

Page: 1 / 93

Total 465 Questions | Updated On: Apr 27, 2026

Add To Cart

Question 1

You have a Power Bi model mat contains a table named Date. The Date table contains the fallowing columns:

• Date

• Fiscal year

• Fiscal Quartet

• Month Name

• Calendar Year

• Week Number

• Month Number

• Calendar Quarter

You need to create a calculated table based on the Date table. The calculated tab*e must contain only unique

combinations of values for Calendar Year. Calendar Quarter and Calendar Month. Which DAX function

should you include in the table deflation?

A : DATATABLE

B : ADDCOLUMS

C : SUMMARIZE

D : CALCULATE

Answer: C

Question 2

You attempt to connect Power BI Desktop to a Cassandra database. From the Get Data connector list, you discover that there is no specific connector for the Cassandra database. You need to select an alternate data connector that will connect to the database. Which type of connector should you choose?

A : Microsoft SQL Server database

B : ODBC

C : OLE DB

D : OData

Answer: C

Question 3

You have a Power Bl model that contains two tables named Population and Date. The Population table contains two columns named Population Amount and Date Key. DateKey contains date values that represent the first day of a year and are used to create a many-to The Power Bl model contains two measures that have the following definitions. Total Population = Sum ('Population'[Population Amount]) 2023 Population = CALCULATE ([Total Population]"Date'[Year] = 2023) You create a table visual that displays Date[Year] and [2023 Population]. What will the table visual show?

A : one row per year that contains blank values for every year except 2023

B : one row per date that contains the population value for the corresponding year repeated in each row

C : a single row for the year 2023 that contains the related population value

D : one row per year that contains the same value repeated for each year

Answer: C

Question 4

You build a Power Bi report that displays loT temperature data streaming from a refrigerator. You publish the report to the Power BI service. You need to be notified when the temperature rises above four degrees Celsius. What should you do?

A : Set an alert on a KPI visual in the report.

B : Pin a card visual to a dashboard and create a subscription.

C : Pin a card visual to a dashboard and set an alert on the tile.

D : Pin a report page to a dashboard and set an alert on the page.

Answer: A

Question 5

You have a Power Bl report hosted on powerbi.com that displays expenses by department for department managers. The report contains a line chart that shows expenses by month. You need to enable users to choose between viewing the report as a line chart or a column chart. The solution must minimize development and maintenance effort. What should you do?