PL-300 exam

You need to configure access for the sales department users. The solution must me meet the security requirements. What should you do?A . Add the sales department as a member of the reports workspace B. Add the Azure Active Directory group of the sales department as an Admin of the...

HOTSPOT You need to create a Power BI report. The first page of the report must contain the following two views: * Sales By Postal Code * Sales by Month Both views must display a slicer to select a value for a field named Chain. The Sales By Postal Code...

HOTSPOT You are profiling data by using Power Query Editor. You have a table named Reports that contains a column named State. The distribution and quality data metrics for the data m State is shown in the following exhibit. Use the drop-down menus to select the answer choice that completes...

You need to design the data model to meet the report requirements. What should you do in Power BI Desktop?A . 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...

HOTSPOT You have a table that contains a column named Phone. The following is a sample of the data in the Phone column. You need to add a new column that contains the data in the format of nnn-nnn-nnnn. How should you complete the Query Editor formula? To answer, select...

HOTSPOT You need to grant access to the business unit analysts. What should you configure? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Box 1: The Viewer role to the workspace The Viewer role gives a read-only...

HOTSPOT You have a Power BI model that has the following tables: ✑ Product (Product_id, Product_Name) ✑ Sales (Order_id, Order_Date, Product_id, Salesperson_id, Sales_Amount) ✑ Salesperson (Salesperson_id, Salesperson_name, address) You plan to create the following measure. Measure1 = DISTINCTCOUNT(Sales[ProductID]) You need to create the following relationships: ✑ Sales to Product ✑...

You have a line chart that shows the number of employees in a department over time. You need to see the total salary costs of the employees when you hover over a data point. What is possible way to achieve this goal?A . Add a salary to the tooltips. B....

You have a Power BI workspace named BI Data that contains a dataset named BI Finance. You have the Build permission for the 81 Finance dataset but you do NOT have permissions for the workspace. You need to connect to BI Finance and create a report. Which actions should you...

You have a report that contains a bar chart and a column chart. The bar chart shows customer count by customer segment. The column chart shows sales by month. You need to ensure that when a segment is selected in the bar chart, you see which portion of the total...