PL-300 V7

You have a Microsoft SharePoint Online site that contains several document libraries. One of the document libraries contains manufacturing reports saved as Microsoft Excel files. All the manufacturing reports have the same data structure. You need to load only the manufacturing reports to a table for analysis. What should you...

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

HOTSPOT You need to create the Top Customers report. Which type of filter should you use, and at which level should you apply the filter? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Box 1: Top N...

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