PL-300 Visualize and analyze the data Practice Test 2 — 15 Questions

Question 1

A Power BI admin applies the Azure Policy shown in the exhibit. What is the effect of this policy?

Accepted Answer

Only users in the finance workspace can read datasets. The Azure Policy in the exhibit is configured to deny the 'Read' permission on datasets for all users except those in the 'finance' workspace. This means only users who are members of the finance workspace can read datasets, while all other users are denied read access. Therefore, option D is correct because it accurately describes that only users in the finance workspace can read datasets.

Answer

No one can read any datasets

Answer

Users cannot read datasets in the finance workspace

Answer

All users can read datasets in all workspaces

Question 2

A sales manager wants to create a report that shows year-over-year growth for each product category. They have a date table and a sales table with daily sales. Which DAX measure should they use to calculate the previous year's sales?

Accepted Answer

Sales PY = CALCULATE(SUM(Sales[Amount]), SAMEPERIODLASTYEAR(Date[Date])). Option C is correct because SAMEPERIODLASTYEAR is the most straightforward and reliable DAX function for calculating the previous year's sales when you have a proper date table. It automatically shifts the current filter context back by one year, ensuring that the measure returns the exact same period (e.g., same month and day range) from the prior year, which is ideal for year-over-year growth calculations.

Answer

Sales PY = CALCULATE(SUM(Sales[Amount]), DATEADD(Date[Date], -1, YEAR))

Answer

Sales PY = CALCULATE(SUM(Sales[Amount]), PARALLELPERIOD(Date[Date], -1, YEAR))

Answer

Sales PY = CALCULATE(SUM(Sales[Amount]), PREVIOUSYEAR(Date[Date]))

Question 3

A Power BI report shows a bar chart with sales by region. When users click on a region, they expect a line chart on the same page to filter to that region's sales over time. However, the line chart does not respond to the click. What is the most likely cause?

Accepted Answer

The interaction between the bar chart and line chart is set to 'None'.. Option A is correct because in Power BI, visual interactions control how one visual affects another when clicked. By default, cross-filtering and cross-highlighting are enabled, but if the interaction between the bar chart and line chart is explicitly set to 'None', clicking a region on the bar chart will not filter or highlight the line chart. This is the most common cause when a visual fails to respond to clicks on another visual.

Answer

The line chart uses a continuous axis that cannot be filtered.

Answer

The bar chart is not set as a slicer.

Answer

The line chart has a legend with too many items.

Question 4

A company has a dataset with a table 'Orders' containing columns: OrderDate, CustomerID, Amount. They want to create a visual that shows the total amount per month. Which of the following is the best approach?

Accepted Answer

Create a line chart with OrderDate on the axis and use the date hierarchy to drill down to month.. Option B is correct because it leverages Power BI's built-in date hierarchy, which automatically groups OrderDate by year, quarter, month, and day. By placing OrderDate on the axis of a line chart and drilling down to the month level, you get an accurate monthly aggregation of Amount without needing any manual data transformation or calculated columns. This approach is efficient, maintains the underlying data model's integrity, and allows for easy drill-up/drill-down navigation.

Answer

Create a pie chart with OrderDate as the legend.

Answer

Create a table visual with OrderDate and Amount, then group by month in the visual.

Answer

Create a bar chart with a calculated column 'Month' extracted from OrderDate and use that as the axis.

Question 5

Which TWO of the following are valid ways to create a measure in Power BI?

Accepted Answer

From the Modeling tab, click New Measure.. Option A is correct because the Modeling tab in Power BI Desktop provides a dedicated 'New Measure' button that allows users to create calculated measures using DAX (Data Analysis Expressions). This is the primary and most direct method for adding measures to your data model, enabling dynamic aggregations and calculations that are not stored in the table but computed at query time.

Answer

From the Format pane, add a measure.

Answer

From Power Query Editor, add a custom column.

Answer

