Microsoft PL-300 - Microsoft Power BI Data Analyst
You need to calculate the last day of the month in the balance sheet data to ensure that you can relate the balance sheet data to the Date table. Which type of calculation and which formula should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
You have a Microsoft Power Bl workspace.
You need to grant the user capabilities shown in the following table.
The solution must use the principle of least privilege.
Which user role should you assign to each user? To answer, drag the appropriate roles to the correct users. Each role may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
You have a Power Bl report that contains a page. The page contains the following:
• A shape named Shape 1
• A card named Sales Summary
• A clustered bar chart named Sales by Region
You need to ensure that Sales Summary renders on top of Shape 1. What should you modify?
You have a Power Bl workspace that contains several reports.
You need to provide a user with the ability to create a dashboard that will use the visuals from the reports.
What should you do?
Vou have a Microsoft Power Bl Desktop report named Report! that uses an Azure SQL database as a data source. A user named User1 plans to create a report by using the same data source as Report1.
You need to simplify the connection to the data source for User1.
Which type of file should you create?
-
You are using Power Query Editor to preview the data in a column named Max Temp. The column statistics and value distribution are shown in the following exhibit.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.
You have a Power BI model that contains a table named Sales. The Sales table contains the following columns:
• Order Line ID
• Product ID
• Unit Price
• Order ID
• Quantity
Orders are uniquely identified by using the order ID and can have multiple order lines Each order line within an order contains a different product ID.
You need to write a DAX measure that counts the number of orders.
Which formula should you use?
You plan to embed multiple visualization in a public website.
Your Power BI infrastructure contains the visualizations configured as shown in the following table.
Which two visualizations can you embed into the website? Each correct answer presents a complete the solution.
NOTE: Each correct selection is worth one point.
From Power Query Editor, you attempt to execute a query and receive the following error message.
Datasource.Error: could not find file.
What are two possible causes of the error? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
You need to configure access for the sales department users. The solution must me meet the security requirements. What should you do?
