PL-300 Practice Test 2 — 10 Questions

Question 1

A company wants to create a Power BI report that shows sales performance by region. The data contains a table 'Sales' with columns: Date, Amount, RegionID, and ProductID. They also have a 'Regions' table with RegionID and RegionName. They want to display a matrix visual with RegionName on rows and Year on columns, with the sum of Amount as values. However, the report displays only 'RegionID' instead of 'RegionName'. What is the most likely cause?

Choose an answer to begin — your selection is scored in the full session.

Accepted Answer

There is no active relationship between the Sales and Regions tables.. If there is no active relationship between the Sales and Regions tables, Power BI cannot use the RegionName from the Regions table to filter or group the Sales data. Instead, it defaults to displaying the RegionID from the Sales table, which is the only related field available in the visual. An active relationship must exist between the two tables on the RegionID columns for RegionName to appear in the matrix.

Answer

The relationship is configured as many-to-many.

Answer

The relationship direction is set to Both.

Answer

The RegionID column in the Sales table is hidden.

Question 2

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 3

You are deploying a Power BI solution to a customer. The customer requires that all report access be controlled via Azure Active Directory (Azure AD) groups. You have a single workspace with multiple reports. What is the best practice for managing permissions?

Accepted Answer

Add an Azure AD group to the workspace role.. Using an Azure AD group to manage workspace roles aligns with the customer's requirement for centralized access control via Azure AD. This approach simplifies permission management by allowing group membership changes in Azure AD to automatically propagate to Power BI workspace access, ensuring consistency and reducing administrative overhead.

Answer

Create a Power BI group and add users to it.

Answer

Assign each user directly to the workspace role.

Answer

Share each report individually with users.

Question 4

You are a data analyst for a global retail company. The company uses Power BI Premium capacity. You are building a dataset that combines sales data from three sources:
1. An Azure SQL Database that stores transactional sales data (10 million rows per day, retained for 5 years).
2. A SharePoint Online folder containing monthly Excel reports from regional offices (each report has a different structure).
3. A Dataverse table that contains customer feedback scores.

Requirements:
- The dataset must support near real-time reporting for the current month's sales (maximum 15-minute latency).
- Historical sales data (older than current month) can be refreshed daily.
- Customer feedback scores should be updated every hour.
- The Excel reports from SharePoint must be combined into a single table with consistent columns.
- The final dataset should be optimized for fast query performance.

You need to design the data preparation strategy. What should you do?

Accepted Answer

Use a composite model: DirectQuery for the current month's sales data from Azure SQL, and Import mode for historical sales (with incremental refresh) and for customer feedback (with hourly refresh). Combine SharePoint files using Power Query and load them into the model using Import mode. Set up a DirectQuery connection for near real-time.. It uses a composite model to meet all requirements: DirectQuery for near real-time current-month sales (≤15-minute latency), Import mode with incremental refresh for historical sales (daily refresh), Import mode for customer feedback (hourly refresh), and Power Query to combine SharePoint Excel files into a consistent table. This approach balances real-time needs with query performance and refresh flexibility, leveraging Power BI Premium's composite model capabilities.

Answer

Use DirectQuery for all data sources and create views in Azure SQL to transform the SharePoint and Dataverse data. Use Power Query to combine SharePoint files in a view.

Answer

Import all data into Power BI using Import mode. Schedule refreshes every 15 minutes for the current month and daily for historical data.

Answer

Use Azure Data Factory to copy all data to Azure SQL Database, then connect Power BI using DirectQuery.

Question 5

You are designing a Power BI data model that includes a table named Sales with 10 million rows. You need to create a relationship between Sales and a Product dimension table. The Product table has 10,000 rows. Which configuration will provide the best query performance?

Accepted Answer

Create a one-to-many relationship from Product to Sales. A one-to-many relationship from Product (the dimension table with unique values) to Sales (the fact table with many rows) is the standard star schema design. This configuration allows Power BI to use the smaller Product table to filter the larger Sales table efficiently, leveraging in-memory columnar storage and automatic aggregations for optimal query performance.

