CertBlaze

Microsoft

PL-300 Free Practice Questions — Page 3

Question 11

You are creating a dashboard by using the Power BI service. You have an existing report page that contains three charts. You need to add the charts to the dashboard while maintaining the interactivity between the charts. What should you do?

A. Edit interactions in the report and set all interactions to Filter.
B. Pin each chart as a tile.
C. Edit the dashboard theme and pin each chart as a tile.
D. Pin the report page as a live tile.
Show Answer
Correct Answer: D
Explanation:
To preserve cross-visual interactivity, pin the entire report page as a live tile. Individually pinned visuals become dashboard tiles and do not maintain the report's cross-filtering and cross-highlighting behavior. A live report page tile retains the report's interactive experience within the dashboard.

Question 11

You have a semantic model that uses a live connection to a semantic model in the Power BI service. You need to create a Power BI report named RPT1 that only uses the live connection. Which three components can you add to RPT1? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

A. a report measure
B. a calculated column
C. a calculated table
D. a new column
E. a new table
Show Answer
Correct Answer: A
Explanation:
With a live connection to a Power BI semantic model, the report cannot modify the underlying model by adding tables or columns. Calculated columns, calculated tables, new columns, and new tables are not supported. You can create report measures, which are stored with the report rather than the connected semantic model.

Question 12

HOTSPOT - You have a Power BI report with the Edit relationship page open as 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 12 Illustration for PL-300 question 12
Show Answer
Correct Answer: not be filtered a BLANK
Explanation:
The relationship is one-to-many (Table2 is the one side, Table1 the many side) with single cross-filter direction, so filters flow from Table2 to Table1 only if the arrow is from one to many? In Power BI, single direction flows from the one side to the many side. Here Table2 contains unique codes (LU, SP) while Table1 has an unmatched SM. Filtering Table2 does not include unmatched values, and when combining fields from both tables, the unmatched SM row shows a blank value from Table2.

Question 13

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 access the tax record information. To what should you set Privacy Level for the data source?

A. None
B. Organizational
C. Private
D. Public
Show Answer
Correct Answer: C
Explanation:
Set the data source Privacy Level to Private. In Power Query, a Private source is isolated from other data sources to prevent data from being shared or leaked during query evaluation, merges, or query folding. This is the appropriate setting for sensitive tax records.

Question 14

HOTSPOT - You have a Power BI semantic model that contains the following table named Employees. An employee is considered active if the TermDate column for that employee contains no value. You need to create a DAX measure that will count the number of active employees. 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.

Illustration for PL-300 question 14 Illustration for PL-300 question 14
Show Answer
Correct Answer: CALCULATE ISBLANK
Explanation:
Use CALCULATE to modify the filter context and count only rows where Employees[TermDate] is blank. ISBLANK identifies active employees because a blank TermDate means they have not been terminated.

Question 15

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?

A. Type 2 slowly changing dimension (SCD)
B. junk dimension
C. role-playing dimension
D. degenerate dimension
Show Answer
Correct Answer: C
Explanation:
A role-playing dimension is a single dimension table related to the same fact table multiple times, with each relationship representing a different business role (for example, home address and mailing address). In Power BI, one relationship is typically active and the others inactive, activated in measures with USERELATIONSHIP when needed. This matches the described Dim Address scenario.

Question 16

HOTSPOT - You have a Power BI semantic model that contains the following tables. All the tables use the same data source. You need to reduce the number of limited relationships in the model by changing the storage mode of certain tables. The solution must NOT affect the latency of the data. Which storage mode should you select for the Customer and Geography tables? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Illustration for PL-300 question 16 Illustration for PL-300 question 16
Show Answer
Correct Answer: Customer: Dual Geography: Dual
Explanation:
Dual storage mode for shared dimension tables allows them to act as Import with imported tables and DirectQuery with DirectQuery tables, reducing limited relationships while preserving DirectQuery latency for real-time data.

Question 17

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?

A. Split the Classes column into rows by using a delimiter.
B. Unpivot the Classes column.
C. Extract the text between delimiters in the Classes column.
D. Convert the Classes column into a list.
Show Answer
Correct Answer: A
Explanation:
To normalize a column that contains multiple delimited values into separate records, use Split Column by Delimiter and choose the option to split into rows. This creates one row per class while duplicating the other column values as needed. Unpivot is for converting multiple columns into attribute-value pairs, extracting between delimiters returns only part of the text, and converting to a list does not produce the required tabular row expansion.

Question 18

HOTSPOT - You have a semantic model named Model1 that contains the following tables. There is an active relationship between SaleDate and Date. There is an inactive relationship between ShippingDate and Date. You need to create a new measure that will display the total amount of sales and support slicing by ShippingDate. 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.

Illustration for PL-300 question 18 Illustration for PL-300 question 18
Show Answer
Correct Answer: CALCULATE USERELATIONSHIP
Explanation:
Use CALCULATE to modify the filter context and USERELATIONSHIP(Sales[ShippingDate], DateTime[Date]) to temporarily activate the inactive ShippingDate relationship so the measure slices by ShippingDate.

Question 19

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 recorded by employees, and each expense has a unique expense ID. You need to create a DAX measure that will calculate the total amount of expenses. Which DAX expression should you use?

A. Sum(‘Expenses’[Amount])
B. Max(‘Expenses’[Amount])
C. Sum(‘Expenses’[Expense ID])
D. Count(‘Expenses’[Amount])
Show Answer
Correct Answer: A
Explanation:
To calculate the total amount of expenses, use SUM over the Amount column. MAX returns only the largest expense, SUM of Expense ID adds identifier values rather than expense amounts, and COUNT of Amount counts rows with nonblank amounts rather than totaling them.

$19

Get all 369 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 →