CertBlaze

Microsoft

PL-300 Free Practice Questions — Page 14

Question 140

HOTSPOT - You have a Power BI report that contains a page. The page contains the following visuals: • A card • A matrix • A bar chart You need to configure the page to ensure that the card and the bar chart are unaffected when a user drills down in the matrix. The card and the bar chart must change when a user selects a cell in the matrix. What should you configure? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Illustration for PL-300 question 140
Show Answer
Correct Answer: Matrix Edit Interactions to Filter
Explanation:
Configure the matrix as the source visual and set its interactions to Filter so that selecting a matrix cell updates the card and bar chart, while drill-down actions in the matrix do not affect other visuals.

Question 141

HOTSPOT - You are creating a Power BI model to analyze inventory. You load data into three tables named Date, Product, and Inventory. The Inventory table relates to the Date and Product tables by using one-to-many relationships. Inventory data is recorded daily with no exceptions. The correct inventory quantity for a given product in a month is the last recorded value for that month. You need to write a DAX measure that will show the correct inventory value when a user analyzes inventory by year, month, or date. How should you complete the measure? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Illustration for PL-300 question 141
Show Answer
Correct Answer: CALCULATE LASTDATE
Explanation:
Use CALCULATE to change the filter context and evaluate the measure at a specific date. LASTDATE('Date'[Date]) returns the last date in the current context (day, month, or year). Since inventory is recorded daily without gaps and the Date table is related to Inventory, this correctly returns the last recorded inventory value for each period.

Question 142

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 display the following three columns: • Month • Sales • Year What should you select in Power Query Editor?

A. Merge columns
B. Transpose
C. Unpivot columns
D. Pivot column
Show Answer
Correct Answer: C
Explanation:
The data has separate columns for each year (e.g., 2020 and 2021) with sales values. To reshape it into three columns—Month, Sales, and Year—you must convert those year columns into rows. In Power Query, this is done by selecting the year columns and choosing **Unpivot columns**, which creates a Year (attribute) column and a Sales (value) column. The other options either combine columns, swap rows and columns, or do the opposite transformation.

Question 143

HOTSPOT - You have a Power BI model that contains the following data. The Date table relates to the Sales table by using the Date columns. You need to create a calculated table that will contain the following: • A row for each year • A column that contains the total sales per year How should you complete the DAX calculation? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Illustration for PL-300 question 143 Illustration for PL-300 question 143
Show Answer
Correct Answer: SUMMARIZE Date[Year]
Explanation:
Use SUMMARIZE to group rows, and group by Date[Year] to ensure one row per year. The relationship between Date and Sales allows SUM(Sales[Sale]) to aggregate total sales for each year.

Question 144

HOTSPOT - You are using Power Query Editor to preview the data in a column named Max Temp. The column statistics and value distribution are shown in the following exhibit. Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point.

Illustration for PL-300 question 144 Illustration for PL-300 question 144
Show Answer
Correct Answer: 45 24
Explanation:
The value distribution chart shows 45 with the tallest bar, indicating the highest frequency. The column statistics list Min = 24, which is the smallest non-NULL value.

Question 145

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 Sales Data query. The solution must minimize maintenance effort and the size of the dataset. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

A. Reference the Sales Data query to create the new queries.
B. Disable the load for the Sales Fact query.
C. Duplicate the Sales Data query to create the new queries.
D. Clear Include in report refresh for the Sales Data query.
E. Disable the load for the Sales Data query.
Show Answer
Correct Answer: A, E
Explanation:
Referencing the Sales Data query creates Product Dimension and Sales Fact queries that inherit all transformations from a single source, minimizing maintenance because changes are made once and flow through automatically. Disabling the load for the Sales Data query treats it as a staging query only, preventing it from being loaded into the model and thereby reducing dataset size while keeping the derived dimension and fact tables loaded.

Question 146

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 Number • Month Number • Calendar Quarter You need to create a calculated table based on the Date table. The calculated table must contain only unique combinations of values for Calendar Year, Calendar Quarter, and Calendar Month. Which DAX function should you include in the table definition?

A. ADDCOLUMNS
B. CALCULATE
C. SUMMARIZE
D. DATATABLE
Show Answer
Correct Answer: C
Explanation:
The requirement is to create a calculated table that contains only unique combinations of Calendar Year, Calendar Quarter, and Calendar Month from the Date table. The DAX function designed to group data and return unique combinations of specified columns is SUMMARIZE. ADDCOLUMNS only adds calculated columns to an existing table expression, CALCULATE modifies filter context for expressions, and DATATABLE creates a static, hard-coded table. Therefore, SUMMARIZE is the correct choice.

Question 147

You have data in a Microsoft Excel worksheet as shown in the following table. You need to use Power Query to clean and transform the dataset. The solution must meet the following requirements: • If the discount column returns an error, a discount of 0.05 must be used. • All the rows of data must be maintained. • Administrative effort must be minimized. What should you do in Power Query Editor?

A. Select Replace Errors.
B. Edit the query in the Query Errors group.
C. Select Remove Errors.
D. Select Keep Errors.
Show Answer
Correct Answer: A
Explanation:
The requirement is to replace any error in the Discount column with a value of 0.05 while keeping all rows and minimizing effort. In Power Query, **Replace Errors** directly substitutes error values in a column with a specified value. Removing or keeping errors would affect rows, and editing queries manually increases administrative effort.

Question 148

From Power Query Editor, you attempt to execute a query and receive the following error message. Datasource.Error: Could not find file. What are two possible causes of the error? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

A. You do not have permissions to the file.
B. An incorrect privacy level was used for the data source.
C. The file is locked.
D. The referenced file was moved to a new location.
Show Answer
Correct Answer: A, D
Explanation:
The error "Datasource.Error: Could not find file" occurs when Power Query cannot resolve the file path at execution time. A. You do not have permissions to the file – If you lack read permissions, the file is effectively inaccessible, and Power Query can surface this as a 'could not find file' error. D. The referenced file was moved to a new location – If the file path stored in the query no longer matches the file’s actual location, Power Query cannot locate it and raises this error. Other options produce different errors: incorrect privacy levels cause Formula.Firewall errors, and locked files usually generate 'file in use' or 'cannot access the file' messages.

Question 149

You need to create a visual that compares profit across 10 product categories fora selected quarter. What is the best visual to use to achieve the goal?

A. an area chart
B. a funnel chart
C. a clustered bar chart
D. a line chart
Show Answer
Correct Answer: C
Explanation:
To compare profit across multiple discrete categories (10 product categories) for a single time period (one quarter), a clustered bar chart is most effective. It clearly shows side-by-side comparisons between categories, making differences in profit easy to see. Area and line charts are better for trends over time, and a funnel chart is for staged processes, not category comparison.

$19

Get all 356 questions with detailed answers and explanations

  • Instant download HTML + PDF delivered the moment payment clears.
  • Secure Stripe checkout we never see or store your card details.
  • 7-day refund if files are defective see our refund policy.

Full PL-300 study guide →