PL-300 Microsoft Exam Questions and Free Practice Test

Question 7

- (Exam Topic 4)
Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is the same in each question in this series.
You have a Microsoft SQL Server database that contains the following tables.
PL-300 dumps exhibit
The following columns contain date information:
- Date[Month] in the mmyyyy format
- Date[Date_ID] in the ddmmyyyy format
- Date[Date_name] in the mm/dd/yyyy format
- Monthly_returns[Month_ID] in the mmyyyy format The Order table contains more than one million rows.
The Store table has a relationship to the Monthly_returns table on the Store_ID column. This is the only relationship between the tables.
You plan to use Power BI Desktop to create an analytics solution for the data.
You need to create a relationship between the Order table and the Store table on the Store_ID column. What should you do before you create the relationship?

A. In the Order table query, use the Table.TrasformRows function.

B. In the Store table query, use the Table.TrasformRows function.

C. In the Store table query, use the Table.TrasformColumnTypes function.

D. In the Order table query, use the Table.TrasformColumnTypes function.

Correct Answer:C

Question 8

- (Exam Topic 4)
You have the visual shown in the Original exhibit. {Click the Original tab.)
PL-300 dumps exhibit
You need to configure the visual as shown in the Modified exhibit. (Click the Modified tab.)

What should you add to the visual?

A. a measure

B. a trendline

C. a forecast

D. an Average line

Correct Answer:C
Explore forecast results by adjusting the desired confidence interval or by adjusting outlier data to see how they affect results.
Timeline Description automatically generated with low confidence
Reference:
https://powerbi.microsoft.com/fr-fr/blog/introducing-new-forecasting-capabilities-in-power-view-for-office-365

Question 9

- (Exam Topic 4)
You have a Microsoft Power Bl dashboard. The report used to create the dashboard uses an imported dataset from a Microsoft SQL Server data source. The dashboard is shown in the exhibit. (Click the Exhibit tab.)
PL-300 dumps exhibit
What occurred at 12:03:06 PM?

A. A user pressed F5

B. A new transaction was added to the data source.

C. A user added a comment to a tile.

D. The dashboard tile cache refreshed.

Correct Answer:D
Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data

Question 10

- (Exam Topic 4)
You need to design the data model to meet the report requirements. What should you do m Power Bl Desktop?

A. From Power Query, add columns to the Orders table to calculate the calendar quarter and the calendar month of the OrderDate column.

B. From Power Bi Desktop, use the Auto date/time option when creating the reports.

C. From Power Query, add a date tabl

D. Create an active relationship to the OrderDate column in the Orders table and an inactive relationship to the ShippedDate column in the Orders table.

E. From Power Query, use a DAX expression to add columns to the Orders table to calculate the calendar quarter of the OrderDate column, the calendar month of the OrderDate column, the calendar quarter of the ShippedDate column, and the calendar month of the ShippedDate column

Correct Answer:D

Question 11

- (Exam Topic 4)
You are developing a report page. Some users will navigate the report by using a keyboard, and some users will consume the report by using a screen reader. You need to ensure that the users can consume the content on a report page in a logical order. What should you configure in Microsoft Power Bl Desktop?

A. the bookmark order

B. the layer order

C. the tab order

D. the X position

Correct Answer:C
If you find yourself unable to navigate to an object or visual while using a keyboard, it may be because the report author has decided to hide that object from the tab order. Report authors commonly hide decorative objects from the tab order. If you find that you cannot tab through a report in a logical manner, you should contact the report author. Report authors can set the tab order for objects and visuals.
Reference:
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-accessibility-consuming-tools

Question 12

- (Exam Topic 4)
You need to provide a user with the ability to add members to a workspace. The solution must use the principle of least privilege.
Which role should you assign to the user?

A. Viewer

B. Contributor

C. Member

D. Admin

Correct Answer:C
A Member can add members or others with lower permissions. Note:
PL-300 dumps exhibit

START PL-300 EXAM