From the Visualizations pane, click New Measure.

Question 6

Which THREE of the following are best practices for designing Power BI reports for mobile devices?

Accepted Answer

Create a separate mobile layout for the report.. Option B is correct because Power BI allows you to create a dedicated mobile layout that is separate from the desktop report layout. This enables you to optimize the visual arrangement, size, and visibility of visuals specifically for smaller screens, ensuring a better user experience on mobile devices.

Answer

Include all pages from the desktop report in the mobile layout.

Answer

Use only responsive visuals that automatically resize.

Question 7

You are a Power BI analyst for a retail company. You have a dataset containing a 'Sales' table with columns: SalesDate, StoreID, ProductID, Quantity, UnitPrice, and Discount. You also have a 'Calendar' table marked as a date table with a continuous date range from 2018 to 2023. You need to create a measure that calculates the running total of sales amount (Quantity * (UnitPrice - Discount)) over the last 12 months, but only for products that have been sold in at least 10 different stores in the current month. The measure should be dynamic based on the current filter context (e.g., month, year). The report will be used by regional managers to monitor product performance. You have already created a base measure: TotalSales = SUMX(Sales, Sales[Quantity] * (Sales[UnitPrice] - Sales[Discount])). Which DAX measure should you create?

Accepted Answer

RunningTotal = CALCULATE([TotalSales], DATESINPERIOD('Calendar'[Date], MAX('Calendar'[Date]), -12, MONTH), FILTER(ALL(Sales[ProductID]), CALCULATE(DISTINCTCOUNT(Sales[StoreID]), DATESMTD('Calendar'[Date])) >= 10)). Option A is correct because it uses CALCULATE with DATESINPERIOD to compute the running total over the last 12 months, and then applies a filter that restricts the calculation to only those products that have been sold in at least 10 distinct stores in the current month (via DATESMTD). The use of ALL(Sales[ProductID]) inside the filter ensures that the product-level filtering is applied over all products, while the inner CALCULATE with DATESMTD evaluates the store count condition within the current month context, making the measure dynamic based on the filter context.

Answer

RunningTotal = CALCULATE([TotalSales], DATESINPERIOD('Calendar'[Date], MAX('Calendar'[Date]), -12, MONTH), VALUES(Sales[ProductID]))

Answer

RunningTotal = CALCULATE([TotalSales], DATESINPERIOD('Calendar'[Date], MAX('Calendar'[Date]), -12, MONTH), ALL('Calendar'))

Answer

RunningTotal = CALCULATE([TotalSales], DATESINPERIOD('Calendar'[Date], MAX('Calendar'[Date]), -12, MONTH), FILTER(ALL(Sales[ProductID]), COUNTROWS(SUMMARIZE(Sales, Sales[StoreID])) >= 10))

Question 8

You are building a report for a logistics company. The dataset includes a 'Shipments' table with columns: ShipmentID, ShipDate, OriginCity, DestinationCity, Weight, Revenue, and Carrier. The company wants to analyze revenue trends by carrier over time. They have a date table marked as a date table. You create a line chart with ShipDate on the axis and Revenue as the value, with Carrier as the legend. However, the line chart shows a single line for each carrier, but the revenue values are aggregated across all dates, showing a constant line. What is the most likely cause?

Accepted Answer

The ShipDate column is of type 'Text' instead of 'Date'.. Option B is correct because if the ShipDate column is stored as text, Power BI cannot treat it as a continuous date hierarchy. Even though a separate date table is marked as a date table, the line chart uses the ShipDate column from the Shipments table. When ShipDate is text, Power BI treats each unique text value as a separate category, and since there is no time intelligence, the revenue is aggregated across all rows for each carrier, resulting in a flat line showing the total revenue for that carrier. The chart does not break down revenue by actual dates, so it appears constant.

Answer

There are missing relationships between Shipments and the date table.

Answer

The Revenue column is a measure that is not summing correctly.

Answer

