You have a column 'ProductCode' that contains values like 'ABC-123' and 'XYZ-456'. You need to extract only the numeric part of the code (e.g., '123') into a new column for analysis. What should you do in Power Query?

Use the 'Replace Values' feature to remove the letters and hyphen.

Change the data type of the column to Whole Number.

Use the 'Split Column' feature to split on the hyphen and keep the second part.

Add a custom column using Text.Select to extract digits from the ProductCode column.

Microsoft Certified:Power BI Data Analyst Associate

Domain 1Objective 3

Transform and Load the Data PL-300 Practice Questions (Page 4)

Part of the Prepare the data domain, which accounts for 25–30% of the PL-300 exam. Microsoft does not publish an official question count, but from its 100-minute exam (~40–65 total, ~10–20 in this domain), expect 3–7 from this objective — we provide 51 practice questions to prepare you well beyond it. (estimate)

51questions here

11free pages

16concepts

25–30%of the exam

Questions 16–20

16foundation · easy
You have grouped sales data by 'Product' and need to calculate the total revenue for each product. Which aggregation should you apply to the 'Revenue' column?
Select an answer first
17foundation · easy
A column contains XML data. Which Power Query transformation would you use to extract the XML elements into separate columns?
Select an answer first
18application · medium
You have a column 'ProductCode' that contains values like 'ABC-123' and 'XYZ-456'. You need to extract only the numeric part of the code (e.g., '123') into a new column for analysis. What should you do in Power Query?
Select an answer first
19foundation · easy
In a data model, which key in a table references the primary key of another table to create a relationship?
Select an answer first
20foundation · easy
In Power Query Editor, which operation groups rows by one or more columns and then applies an aggregation to the grouped data?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to PL-300

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “PL-300” is a trademark of its owner, used for identification only.

Transform and Load the Data PL-300 Practice Questions (Page 4)

Questions 16–20

You have grouped sales data by 'Product' and need to calculate the total revenue for each product. Which aggregation should you apply to the 'Revenue' column?

A column contains XML data. Which Power Query transformation would you use to extract the XML elements into separate columns?

You have a column 'ProductCode' that contains values like 'ABC-123' and 'XYZ-456'. You need to extract only the numeric part of the code (e.g., '123') into a new column for analysis. What should you do in Power Query?

In a data model, which key in a table references the primary key of another table to create a relationship?

In Power Query Editor, which operation groups rows by one or more columns and then applies an aggregation to the grouped data?

Keep studying — Prepare the data