Microsoft PL-300 Online Practice Questions and Exam Preparation

Microsoft PL-300 Online Questions & Answers

• Question 311:

  Remove unused columns from tables in the data model. This will reduce the size of your PBIX file and make your data model more efficient. You can use Power Query Editor to remove any columns that are not used in your report or calculations.

  

  You need to shape the query to display the following three columns:

  1. Month

  2. Sales

  3. Year

  What should you select in Power Query Editor?

  A. Pivot column
  B. Merge columns
  C. Unpivot columns
  D. Transpose
  C. Unpivot columns

  ---

  Explanation

  This will convert your column headers (Jan-20, Feb-20,...) into row values under a new column called Attribute. You can then rename this column as Month and change its data type to Date. You will also have a new column called Value that contains the sales amounts for each month. You can rename this column as Sales and change its data type to Decimal Number.

• Question 312:

  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:

  1. Customer ID

  2. CustomerName

  3. Address

  4. City

  5. ProvState

  6. Country

  You need to allow users to drill down by location. The report will display the number of each customer by Country, and drill down to ProvState, and then to City.

  How should you configure the drill down in the bar chart?

  A. In the Value field, add Country. In the Legend field, add ProvState at the top, followed by City.
  B. In the Legend field, add Country. In the Axis field, add ProvState at the top, followed by City.
  C. In the Axis field, add Country at the top, followed by ProvState, and then City.
  D. In the Value field, add Country at the top, followed by ProvState, and then City.
  C. In the Axis field, add Country at the top, followed by ProvState, and then City.

  ---

  Explanation

  https://docs.microsoft.com/en-us/power-bi/guided-learning/visualizations#step-18

  https://docs.microsoft.com/en-us/power-bi/power-bi-visualization-drill-down

• Question 313:

  DRAG DROP

  You have a Power BI data model that analyzes product sales ever time. The data model contains the following tables.

  

  A one-to-many relationship exists between the tables.

  The auto date/time option for the data model is enabled.

  You need to reduce the size of the data model while maintaining the ability to analyze product sales by month and quarter.

  Which two actions should you perform? Each correct answer presents part of the solution.

  NOTE: Each correct answer is worth one point.

  Select and Place:

  

  

  ---

  https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-date-tables

  Marking table as date table will remove built-in connected date tables. As we need only month and quarter, we can reduce Date information in newly created Date table - comparing to built-in date tables our created Date table will be lighter so model size is decreases

• Question 314:

  You need to create the relationship between the product list and the revenue results. The solution must minimize the time it takes to render visuals.

  What should you set as the relationship cardinality?

  A. One to one
  B. Many to many
  C. Many to one
  D. One to many
  D. One to many

  ---

  Explanation

  One product in the product list can occur many times in the revenue results.

  Note 1: One to many (1:*): In a one-to-many relationship, the column in one table has only one instance of a particular value, and the other related table can have more than one instance of a value.

  Note 2:

  Revenue data is provided at the date and product level.

  The board must be able to get the following information from the quarterly reports:

  Revenue trends over time - The percent of total revenue contributed by each product category

  A comparison of quarterly revenue versus the same quarter from the previous year

  https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-create-and-manage-relationships

• Question 315:

  You have a Power BI semantic model named Model1 that contains two table named DimDate and FactSales. There is an active relationship between DimDate and FactSales. DimDate is marked as the date table. FactSales contains the following data.

  

  Model1 contains the following measure:

  Previous Year Sales = calculate{[Sales Amount], PREVIOUSYEAR('Date'[Date])}

  You have a report that uses Model1. The report has a single report page that has a page level filter set to may 9, 2024.

  The result of the Previous Year measure is displayed in a card visual.

  Which value appear in the card visual?

  A. 10
  B. 15
  C. 35
  D. 60
  B. 15

• Question 316:

  HOTSPOT

  You have a Power BI semantic model that contains a table named Item. The Item table contains a column named Quantity.

  You need to create a DAX query that meets the following requirements:

  1. The rank of items must be calculated according to the values in Quantity.

  2. Ranking must NOT be skipped if two or more items have the same value in Quantity.

  3. If an item is unfiltered, the total of Quantity must display a blank value.

  How should you complete the DAX formula? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  

  

• Question 317:

  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: The column 'Cost' of the table wasn't found.

  What is a possible cause of the error?

  A. The Cost column was renamed in the data source.
  B. The privacy level of the data source does not allow combining the data with other data sources.
  C. The data in the Cost column cannot be converted into the target data type.
  D. The source file was moved to a new location.
  A. The Cost column was renamed in the data source.

• Question 318:

  HOTSPOT

  You have the Power Bl data model shown in the following exhibit.

  

  You need to create a measure to count the number of product categories that had products sold during a selected period.

  How should you complete the DAX expression? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  

  

• Question 319:

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

  What should you configure?

  A. a scheduled refresh
  B. an incremental refresh
  C. a Microsoft Power Automate flow
  D. an on-premises data gateway
  A. a scheduled refresh

• Question 320:

  You have a semantic mortal that is used infrequently and refreshes every hour.

  You receive a notification that the refresh was disabled due to inactivity.

  Which two actions will cause the scheduled refresh schedule to resume?

  NOTE: Each selection is worth one point.

  A. From the Power B1 service, open a report that uses the semantic model.
  B. From the Power B1 service, open a dashboard that uses the semantic model.
  C. Enable query caching for the semantic model.
  D. Import the semantic model to Microsoft Excel.
  E. From PowerShell. run the get-powarblreport cmdlet.
  A. From the Power B1 service, open a report that uses the semantic model.
  B. From the Power B1 service, open a dashboard that uses the semantic model.