Microsoft Power BI Data Analyst Associate Study
Guide: Prepare for the PL-300 Exam and Use
Power BI Successfully 1st Edition exam with
questions and answers
,Question 1
You are connecting to a SQL Server database. The source table has 50
million rows. You need to ensure that visuals reflect the latest data
instantly when users interact with the report, but you cannot increase the
load on the source database significantly. What should you do?
A) Use Import mode with a scheduled refresh every 15 minutes.
B) Use DirectQuery mode.
C) Use Import mode and enable Incremental Refresh.
D) Use DirectQuery mode with "Assume referential integrity" enabled.
✅ Correct ,,,,,answer,,,: B
Rationale: DirectQuery mode sends queries directly to the source
database, ensuring real-time data without importing the entire 50 million
rows. However, it increases load on the source. While Import with
Incremental Refresh (C) reduces load, it doesn't provide instant real-time
updates without refresh latency.
Question 2
You have a query with a column containing "Product Code" and "Product
Description" concatenated with a pipe (|). You need to split them. Which
Split Column option should you choose?
A) By Positions
B) By Delimiter
C) By Lowercase to Uppercase
D) By Number of Characters
,✅ Correct ,,,,,answer,,,: B
Rationale: The "Split Column" option "By Delimiter" is designed to
separate text based on a specified character. The pipe (|) acts as a
delimiter, allowing the column to be split into two distinct columns, one
for the product code and one for its description. This is the most efficient
method for handling concatenated data with a consistent separator.
Question 3
You are importing data and notice that a numeric column is being
imported as Text because of mixed data types (some rows have "N/A").
How should you handle this?
A) Change the column type to Whole Number; it will automatically convert
"N/A" to 0.
B) Replace "N/A" with null (or a blank) using Replace Values, then change
the type to Whole Number.
C) Keep it as Text and use it in visuals.
D) Remove the column entirely.
✅ Correct ,,,,,answer,,,: B
Rationale: You must cleanse the data before changing the type. Replacing
"N/A" with null allows the column to be converted to a numeric type
successfully. Errors during type conversion must be resolved in Power
Query before loading.
Question 4
What is the difference between "Reference" and "Duplicate" in Power
, Query?
A) Duplicate creates a new query independent of the original; Reference
creates a new query that retains a connection to the original's
transformations.
B) Reference creates a new query independent of the original; Duplicate
retains a connection to the original.
C) There is no difference.
D) Duplicate is faster than Reference.
✅ Correct ,,,,,answer,,,: A
Rationale: Duplicate creates a completely independent copy of the query,
breaking any connection to the original. Reference creates a new query
that retains a connection to the original's transformations, so changes to
the original will flow through to the referenced query. This distinction is
crucial for understanding data lineage and optimization strategies.
Question 5
You are using Power Query to append 10 Excel files. After appending, you
notice the data types for a "Date" column are mixed (some are Date, some
are Text). What is the best practice to avoid this in the future?
A) Manually change the data type after every refresh.
B) In the "Combine Files" sample file, transform the data type to Date
before Power BI auto-generates the functions.
C) Ignore the error, as Power BI handles mixed types automatically.
D) Convert the column to Binary.
✅ Correct ,,,,,answer,,,: B
Rationale: When combining files, Power Query uses a sample file to
define the schema. By transforming the sample file to the correct data
Guide: Prepare for the PL-300 Exam and Use
Power BI Successfully 1st Edition exam with
questions and answers
,Question 1
You are connecting to a SQL Server database. The source table has 50
million rows. You need to ensure that visuals reflect the latest data
instantly when users interact with the report, but you cannot increase the
load on the source database significantly. What should you do?
A) Use Import mode with a scheduled refresh every 15 minutes.
B) Use DirectQuery mode.
C) Use Import mode and enable Incremental Refresh.
D) Use DirectQuery mode with "Assume referential integrity" enabled.
✅ Correct ,,,,,answer,,,: B
Rationale: DirectQuery mode sends queries directly to the source
database, ensuring real-time data without importing the entire 50 million
rows. However, it increases load on the source. While Import with
Incremental Refresh (C) reduces load, it doesn't provide instant real-time
updates without refresh latency.
Question 2
You have a query with a column containing "Product Code" and "Product
Description" concatenated with a pipe (|). You need to split them. Which
Split Column option should you choose?
A) By Positions
B) By Delimiter
C) By Lowercase to Uppercase
D) By Number of Characters
,✅ Correct ,,,,,answer,,,: B
Rationale: The "Split Column" option "By Delimiter" is designed to
separate text based on a specified character. The pipe (|) acts as a
delimiter, allowing the column to be split into two distinct columns, one
for the product code and one for its description. This is the most efficient
method for handling concatenated data with a consistent separator.
Question 3
You are importing data and notice that a numeric column is being
imported as Text because of mixed data types (some rows have "N/A").
How should you handle this?
A) Change the column type to Whole Number; it will automatically convert
"N/A" to 0.
B) Replace "N/A" with null (or a blank) using Replace Values, then change
the type to Whole Number.
C) Keep it as Text and use it in visuals.
D) Remove the column entirely.
✅ Correct ,,,,,answer,,,: B
Rationale: You must cleanse the data before changing the type. Replacing
"N/A" with null allows the column to be converted to a numeric type
successfully. Errors during type conversion must be resolved in Power
Query before loading.
Question 4
What is the difference between "Reference" and "Duplicate" in Power
, Query?
A) Duplicate creates a new query independent of the original; Reference
creates a new query that retains a connection to the original's
transformations.
B) Reference creates a new query independent of the original; Duplicate
retains a connection to the original.
C) There is no difference.
D) Duplicate is faster than Reference.
✅ Correct ,,,,,answer,,,: A
Rationale: Duplicate creates a completely independent copy of the query,
breaking any connection to the original. Reference creates a new query
that retains a connection to the original's transformations, so changes to
the original will flow through to the referenced query. This distinction is
crucial for understanding data lineage and optimization strategies.
Question 5
You are using Power Query to append 10 Excel files. After appending, you
notice the data types for a "Date" column are mixed (some are Date, some
are Text). What is the best practice to avoid this in the future?
A) Manually change the data type after every refresh.
B) In the "Combine Files" sample file, transform the data type to Date
before Power BI auto-generates the functions.
C) Ignore the error, as Power BI handles mixed types automatically.
D) Convert the column to Binary.
✅ Correct ,,,,,answer,,,: B
Rationale: When combining files, Power Query uses a sample file to
define the schema. By transforming the sample file to the correct data
