Free Microsoft PL-300 Übungsprüfungen

Question #1

You need to provide a solution to provide the sales managers with the required access.

What should you include in the solution?

A . Create a security role that has a table filter on the Sales_Manager table where username = UserName()
B . Create a security role that has a table filter on the Region_Manager table where sales_manager_id = UserPrincipalName().
C . Create a security role that has a table filter on the Sales_Manager table where name = UserName().
D . Create a security role that has a table filter on the Sales_Manager table where username = sales_manager_id.

Lösung einblenden Lösung ausblenden

Question #2

You have a report that contains four pages. Each page contains slicers for the same four fields. Users report that when they select values on a slicer on one page, the visuals are not updated on all the pages. You need to recommend a solution to ensure that users can select a value once to filter the results on all the pages.

What are two possible recommendations to achieve this goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

A . Sync the slicers across the pages.
B . Replace the slicers with page-level filters.
C . Replace the slicers with visual-level filters.
D . Create a bookmark for each slicer value.
E . Replace the slicers with report-level filters.

Lösung einblenden Lösung ausblenden

Question #3

DRAG DROP

You are building a dataset from a JSON file that contains an array of documents.

You need to import attributes as columns from all the documents in the JSON file. The solution must ensure that date attributes can be used as date hierarchies in Microsoft Power BI reports.

Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Lösung einblenden Lösung ausblenden

Question #4

You have a Microsoft Power Bl dashboard.

You need to ensure that consumers of the dashboard can give you feedback that will be visible to the other consumers of the dashboard.

What should you use?

A . Feedback
B . Subscribe
C . Comments
D . Mark as favorite

Lösung einblenden Lösung ausblenden

Question #5

You need to create relationships to meet the reporting requirements of the customer service department.

What should you create?

A . an additional date table named ShipDate, a one-to-many relationship from Sales[sales_date_id] to Date[date_id], and a one-to-many relationship from Sales[sales_ship_date_id] to ShipDate[date_id]
B . an additional date table named ShipDate, a many-to-many relationship from Sales[sales_date_id] to Date[date_id], and a many-to-many relationship from Sales[sales_ship_date_id] to ShipDate[date_id]
C . a one-to-many relationship from Date[date_id] to Sales[sales_date_id] and another one-to-many relationship from Date[date_id] to Weekly_Returns[week_id]
D . a one-to-many relationship from Sales[sales_date_id] to Date[date_id] and a one-to-many relationship from Sales[sales_ship_date_id] to Date[date_id]
E . a one-to-many relationship from Date[date_id] to Sales[sales_date_id] and another one-to-many relationship from Date[date_id] to Sales[sales_ship_date_id]

Lösung einblenden Lösung ausblenden

Question #6

You need to ensure that the data is updated to meet the report requirements. The solution must minimize configuration effort.

What should you do?

A . From each report in powerbi.com. select Refresh visuals
B . From Power Bl Desktop, download the PBIX file and refresh the data.
C . Configure a scheduled refresh without using an on-premises data gateway.
D . Configure a scheduled refresh by using an on-premises data gateway

Lösung einblenden Lösung ausblenden

Question #7

DRAG DROP

Once the profit and loss dataset is created, which four actions should you perform in sequence to ensure that the business unit analysts see the appropriate profit and loss data? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Lösung einblenden Lösung ausblenden

Question #8

You build a report to analyze customer transactions from a database that contains the tables shown in the following table.

You import the tables.

Which relationship should you use to link the tables?

A . one-to-many from Customer to Transaction
B . one-to-one between Customer and Transaction
C . one-to-many from Transaction to Customer
D . many-to-many between Customer and Transaction

Lösung einblenden Lösung ausblenden

Question #9

HOTSPOT

You need to create a solution to meet the notification requirements of the warehouse shipping department.

What should you do? To answer, select the appropriate options in the answer area. NOTE: Each correct select is worth one point:

Lösung einblenden Lösung ausblenden

Question #10

You create a dashboard by using the Microsoft Power Bl Service. The dashboard contains a card visual that shows total sales from the current year. You grant users access to the dashboard by using the viewer role on the workspace. A user wants to receive daily notifications of the number shown on the card visual. You need to automate the notifications.

What should you do?

A . Share the dashboard to the user.
B . Create a subscription.
C . Create a data alert.
D . Tag the user in a comment.

Lösung einblenden Lösung ausblenden