PL-300 Model the data Practice Test 8 — 15 Questions

Question 1

Refer to the exhibit. You apply the row-level security (RLS) policy shown to the Sales table. Which rows will be visible to users?

Accepted Answer

Only rows where Amount > 1000. Option B is correct because the filter only includes rows where Amount > 1000. Option A is wrong because it includes all rows. Option C is wrong because it includes less. Option D is wrong because it excludes the condition.

Answer

Rows where Amount is not blank

Answer

All rows in the Sales table

Answer

Only rows where Amount <= 1000

Question 2

Refer to the exhibit. What is the result of this DAX expression?

Accepted Answer

Sum of Amount only for the West region. The DAX expression uses the CALCULATE function to modify the filter context, applying a filter that restricts the calculation to only the 'West' region. The ALL function is not used to remove filters, so the expression returns the sum of Amount exclusively for the West region, not for all regions or other regions.

Answer

Sum of Amount for all regions except West

Answer

Sum of Amount for regions other than West

Answer

Sum of Amount for all regions

Question 3

Refer to the exhibit. You write this Power Query M code to import data. What does the final step do?

Accepted Answer

Filters rows where Amount > 100. The final step in the Power Query M code filters the table to keep only rows where the 'Amount' column value is greater than 100. This is achieved by the `Table.SelectRows` function with the condition `each [Amount] > 100`, which evaluates each row and retains those meeting the predicate. The result is a reduced dataset containing only transactions with an Amount exceeding 100.

Answer

Sorts rows by Amount descending

Answer

Groups rows by Amount

Answer

Removes the Amount column

Question 4

A data model contains a Date table and a Sales table. You need to create a measure that calculates total sales for the previous year. Which DAX function should you use?

Accepted Answer

SAMEPERIODLASTYEAR. Option B is correct because SAMEPERIODLASTYEAR returns a set of dates shifted back one year. Option A (DATEADD) can also be used but is more general. Option C (PREVIOUSYEAR) is not a valid DAX function. Option D (PARALLELPERIOD) returns a parallel period but not necessarily the previous year.

Answer

DATEADD

Answer

PARALLELPERIOD

Answer

PREVIOUSYEAR

Question 5

You have a Power BI data model with a fact table and multiple dimension tables. You notice that many-to-many relationships cause ambiguous results. What is the best practice to resolve this?

Accepted Answer

Add a bridge table with appropriate relationships. Option C is correct because introducing a bridge table with a many-to-one relationship to both sides resolves many-to-many ambiguity. Option A changes cardinality but loses data. Option B could cause ambiguity. Option D is not applicable because a calculated table does not fix relationships.

Answer

Change the relationship to one-to-one

Answer

Use a bidirectional cross-filter direction

Answer

Create a calculated table to merge the dimensions

Question 6

You are designing a star schema for a sales analysis report. The source data includes Order Details, Products, Customers, and Dates. Which table should be the fact table?

Accepted Answer

Order Details. Option A is correct because Order Details contains transactional measures (quantity, price) and foreign keys to dimensions. Option B (Products) is a dimension. Option C (Customers) is a dimension. Option D (Dates) is a dimension.

Answer

Dates

Answer

Customers

Answer

Products

Question 7

You need to create a calculated column that categorizes sales amounts into 'Low', 'Medium', and 'High' based on thresholds. Which DAX function should you use?

Accepted Answer

SWITCH. Option B is correct because SWITCH can evaluate multiple conditions. Option A (IF) can also work but becomes nested. Option C (LOOKUPVALUE) is for looking up values. Option D (CALCULATE) modifies filter context.

Answer

LOOKUPVALUE

Answer

CALCULATE

Answer

IF

Question 8

You have a data model with a Sales table and a Date table. You create a measure: Total Sales = SUM(Sales[Amount]). When you add a slicer for Date[Year], the measure does not filter correctly. What is the most likely cause?

Accepted Answer

The relationship is inactive. Option D is correct because if the relationship is inactive, filters from the Date table won't propagate. Option A would cause a different error. Option B would give incorrect values. Option C is not a typical issue.

