PL-300 exam

You publish a report to a workspace named Customer Services. The report identifies customers that have potential data quality issues that must be investigated by the customer services department of your company. You need to ensure that customer service managers can create task lists in Microsoft Excel based on the...

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

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

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you...

You have a table that contains sales data and approximately 1,000 rows. You need to identify outliers in the table. Which type of visualization should you use?A . area chartB . donut chartC . scatter plotD . pie chartView AnswerAnswer: C Explanation: Outliers are those data points that lie outside...

HOTSPOT You are creating a quick measure as shown in the following exhibit. You need to create a monthly rolling average measure for Sales over time. How should you configure the quick measure calculation? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth...

HOTSPOT You have a folder of monthly transaction extracts. You plan to create a report to analyze the transaction data. You receive the following email message: "Hi. I've put 24 files of monthly transaction data onto the shared drive. File Transactions201901.csv through Transactions201912.csv have the latest set of columns, but...

HOTSPOT Your company has affiliates who help the company acquire customers. You build a report for the affiliate managers at the company to assist them in understanding affiliate performance. The managers request a visual showing the total sales value of the latest 50 transactions for each affiliate. You have a...

You have the visual shown in the exhibit. (Click the Exhibit tab.) You need to show the relationship between Total Cost and Total Sales over time. What should you do?A . Add a play axis.B . Add a slicer for the year.C . From the Analytics pane, add an Average...

You need to create the dataset. Which dataset mode should you use?A . DirectQueryB . ImportC . Live connectionD . CompositeView AnswerAnswer: D Explanation: Composite Model means now you can have a model, that very large tables of that are coming from the DirectQuery connection, without the need for importing,...