The date table is marked as a date table but not related to Shipments.

Question 9

You are developing a Power BI report to analyze sales performance. The data model includes a 'Sales' fact table with a 'Date' column and a 'Region' dimension table. You need to create a measure that calculates the total sales amount for the current year compared to the previous year. Which TWO of the following steps are required to implement this calculation correctly?

Accepted Answer

Create a separate date table and mark it as a date table in Power BI.. Option B is correct because a dedicated date table marked as a date table in Power BI is required for time intelligence functions like SAMEPERIODLASTYEAR to work correctly. Time intelligence functions rely on a continuous, contiguous date range with a 'Date' column marked as the date table, ensuring accurate year-over-year comparisons. Without this, the functions may return incorrect or blank results due to gaps or non-standard date hierarchies.

Answer

Use the Quick Measure feature to create a 'Year-over-year change' measure.

Answer

Apply the CALCULATE function to switch between years.

Answer

Ensure the 'Sales' table has a relationship to the 'Date' table with a many-to-many cardinality.

Question 10

You are reviewing a Power Query M script that imports sales data. The script filters orders from 2023, groups by CustomerID to sum SubTotal, sorts descending, and takes the top 10 customers. However, the query fails with an error. What is the most likely cause?

Accepted Answer

The column name 'SubTotal' is misspelled; the correct column name is 'Subtotal'.. Option C is correct because the error is most likely caused by a misspelled column name in the M script. Power Query is case-sensitive for column names, so 'SubTotal' does not match the actual column 'Subtotal', causing a runtime error when the script tries to reference the non-existent column.

Answer

The parameters in Sql.Database are reversed; the correct order is database name first, then server.

Answer

The Table.FirstN function is missing the second argument; it should be Table.FirstN(#"Sorted Rows", 10).

Answer

The #date function cannot be used with a datetime column; use DateTime.From instead.

Question 11

You are a Power BI analyst at a retail company. The company has a Power BI dataset that imports daily sales data from an on-premises SQL Server database. The dataset includes tables: 'Sales' (columns: SaleID, ProductID, SaleDate, Quantity, UnitPrice, CustomerID), 'Products' (ProductID, ProductName, Category), and 'Customers' (CustomerID, CustomerName, Region). The report needs to display a matrix visual showing total sales amount (Quantity * UnitPrice) by Category (rows) and Year (columns). The report currently shows blank values for the matrix. You have verified that relationships exist between the tables and that there is a date table marked as a date table. The measure used is: Total Sales = SUMX(Sales, Sales[Quantity] * Sales[UnitPrice]). When you test the measure in a card visual, it returns a value. However, the matrix shows blanks. What is the most likely cause and solution?

Accepted Answer

Create an active relationship between the date table and the Sales table on the SaleDate column.. The matrix visual shows blanks because the date table is not actively related to the Sales table on the SaleDate column. Even though a date table is marked as a date table, without an active relationship, the filter context from the date table (used for Year in columns) does not propagate to the Sales table, causing the measure to return blanks in the matrix. Creating an active relationship between the date table and Sales[SaleDate] allows the Year filter to correctly filter the Sales rows, enabling the SUMX measure to compute total sales per category per year.

Answer

Use the ALL function in the measure to ignore filter context.

Answer

Modify the measure to use CALCULATE with USERELATIONSHIP to force the relationship.

Answer

Convert the SaleDate column to a date data type using Power Query.

Question 12

Drag and drop the steps to import data from a SQL Server database into Power BI Desktop into the correct order.

Question 13

Drag and drop the steps to configure a scheduled refresh for a dataset in the Power BI service into the correct order.

Question 14

Match each data connectivity mode to its description.

Question 15

Match each DAX function category to an example function.

PL-300 Visualize and analyze the data Practice Test 2 — 15 Questions

Exhibit

PL-300 Visualize and analyze the data Practice Test 2 — 15 Questions

Exhibit