PL-300 Exam Questions

You maintain a Power Bl workspace that contains a supplier quality dashboard. The dashboard contains 10 card visuals, two map visuals and five bar chart visuals. The dashboard mobi...

You have a Power Bl report. You have a table named Dalai that contains 10 million rows. Data is used in the following visuals: - A card that shows the number of records - A bar cha...

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 report. The report contains a visual that snows gross sales by date. The visual has anomaly detection enabled. No anomalies ate detected. You need to increase t...

You are creating a Power BI report to analyze consumer purchasing patterns from a table named Transactions. The Transactions table contains a numeric field named Spend. You need to...

You have a Power B1 report that contains three pages named Page1, Page2, and Page3. All the pages have the same slicers. You need to ensure that all the filters applied to Page1 ap...

You have a Power Bl workspace named Inventory that contains a dataset a report and a dashboard. You need to add an additional tile to the dashboard. The tile must show inventory by...

You have a report that contains a donut chart and a clustered column chart. Interactions between the visuals use the default settings. You need to modify the report so that when yo...

You have a PBiX file that imports several tables from an Azure SQL database. The data will be migrated to another Azure SQL database. You need to change the connections in the PBIX...

You have a Microsoft Excel file in a Microsoft OneDrive folder. The file must be imported to a Power Bi dataset You need to ensure that the dataset can be refreshed in powefbi.com....

A business intelligence (Bl) developer creates a dataflow in Power Bl that uses DirectQuery to access tables from an on premises Microsoft SQL server. The Enhanced Dataflows Comput...

For the sales department at your company, you publish a Power Bl report that imports data from a Microsoft Excel. We located in a Microsoft SharePoint folder. The data model contai...

You import two Microsoft Excel tables named Customer and Address into Power Query Customer contains the following columns: - Customer ID - Customer Name - Phone - Email Address - A...

You have a CSV file that contains user complaints. The file contains a column named Logged logged contains the date and time each complaint occurred. The data in Logged is m the fo...

You have a Power Bl report for the marketing department. The report reports on web traffic to a blog and contains data from the following tables. There is a one-to-many relationshi...

You have a Power Bi report for the procurement department. The report contains data from the following tables. There is a one-to-many relationship from Suppliers to Lineitems that...

You have a Power Bl query named Sates that imports the columns shown in the following table. Users only use the dale part of the Sales.Date field. Only rows with a Status of Finish...

You are creating a Power BI model that contains a table named Store. Store contains the following fields. You plan to create a map visual that will show store locations and provide...

You are creating a sales report in Power Bl for the NorthWest region sales territory of your company. Data will come from a view in a Microsoft SQL Server database. A sample of the...

From Power BI Desktop, you publish a new dataset and report to a Power BI workspace. The dataset has a row-level security (RLS) role named HR. You need to ensure that the HR team m...

You plan to develop a Power BI report that has a bar chart to display the number of customers by location. You have a table named Customer that has the following columns: - Custome...

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 3 - Northwind Traders Overview. General Overview Northwind Traders is a specialty food import company. The company recently implemented Power BI to better understand its...

Case Study 3 - Northwind Traders Overview. General Overview Northwind Traders is a specialty food import company. The company recently implemented Power BI to better understand its...

Case Study 3 - Northwind Traders Overview. General Overview Northwind Traders is a specialty food import company. The company recently implemented Power BI to better understand its...

You are building a Power Bl report that uses data from an Azure SQL database named erp1. You import the following tables. You need to perform the following analyses: - Orders sold...

You have a Power Bl report hosted on powerbi.com that displays expenses by department for department managers. The report contains a line chart that shows expenses by month. You ne...

You have two Power Bl reports named ReportA and ReportB that each uses a distinct color palette. You are creating a Power Bl dashboard that will include two visuals from each repor...

You need to create a visual that enables the adhoc exploration of data as shown in the following exhibit. Which type of visual should you use?

You are creating a Power Bl report by using Power Bi Desktop. You need to include a visual that shows trends and other useful information automatically. The visual must update base...

You have a Power Bl workspace that contains several reports. You need to provide a user with the ability to create a dashboard that will use the visuals from the reports. What shou...

You have a Power Bl workspace that contains a dataset. a report, and a dashboard. The following groups have access: - External users can access the dashboard. - Managers can access...

You have a report in Power BI named report1 that is based on a shared dataset. You need to minimize the risk of data exfiltration for report. The solution must prevent other report...

You have the Power Bl model shown in the following exhibit. There are four departments in the Departments table. You need to ensure that users can see the data of their respective...

You import a Power Bl dataset that contains the following tables: - Date - Product - Product Inventory The Product inventory table contains 25 million rows. A sample of the data is...

You have more than 100 published datasets. Ten of the datasets were verified to meet your corporate quality standards. You need to ensure that the 10 verified datasets appear at th...

You have a Power Bl workspace named Workspace1 that contains a dataset named DS1 and a report named RPT1. A user wants to create a report by using the data In DS1 and publish the r...

You have a Power Bl report that uses row-level security (RLS). You need to transfer RLS membership maintenance to an Azure network security team. The solution must NOT provide the...

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 the dashboard shown in the following exhibit. You need to modify the dashboard to display as shown in the following exhibit. What should you do?

You build a Power BI report that displays IoT temperature data streaming from a refrigerator. You publish the report to the Power BI service. You need to be notified when the tempe...

You have a BI dataset and a connected report. You need to ensure that users can analyze data in Microsoft Excel by connecting directly to the dataset. You grant the users the Build...

You attempt to connect Power BI Desktop to a Cassandra database. From the Get Data connector list, you discover that there is no specific connector for the Cassandra database. You...

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

You have a Power BI model that contains a table named Employee. The table contains the following data. Each employee has one manager as shown in the ParentEmployeeID column. All re...

You have a Power BI report that contains one page. The page contains two line charts and one bar chart. You need to ensure that users can perform the following tasks for all three...

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 Power BI data model shown in the following exhibit. The Sales table contains records of sales by day from the last five years up until today's date. You plan to create...

You have a Power BI data model that analyzes product sales over time. The data model contains the following tables. A one-to-many relationship exists between the tables. The auto d...