PL-300 exam

What should you create to meet the reporting requirements of the sales department?A . a measure that uses a formula of SUM (Sales [sales_id])B . a calculated column that use a formula of COUNTA (sales [sales_id])C . a measure that uses a formula of COUNTROWS (Sales)D . a calculated column...

HOTSPOT You need to create a visual as shown in the following exhibit. The indicator color for Total Sales will be based on % Growth to Last Year. The solution must use the existing calculations only. How should you configure the visual? To answer, select the appropriate options in the...

You import a large dataset to Power Query Editor. You need to identify whether a column contains only unique values. Which two Data Preview options can you use? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one pointA . Show whitespaceB . Column distributionC ....

HOTSPOT How should you distribute the reports to the board? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Box 1: Using a workspace membership Scenario: The company wants to provide a single package of reports to the...

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...

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 . FeedbackB . SubscribeC . CommentsD . Mark as favoriteView AnswerAnswer: C Explanation: https://docs.microsoft.com/en-us/power-bi/consumer/end-user-comment

You have multiple dashboards. You need to ensure that when users browse the available dashboards from powerbi.com. they can see which dashboards contain Personally Identifiable Information (Pll). The solution must minimize configuration effort and impact on the dashboard design. What should you use?A . Active Directory groupsB . tilesC ....

You need to create a calculated column to display the month based on the reporting requirements. Which DAX expression should you use?A . FORMAT('Date'[date], "MMM YYYY")B . FORMAT('Date' [date], "M YY")C . FORMAT('Date'[date_id], "MMM") & "" & FORMAT('Date'[year], "#")D . FORMAT('Date' [date_id], "MMM YYYY")View AnswerAnswer: A

HOTSPOT You have two Azure SQL databases that contain the same tables and columns. For each database, you create a query that retrieves data from a table named Customers. You need to combine the Customer tables into a single table. The solution must minimize the size of the data model...

You have a sales system that contains the tables shown in the following table. The Date table is marked as a date table. DatelD is the date data type. You need to create an annual sales growth percentage measure. Which DAX expression should you use?A . SUM(sales[sales_amount]) - CALCULATE(SUM(sales[sales_amount]), SAMEPERIODLASTYEAR('Date'[DateID])B...