PL-300 Exam Questions

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 named Model1 that runs in Import storage mode. You need to reduce the size of Model1. The solution must NOT increase report query response times....

You have a Power BI semantic model named Model1 that runs in Import storage mode. You need to reduce the size of Model1. Which two actions should you perform? Each correct answer p...

You have a Power BI semantic model that contains a table named Table1. Table1 contains the following columns: - WebsiteName - URL You need to create a report named Report1 that wil...

You have a Power BI semantic model named Model1 that contains two fields named Sales and Quarter. Model1 contains a DAX measure that sums the Sales column. You need to create a rep...

You create a report by using Microsoft Power BI Desktop. The report uses data from a Microsoft SQL Server Analysis Services (SSAS) tabular model located on your company's internal...

You have a Power BI workspace named Workspace1 and a group named Group1. You need to ensure that the members of Group1 are notified when there are issues in Workspace1. The solutio...

You create a Power BI workspace named Workspace1. You publish a semantic model and a report to Workspace1. You need to configure Workspace1 to meet the following requirements: - Pr...

You have a Microsoft Power BI Desktop report named Report1 that uses an Azure SQL database as a data source. A user named User1 plans to create a report by using the same data sour...

You plan to create a Power BI semantic model named Model1 that will contain data from an Azure SQL database named DB1. Model1 must show updated data within two minutes of the data...

You need to create a semantic model in Power BI Desktop. The solution must meet the following requirements: - The model must contain a table named Orders that has one row per order...

You have a Power BI semantic model that contains the following data. You need to create a solution that meets the following requirements: - Presents transaction amount totals for e...

You have a Power BI semantic model named Model1 that contains two tables named DimDate and FactSales. There is an active relationship between DimDate and FactSales. DimDate is mark...

You have a Power BI query named Expenses that imports the following data. Users only use the date portion of the TransactionDate value when performing data analysis. You need to mi...

You have a Power BI report that contains a bar chart. The bar chart displays sales by country. You need to ensure that a summary of the data shown on the bar chart is accessible by...

You have a Power BI semantic model named Model1 that contains sales data. You need to ensure that Model1 is refreshed on the first day of each month to include last month's sales d...

You are creating a new semantic model in Microsoft Power BI Desktop. You connect to a recently used data source and receive an error message indicating that the password is expired...

You use Power BI Desktop to open a PBIX file that contains a Microsoft Excel data source. You attempt to refresh the data and receive the following error message. Expression.Error:...

You have a Power BI tenant that contains a workspace named WS1. WS1 contains the following items: - A semantic model named SM1. - A report named RPT1 that is connected to SM1. - A...

You have a Power BI report named Report1. You plan to share Report1 with multiple users. You need to add the users to a group. Which two types of groups can you use? Each correct a...

You use Power BI Desktop to create a report named RPT1 that loads data from a Microsoft Excel file named File1. File1 is located in a network share. File1 is moved to a different f...

You have a Power BI report named Report that contains the following tables. For the last three days, refresh in Power BI has failed, and you receive the following error message: "Y...

You have a table named DIMCountries that contains a column named Country as shown in the following table. You plan to use DIMCountries as a dimension in a report. You need to ensur...

You have a Power BI semantic model that contains two tables named DimCustomer and FactOrderDetails. The primary key of DimCustomer is CustomerID. FactOrderDetails contains a column...

You have a Power BI model that contains a table named Expenses. The table contains the following columns: - Date - Amount - Category - Expense ID - Employee ID Expenses are recorde...

You have a query in Power Query Editor that contains the following data. You need to transform the data to appear as shown in the following table. What should you do?

You have a Microsoft Fabric eventhouse named Eventhouse1 that contains high-velocity and high-volume data from IoT devices. Eventhouse1 can be queried to deliver data to reports in...

You have a Power BI semantic model that contains the following tables. You need to define a relationship from FactSales to DimProduct. The solution must ensure the fastest DAX quer...

You have a Power BI semantic model that contains a table named Table1. Table1 runs in Import storage mode. You need to update the model to change the storage mode of Table1 to Dire...

You have a Power BI semantic model that has the tables and relationships shown in the following exhibit. Which type of dimension is represented by Dim Address?

You plan to generate a line chart to visualize and compare the last six months of sales data for two departments. You need to increase the accessibility of the visual. What should...

You have a Power BI report. The report contains a single report page that uses the default theme. You need to configure the report page to match the formatting shown in the followi...

You are creating a visual in a Power BI report. The associated semantic model contains sales from the last four years for three products. You need to display the total sales by qua...

You are creating a Power BI report that will contain multiple visuals. You need to ensure that the report is accessible to users who use a screen reader. Which two configurations s...

You have a Power BI report that contains a stacked bar chart. You need to add a new field to the legend. The field must combine information from separate columns. What should you c...

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 plan to create a Power BI report that will be connected to multiple data sources. One of the data sources contains tax records. You need to ensure that other queries cannot acc...

You have a semantic model named Model1. You need to ensure that users can verify that the data in Model1 meets corporate standards. What should you do?

You attempt to open a PBIX file in Microsoft Power BI Desktop and receive the following error message in Power Query Editor. DataSource.Error: Could not find file D:\Data.txt. How...