Microsoft Power BI Data Analyst Associate
PL-200 Exam Study Guide (1st Edition) |
Complete Practice Questions, Solutions &
Step-by-Step Power BI Training for
Certification Success
• This study guide contains 200 carefully crafted practice questions covering every
topic tested on the Microsoft PL-300 Power BI Data Analyst Associate exam — use it
by attempting each question independently before checking the highlighted correct
answer and EXPERT RATIONALE below it.
• Each question mirrors the style, depth, and difficulty of the real exam, with clear
A–E options, bolded correct answers, and concise EXPERT RATIONALE to reinforce
understanding and close knowledge gaps fast.
MICROSOFT POWER BI DATA ANALYST ASSOCIATE (PL-300) 200 PRACTICE
QUESTIONS — FULL EXAM COVERAGE
1. Which Power BI Desktop component is primarily used to connect to data
sources, transform data, and load it into the data model?
A. Report View
B. Data View
C. Model View
D. DAX Editor
E. Power Query Editor
Correct Answer: E. Power Query Editor
EXPERT RATIONALE: Power Query Editor is the built-in ETL (Extract, Transform,
Load) tool in Power BI Desktop. It provides a graphical interface for connecting to
data sources, applying transformations, and shaping data before it is loaded into
the data model.
,2. A data analyst needs to import data from multiple Excel files stored in the
same folder. What is the most efficient approach?
A. Import each file individually and append them manually
B. Use a Python script to merge the files
C. Use the Web connector to access the files
D. Use the Folder connector to combine all files automatically
E. Use a SharePoint connector
Correct Answer: D. Use the Folder connector to combine all files automatically
EXPERT RATIONALE: The Folder connector in Power Query allows you to point
to a directory and automatically combine all files of the same type within it. This is
the most efficient method when multiple similarly structured files need to be
merged.
3. What does the "Column Quality" feature in Power Query Editor display?
A. Data types of each column
B. Relationships between columns
C. Sort order of column values
D. Percentage of valid, error, and empty values in a column
E. Number of distinct values per column
Correct Answer: D. Percentage of valid, error, and empty values in a column
EXPERT RATIONALE: Column Quality is a data profiling tool in Power Query that
shows three metrics per column: the percentage of valid, error, and empty values
— helping analysts quickly identify data quality issues.
4. Which of the following transformations would you use in Power Query to
turn column headers into rows?
,A. Transpose
B. Pivot Column
C. Unpivot Columns
D. Merge Queries
E. Fill Down
Correct Answer: C. Unpivot Columns
EXPERT RATIONALE: Unpivot Columns takes selected column headers and their
values and converts them into attribute-value row pairs. This is commonly used to
normalize wide tables into a long format suitable for analysis.
5. A column contains mixed data types. What should an analyst do to ensure
consistent data types in Power Query?
A. Leave the column as-is; Power BI handles it automatically
B. Delete the column and recreate it
C. Use a DAX expression to fix the types
D. Use the "Change Type" option to explicitly set the correct data type
E. Convert the column using Python
Correct Answer: D. Use the "Change Type" option to explicitly set the correct
data type
EXPERT RATIONALE: Explicitly setting data types using the "Change Type"
option in Power Query ensures data consistency and prevents errors during
analysis. Power BI may auto-detect types incorrectly, so manual assignment is best
practice.
6. Which Power Query step is automatically added when you load a CSV file to
ensure correct data types are assigned?
, A. Remove Errors
B. Changed Type
C. Promote Headers
D. Fill Down
E. Rename Columns
Correct Answer: B. Changed Type
EXPERT RATIONALE: When loading a CSV file, Power Query automatically adds
a "Changed Type" step after detecting column types. This ensures that numeric,
date, and text columns are correctly typed from the beginning.
7. What is the purpose of the "Promote Headers" step in Power Query?
A. To sort column values alphabetically
B. To remove the first row of data
C. To use the first row of data as column headers
D. To merge the first row with column names
E. To add a new row at the top of the table
Correct Answer: C. To use the first row of data as column headers
EXPERT RATIONALE: "Promote Headers" is used when the actual column
names are stored in the first data row of the source file rather than as true
headers. This step converts that row into proper column headers.
8. Which of the following best describes a "query parameter" in Power Query?
A. A fixed value hard-coded in the query
B. A column that filters data dynamically
C. A named, reusable value that can be referenced in queries
PL-200 Exam Study Guide (1st Edition) |
Complete Practice Questions, Solutions &
Step-by-Step Power BI Training for
Certification Success
• This study guide contains 200 carefully crafted practice questions covering every
topic tested on the Microsoft PL-300 Power BI Data Analyst Associate exam — use it
by attempting each question independently before checking the highlighted correct
answer and EXPERT RATIONALE below it.
• Each question mirrors the style, depth, and difficulty of the real exam, with clear
A–E options, bolded correct answers, and concise EXPERT RATIONALE to reinforce
understanding and close knowledge gaps fast.
MICROSOFT POWER BI DATA ANALYST ASSOCIATE (PL-300) 200 PRACTICE
QUESTIONS — FULL EXAM COVERAGE
1. Which Power BI Desktop component is primarily used to connect to data
sources, transform data, and load it into the data model?
A. Report View
B. Data View
C. Model View
D. DAX Editor
E. Power Query Editor
Correct Answer: E. Power Query Editor
EXPERT RATIONALE: Power Query Editor is the built-in ETL (Extract, Transform,
Load) tool in Power BI Desktop. It provides a graphical interface for connecting to
data sources, applying transformations, and shaping data before it is loaded into
the data model.
,2. A data analyst needs to import data from multiple Excel files stored in the
same folder. What is the most efficient approach?
A. Import each file individually and append them manually
B. Use a Python script to merge the files
C. Use the Web connector to access the files
D. Use the Folder connector to combine all files automatically
E. Use a SharePoint connector
Correct Answer: D. Use the Folder connector to combine all files automatically
EXPERT RATIONALE: The Folder connector in Power Query allows you to point
to a directory and automatically combine all files of the same type within it. This is
the most efficient method when multiple similarly structured files need to be
merged.
3. What does the "Column Quality" feature in Power Query Editor display?
A. Data types of each column
B. Relationships between columns
C. Sort order of column values
D. Percentage of valid, error, and empty values in a column
E. Number of distinct values per column
Correct Answer: D. Percentage of valid, error, and empty values in a column
EXPERT RATIONALE: Column Quality is a data profiling tool in Power Query that
shows three metrics per column: the percentage of valid, error, and empty values
— helping analysts quickly identify data quality issues.
4. Which of the following transformations would you use in Power Query to
turn column headers into rows?
,A. Transpose
B. Pivot Column
C. Unpivot Columns
D. Merge Queries
E. Fill Down
Correct Answer: C. Unpivot Columns
EXPERT RATIONALE: Unpivot Columns takes selected column headers and their
values and converts them into attribute-value row pairs. This is commonly used to
normalize wide tables into a long format suitable for analysis.
5. A column contains mixed data types. What should an analyst do to ensure
consistent data types in Power Query?
A. Leave the column as-is; Power BI handles it automatically
B. Delete the column and recreate it
C. Use a DAX expression to fix the types
D. Use the "Change Type" option to explicitly set the correct data type
E. Convert the column using Python
Correct Answer: D. Use the "Change Type" option to explicitly set the correct
data type
EXPERT RATIONALE: Explicitly setting data types using the "Change Type"
option in Power Query ensures data consistency and prevents errors during
analysis. Power BI may auto-detect types incorrectly, so manual assignment is best
practice.
6. Which Power Query step is automatically added when you load a CSV file to
ensure correct data types are assigned?
, A. Remove Errors
B. Changed Type
C. Promote Headers
D. Fill Down
E. Rename Columns
Correct Answer: B. Changed Type
EXPERT RATIONALE: When loading a CSV file, Power Query automatically adds
a "Changed Type" step after detecting column types. This ensures that numeric,
date, and text columns are correctly typed from the beginning.
7. What is the purpose of the "Promote Headers" step in Power Query?
A. To sort column values alphabetically
B. To remove the first row of data
C. To use the first row of data as column headers
D. To merge the first row with column names
E. To add a new row at the top of the table
Correct Answer: C. To use the first row of data as column headers
EXPERT RATIONALE: "Promote Headers" is used when the actual column
names are stored in the first data row of the source file rather than as true
headers. This step converts that row into proper column headers.
8. Which of the following best describes a "query parameter" in Power Query?
A. A fixed value hard-coded in the query
B. A column that filters data dynamically
C. A named, reusable value that can be referenced in queries
