PL-300 Practice Test 6 — 10 Questions

Question 1

You need to create a relationship between two tables in Power BI. Both tables contain a column named 'ProductID', but the values in one table are integers and in the other are text. What should you do first?

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

Accepted Answer

Ensure both columns have the same data type, either by changing the data type in Power Query or in the model view.. In Power BI, relationships require matching data types on both sides of the key columns. If one 'ProductID' column is integer and the other is text, the relationship engine cannot resolve the join because the data types are incompatible. Changing both columns to the same data type—either in Power Query (recommended for performance) or in the model view—resolves this mismatch and allows a valid relationship to be created.

Answer

Merge the two tables into one in Power Query.

Answer

Create a new calculated column that converts the integer to text using FORMAT.

Answer

Set the relationship to 'Many-to-many' to bypass the type mismatch.

Question 2

A data analyst creates a Power BI report using a dataset that contains sensitive salary information. The analyst needs to ensure that only HR managers can see salary columns. What should the analyst use?

Accepted Answer

Object-level security (OLS).. Object-level security (OLS) is the correct choice because it restricts access to specific tables or columns within a dataset, which is exactly what is needed to hide salary columns from everyone except HR managers. OLS is defined in the dataset's Tabular Model roles and can deny access to individual columns so that unauthorized users cannot see them in reports. Row-level security (RLS) only filters rows, not columns, so it cannot prevent viewing salary columns. Microsoft Purview sensitivity labels classify and protect data but do not control column visibility in Power BI reports, and 'Restrict access' is not a valid dataset security setting for column-level control.

Answer

Row-level security (RLS).

Answer

Microsoft Purview sensitivity labels.

Answer

Set the dataset security to 'Restrict access'.

Question 3

You are preparing a Power BI dataset that will be used by report authors. The source data contains a column named 'CustomerName' with leading and trailing spaces. You need to remove these spaces in Power Query. Which transformation should you use?

Accepted Answer

Trim. The Trim transformation is specifically designed to remove leading and trailing whitespace from text values. It preserves internal spaces, ensuring names remain intact. Other transformations either target different issues or would alter the data incorrectly. Using Trim is the standard and correct way to clean this column in Power Query.

Answer

Split Column

Answer

Replace Values

Answer

Clean

Question 4

You need to create a measure that calculates year-over-year growth percentage. Which DAX function should you use?

Accepted Answer

SAMEPERIODLASTYEAR. SAMEPERIODLASTYEAR is the most direct and semantically clear function for year-over-year comparisons because it returns the same period in the prior year without requiring complex interval arguments. While DATEADD('Date'[Date], -1, YEAR) produces the same result, SAMEPERIODLASTYEAR is specifically designed for this purpose and is easier to read. PARALLELPERIOD, on the other hand, shifts entire periods and may not align with the current granularity (e.g., a monthly context would return the full prior year).

Answer

DATEADD

Answer

DATESYTD

Answer

PARALLELPERIOD

Question 5

You are connecting to a SharePoint folder that contains Excel workbooks. Each workbook has multiple sheets. You need to combine data from a specific sheet named 'Sales' across all workbooks. Which Power Query approach should you use?

Accepted Answer

Use the SharePoint folder connector, filter by .xlsx, then expand the Content column and filter by sheet name 'Sales'.. The SharePoint folder connector retrieves all files in the folder, including Excel workbooks. By filtering for .xlsx files and then expanding the Content column, you access the binary data of each workbook. You can then filter by the 'Sales' sheet name to combine data from that specific sheet across all workbooks, which is the only approach that directly handles multiple workbooks with multiple sheets.

Answer

Use the SharePoint Online List connector and select the document library.

Answer

Use the Excel connector and specify the folder path.

Answer

Use the Web connector and provide the SharePoint site URL.

Question 6

You have a Power BI model with a 'Date' table marked as a date table. You need to create a measure that calculates the running total of sales over the last 12 months. Which DAX function should you use?

Accepted Answer

DATESINPERIOD. DATESINPERIOD, is correct because it allows you to define a dynamic window of dates—specifically, the last 12 months ending with the latest date in the current filter context. When used with a measure like CALCULATE(SUM(Sales[Amount]), DATESINPERIOD('Date'[Date], MAX('Date'[Date]), -12, MONTH)), it shifts the date range backward by 12 months from the last visible date, making it ideal for a rolling 12-month total. The 'Date' table being marked as a date table ensures that time intelligence functions respect the continuous date range.

Answer

PREVIOUSYEAR

Answer

DATESYTD

Answer

DATEADD

Question 7

You have a Power BI dataset that uses Import mode and refreshes daily. The source data includes a column 'LastModifiedDate'. You want to reduce the amount of data loaded during each refresh by only loading rows that have changed since the last refresh. Which feature should you configure?

Accepted Answer

Configure incremental refresh on the table using the 'LastModifiedDate' column.. Incremental refresh in Power BI allows you to filter data by a date/time column (such as 'LastModifiedDate') so that only rows that have changed since the last refresh are loaded. This reduces refresh time and data volume while still using Import mode. The feature requires a date/time column and a properly configured policy in the Power Query Editor.

Answer

Enable query folding in Power Query.

Answer

Use the 'Reduce data' option in Power Query Editor.

Answer

Change the storage mode to DirectQuery.

Question 8

Refer to the exhibit. You are reviewing a Power BI data source credential configuration. The Azure Blob Storage data source uses 'Anonymous' credentials. However, the refresh fails with an error indicating that the blob container is private and requires authentication. Which change should you make?

Accepted Answer

Change credential type to 'Account Key' and provide the storage account key.. Azure Blob Storage containers that are private require authentication. The 'Account Key' credential type in Power BI uses the storage account key to authenticate via the Azure Storage REST API, which is the correct method for accessing private blob containers. Anonymous access only works when the container is configured for public access.

Answer

Change credential type to 'Service Principal' and provide the app ID and secret.

Answer

Change credential type to 'Basic' and provide the storage account name and key.

Answer

Change credential type to 'Windows' for the Azure Blob datasource.

Question 9

You are reviewing a Power BI data source configuration JSON. The exhibit shows a data source definition. What is the privacy level setting for the data source 'SalesData'?

Accepted Answer

Private. The privacy level setting for the data source 'SalesData' is 'Private' because the JSON snippet shows the property "privacyLevel":"Private". In Power BI, the Private privacy level restricts data from being combined with data from other sources, ensuring that sensitive data is not inadvertently shared across queries. This setting is explicitly defined in the data source configuration and is not Organizational, None, or Public.

Answer

Organizational

Answer

None

Answer

Public

Question 10

You are importing data from a folder containing multiple CSV files with identical structure. You want to automatically combine all files into one table in Power Query. Which connector should you use?

Accepted Answer

Folder connector. The Folder connector is the correct choice because it is specifically designed to connect to a folder containing multiple files, and when combined with the 'Combine Files' transformation in Power Query, it automatically merges all CSV files with identical structures into a single table. This connector handles the iterative process of reading each file and appending rows without manual scripting.

Answer

Excel Workbook connector

Answer

CSV connector

Answer

Web connector