PL-300 Exam Questions

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

You use Power Query to import two tables named Order Header and Order Details from an Azure SQL database. The Order Header table relates to the Order Details table by using a colum...

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

In Power Query Editor, you have a query named Sales Data that contains the following columns. You need to create two queries named Product Dimension and Sales Fact based on the Sal...

You have a Power BI model that contains a table named Date. The Date table contains the following columns: - Date - Fiscal Year - Fiscal Quarter - Month Name - Calendar Year - Week...

You use Power Query Editor to import and preview sales data from the years 2020 and 2021 in a Microsoft Excel file as shown in the following exhibit. You need to shape the query to...

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 that contains the following data. The Date table relates to the Sales table by using the Date columns. The model contains the following DAX measure. Total...

You have a Microsoft Power BI 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 a Power BI model that contains two tables named Population and Date. The Population table contains two columns named PopulationAmount and DateKey. DateKey contains date va...

You publish a dataset to the Power BI service. The dataset contains a connection to an on- premises Microsoft SQL Server database. You attempt to configure a scheduled refresh but...

You have a PBIX file that imports data from a Microsoft Excel data source stored in a file share on a local network. You are notified that the Excel data source was moved to a new...

You are reviewing a Power BI data model. You have a calculated table that has the following definition. ProductList = INTERSECT ( ProductsGroupA, ProductsGroupB ) You need to ident...

You have a Power BI data model that contains two tables named Sales and Date. The Sales table contains three measures named Order Quantity, Product Cost, and Sales Amount. You need...

You have a Power BI model that contains a table named Employees. The table contains the following columns: - Employee ID - First Name - Last Name - Department - Salary Each employe...

You use Power Query Editor to preview a query that contains sales order data in the following columns: - Tax Amount - Sales Order ID - Freight Amount - Subtotal Amount - Total Item...

You have a Power BI dataset that contains quarterly sales performance data. You need to enable managers to review the data in a format that meets the following requirements: - Is o...

You have a Power BI report that contains the visuals shown in the following table. You need to modify the location of each visual. What should you modify for each visual?

You have a Power BI report. The report contains a line chart that displays sales data for several regions. You need to add an element to the report that will enable users to filter...

You have the CSV file shown in the following table. You use Power Query Editor to preview the data in the file. You need to transform the data to meet the following requirements: -...

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 plan to use Power BI Desktop to create a bug tracking dashboard that will pull data from Analytics in Azure DevOps. From Power BI Desktop, you need to configure a data connecto...

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 a Microsoft Excel file in a Microsoft OneDrive folder. The file must be imported to a Power BI semantic model. You need to ensure that the semantic model can be refreshed...

You use Power Query Editor to preview a column named Date as shown in the following exhibit. You need to change the Date column to contain only the year. The solution must minimize...

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 semantic model that contains item, price, and country data. The data is displayed in a report that uses filters. You need to calculate the average item price fo...

You have a Power BI semantic model that contains four queries named Query 1, Query2. Query3, and Query4. Query1 loads customer data into the model and is referenced by the other th...

You have a Power BI semantic model that connects to a streaming data source. The data source is updated frequently. You need to create a Power BI report that meets the following re...

You create a Power BI report named Summary1. You discover that Summary1 is slow. You run Performance analyzer to identify performance metrics for Summary1. Which two metrics displa...

You have a Microsoft 365 subscription that contains the resources shown in the following table. You create a new dashboard that uses row-level security (RLS) filters. You define a...

You have a Power BI model that contains two tables named Sales and Date. The Sales table relates to the Date table by using a many-to-one relationship. The Sales table contains the...

You publish a semantic model to the Power BI service. The semantic model contains data from the following data sources: - Source1: A Microsoft Excel file stored in Microsoft OneDri...

You have a Power BI semantic model that contains two queries. You discover that a report based on the model has performance issues. You plan to use Power Query to reduce the data l...

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 are configuring a Power BI report for accessibility as shown in the following table. You need to change the default colors of all three visuals to make the report more accessib...

You need to use Power BI to create a visual that will allow users to compare the sales performance of five sales regions for the current month. Which visual should you use?

You have a Power BI report that contains the table shown in the following exhibit. The table contains conditional formatting that shows which stores are above, near, or below the m...

You have a Power BI report that contains one visual. You need to provide users with the ability to change the visual type without affecting the view for other users. What should yo...

You have a Power BI report that contains a card. The card displays the value for year-to-date revenue. You need to ensure that screen reader users can read the value when initially...

You have a Power BI report that contains a table visual. The visual contains a column. The column contains whole numbers ranging from of 1 to 20. You need to use conditional format...

You have a Power BI report that contains the visual shown in the following exhibit. You need to make the visual more accessible to users who have color vision deficiency. What shou...

You have a Power BI app that contains a report named Report1. You add a new page to Report1. You need to ensure that users can view the new page. The solution must minimize adminis...

You use Power BI Desktop to import two tables named Customer and Contacts. The Customer table contains the following columns: - Customer_Name - Customer ID - Website The Contacts t...