PL-300 Exam Questions

Case Study 1 - Litware, Inc. Overview Litware, Inc. is an online retailer that uses Microsoft Power Bl dashboards and reports. The company plans to leverage data from Microsoft SQL...

Case Study 1 - Litware, Inc. Overview Litware, Inc. is an online retailer that uses Microsoft Power Bl dashboards and reports. The company plans to leverage data from Microsoft SQL...

Case Study 1 - Litware, Inc. Overview Litware, Inc. is an online retailer that uses Microsoft Power Bl dashboards and reports. The company plans to leverage data from Microsoft SQL...

Case Study 1 - Litware, Inc. Overview Litware, Inc. is an online retailer that uses Microsoft Power Bl dashboards and reports. The company plans to leverage data from Microsoft SQL...

Case Study 1 - Litware, Inc. Overview Litware, Inc. is an online retailer that uses Microsoft Power Bl dashboards and reports. The company plans to leverage data from Microsoft SQL...

Case Study 2 - Contoso Ltd Overview Existing Environment Contoso, Ltd. is a manufacturing company that produces outdoor equipment Contoso has quarterly board meetings for which fin...

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

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

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

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

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

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

You have the visual shown in the Original exhibit. You need to configure the visual as shown in the Modified exhibit. What should you add to the visual?

You plan to create the chart shown in the following exhibit. How should you create the dashed horizontal line denoting the 40th percentile of daily sales for the period shown?

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?

You have a collection of reports for the HR department of your company. You need to create a visualization for the HR department that shows a historic employee counts and predicts...

You have the visual shown in the exhibit. You need to show the relationship between Total Cost and Total Sales over time. What should you do?

You build a report to help the sales team understand its performance and the drivers of sales. The team needs to have a single visualization to identify which factors affect succes...

You have a data model that contains many complex DAX expressions. The expressions contain frequent references to the related and relatedtable functions. You need to recommend a sol...

You have a sales system that contains the tables shown in the following table. The Date table is marked as a date table. DateID is the date data type. You need to create an annual...

You build a report to analyze customer transactions from a database that contains the tables shown in the following table. You import the tables. Which relationship should you use...

You are configuring a Microsoft Power Bl data model to enable users to ask natural language questions by using Q&A. You have a table named Customer that has the following measure....

You have a Microsoft Power Bl report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of powerbi.com. The report uses an import...

You have four sales regions. Each region has multiple sales managers. You implement row-level security (RLS) in a data model. You assign the relevant distribution lists to each rol...

You have five sales regions. Each region is assigned a single salesperson. You have an imported dataset that has a dynamic row-level security (RLS) role named Sales. The Sales role...

You have a collection of reports for the HR department of your company. The datasets use row- level security (RLS). The company has multiple sales regions that each has an HR manag...

Your company plans to completely separate development and production assets such as datasets, reports, and dashboards in Microsoft Power Bl. You need to recommend an application li...

You are creating a visual to show the ranking of product categories by sales revenue. Your company's security policy states that you cannot send data outside of your Microsoft Powe...

You have a Microsoft Power BI dashboard. The report used to create the dashboard uses an imported dataset from a Microsoft SQL Server data source. The dashboard is shown in the exh...

You have a report that contains four pages. Each page contains slicers for the same four fields. Users report that when they select values on a slicer on one page, the visuals are...

You are developing a report page. Some users will navigate the report by using a keyboard, and some users will consume the report by using a screen reader. You need to ensure that...

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

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

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

You have a report that contains three pages. One of the pages contains a KPI visualization. You need to filter all the visualizations in the report except for the KPI visualization...

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

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

You create the following step by using Power Query Editor. = Table.ReplaceValue(SalesLT_Address,"1318","1319",Replacer.ReplaceText,{"AddressLine1"}) A row has a value of 21318 Lasa...

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

You have a query that returns the data shown in the following exhibit. You need to configure the query to display the data as shown in the following exhibit. Which step should you...

You have a Power BI report that contains four pages. All the pages contain a slicer for a field named Country, You need to ensure that when a user selects a county on page 1, the s...

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

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

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

You have a Power BI model for sales data. You create a measure to calculate the year-to-date sales. You need to compare the year-to-date sales with the previous year for the same t...

From the Home tab in Power BI Desktop, you click Enter Data and create a table named Sales that contains the following data. You add Region and Sales to visualization and the visua...

You have a table named Sales. A sample of the data in Sales is shown in the following table. You create a stacked column chart visualization that displays ProductName by Date. You...

You need to create a custom visualization for Power BI. What should you install first?

You have a Power BI report that is configured to use row-level security (RLS). You have the following roles: - A manager role that limits managers to see only the sales data from t...

You are creating a report in Power BI Desktop that has two visualizations on a page as shown in the following exhibit. You need to ensure that when you click the bar of a country,...