Answer

The Date table is not marked as a date table

Answer

The Sales table has no relationship to the Date table

Answer

The measure uses SUM instead of SUMX

Question 9

You are designing a Power BI data model for a retail chain. You have three fact tables: Sales, Inventory, and Returns. Which modeling approach is best for cross-filtering between these facts?

Accepted Answer

Use role-playing dimensions. Option B is correct because role-playing dimensions allow sharing common dimensions like Date, Product, Store. Option A causes ambiguity. Option C is not a standard approach. Option D is unnecessary if dimensions are shared.

Answer

Use calculated columns to link facts

Answer

Merge all fact tables into one

Answer

Create separate dimensions for each fact table

Question 10

You need to create a hierarchy in Power BI that allows drilling down from Year to Quarter to Month. What is the correct approach?

Accepted Answer

Create a hierarchy in the Date table using Year, Quarter, Month columns. Option C is correct because creating a hierarchy in the Date table using these columns enables drill-down. Option A does not create a hierarchy. Option B is a DAX function. Option D is not a hierarchy.

Answer

Create separate measures for each level

Answer

Use the Drillthrough feature

Answer

Use the DATESYTD function

Question 11

You have a Power BI data model with a table that contains duplicate rows. You want to remove duplicates in Power Query. Which transformation should you use?

Accepted Answer

Remove Duplicates. Option C is correct because 'Remove Duplicates' removes duplicate rows based on selected columns. Option A filters rows. Option B groups rows. Option D replaces values.

Answer

Replace Values

Answer

Filter Rows

Answer

Group By

Question 12

You have the DAX expression shown. What does this expression return?

Accepted Answer

Total sales for the year of the latest date in the current filter context. The DAX expression uses CALCULATE to modify the filter context for 'Sales[Amount]' by applying a filter that selects only dates where the year equals the year of the latest date present in the current filter context. The MAX function returns the maximum date from the Date table within the current filter context, and YEAR extracts its year. This effectively returns total sales for the year containing the most recent date in the current filter context, not necessarily the previous year or the absolute maximum year in the Date table.

Answer

Total sales for the previous year

Answer

Total sales for the maximum year in the Date table

Answer

Total sales for the current year

Question 13

Which TWO of the following are valid DAX functions for time intelligence? (Select two.)

Accepted Answer

DATEADD. DATEADD is a valid DAX time intelligence function that shifts dates forward or backward by a specified number of intervals (days, months, quarters, years). TOTALYTD is also a valid time intelligence function that calculates the year-to-date value of an expression. Both are part of the dedicated time intelligence function set in DAX, which requires a properly marked date table with continuous dates.

Answer

RANKX

Answer

CONCATENATEX

Answer

MINX

Question 14

Which THREE of the following are benefits of using a star schema in Power BI? (Select three.)

Accepted Answer

Simplified DAX formulas. Option A is correct because star schemas reduce the number of table joins and filter context complexity, which simplifies DAX formulas. Measures and calculated columns in Power BI rely on unambiguous relationships; a star schema ensures each fact table connects to dimension tables via one-to-many relationships, allowing DAX to propagate filters automatically without complex cross-filtering logic.

Answer

Supports many-to-many relationships natively

Answer

Increased data redundancy

Question 15

Which TWO of the following are valid methods to handle slowly changing dimensions (SCD) Type 2 in Power Query? (Select two.)

Accepted Answer

Use a lookup table that tracks changes with start and end dates. Options A and D are correct. Power Query can implement SCD Type 2 by adding a row for each change with effective dates, or by using a lookup approach with start and end dates. Option B is not a standard method. Option C is SCD Type 1. Option E merges tables but not Type 2.

Answer

Merge the dimension table with a fact table

Answer

Update the existing row with new attributes

Answer

Overwrite the existing attributes

PL-300 Model the data Practice Test 8 — 15 Questions

Exhibit

PL-300 Model the data Practice Test 8 — 15 Questions

Exhibit