Answer

Create a many-to-one relationship from Sales to Product

Answer

Do not create a relationship; use LOOKUPVALUE in measures

Answer

Create a relationship with cross filter direction set to Both

Question 6

You have a dataset with a column 'FullName' containing values like 'John Doe'. You need to split this column into 'FirstName' and 'LastName' using the space delimiter. Which Power Query transformation should you use?

Accepted Answer

Split Column by Delimiter.. The 'Split Column by Delimiter' transformation in Power Query is specifically designed to divide a single text column into multiple columns based on a specified delimiter, such as a space. In this scenario, selecting the column 'FullName' and using 'Split Column > By Delimiter' with a space delimiter will correctly separate 'John Doe' into 'FirstName' (John) and 'LastName' (Doe). This is the standard approach for parsing delimited text within Power Query.

Answer

Merge Columns.

Answer

Extract Text.

Answer

Replace Values.

Question 7

You are building a Power BI data model from an Azure SQL Database. The source table contains a column 'OrderDate' of type datetime. You want to create a date table in Power Query that includes all dates from the minimum to maximum OrderDate. Which M function should you use to generate the list of dates?

Accepted Answer

List.Dates. `List.Dates` generates a list of sequential dates (type `date`) given a start date, a count of values, and a step duration. In Power Query, when you need a date table covering the range from the minimum to maximum `OrderDate`, you compute the count as `Duration.Days(MaxDate - MinDate) + 1` and use `List.Dates(MinDate, Count, #duration(1,0,0,0))`. This produces a clean list of dates without time components, ideal for a date dimension.

Answer

List.Generate

Answer

List.DateTimes

Answer

List.Range

Question 8

Which THREE settings should you verify in the Power BI tenant admin portal to ensure that external users (guests) can access a published app?

Accepted Answer

Invite external users to your organization via Microsoft Entra ID.. To allow external users (guests) to access a published app in Power BI, three tenant settings must be enabled: 'Invite external users' (A) allows inviting guest users, 'Allow Azure AD external identities to access the Power BI service' (C) enables guest sign-in, and 'Allow sharing with external users' (B) permits sharing content with guests. Option E ('Allow external users to edit and manage content') is not required for viewing an app; it grants additional editing permissions. Option D controls whether guests appear in people pickers, which is unrelated.

Answer

Show external users in lists of suggested people.

Answer

Allow external users to edit and manage content in the organization.

Question 9

You are importing data from a CSV file that contains a column 'OrderDate' with dates in the format 'MM/dd/yyyy'. Some rows have invalid dates like '02/30/2023'. What is the best way to handle these errors in Power Query?

Accepted Answer

Use 'Replace Errors' to replace error values with null.. 'Replace Errors' in Power Query allows you to replace error values (which occur when Power Query fails to convert an invalid date like '02/30/2023' to the Date type) with null. This preserves the rest of the data and keeps the query running without interruption, while clearly marking invalid entries for later handling or analysis.

Answer

Remove rows with errors using 'Remove Rows' > 'Remove Errors'.

Answer

Change the data type to 'Date' and ignore errors.

Answer

Filter the column to exclude rows where the date is invalid after type conversion.

Question 10

You are preparing data from an Excel workbook that contains multiple sheets. Each sheet has a similar structure but different data. You need to combine all sheets into a single table in Power Query. What is the most efficient approach?

Accepted Answer

Use the 'Combine Files' approach with the workbook as a folder, then select all sheets.. The 'Combine Files' approach in Power Query treats the workbook as a folder, allowing you to select all sheets and automatically combine them into a single table. This is the most efficient method when multiple sheets have a similar structure, as it uses a single transformation step and handles dynamic sheet names without manual query creation.

Answer

Load each sheet as a separate query and then use 'Append Queries' to combine them.

Answer

Use 'Merge Queries' to join the sheets based on a common column.

Answer

Create a new query that references each sheet query and then merges them.