Microsoft PL-300 QUESTIONS AND ANSWERS |
VERIFIED AND WELL DETAILED ANSWERS | PLUS
RATIONALES | GUARANTEED PASS | LATEST EXAM
UPDATE | EXAM PREP | STUDY GUIDE | PRACTICE
TEST
Domain 1: Prepare the Data (25 questions)
1. You need to connect to a CSV file stored in a SharePoint Online folder. Which connector should you use?
,A) Web
B) SharePoint Folder
C) File > Text/CSV
D) OData Feed
Answer: B
Rationale: The SharePoint Folder connector is designed to navigate SharePoint document libraries. While you
can use Web with a direct URL, SharePoint Folder is the recommended and most reliable method for
SharePoint-stored files.
2. You have a column containing "2023-01-15 14:30:00". You need only the date. Which transformation is most
efficient?
A) Split Column by Delimiter
B) Change Type to Date
C) Extract > Date Only
D) Add a custom column with Date.From
Answer: B
,Rationale: Changing the data type directly to Date removes the time portion in a single, efficient step. Extract >
Date Only also works but adds an extra transformation step.
3. Which Power Query feature allows you to combine rows from two tables with matching columns?
A) Merge
B) Append
C) Join
D) Pivot
Answer: B
Rationale: Append combines rows (union) from tables with the same column structure. Merge joins columns
based on matching keys.
4. You need to combine two tables where each row in Table A matches one row in Table B by CustomerID.
Which join kind returns only matching rows?
A) Left Outer
B) Right Outer
C) Inner
D) Full Outer
, Answer: C
Rationale: An Inner Join returns only rows where keys exist in both tables, discarding non-matching rows.
5. A query is slow because it loads a 50-million-row table but you only need aggregated results. What should
you do?
A) Use DirectQuery
B) Enable query folding and aggregate in the source
C) Add an index
D) Increase refresh timeout
Answer: B
Rationale: Query folding pushes transformations back to the source, reducing data transferred. Aggregating at
the source minimizes rows loaded.
6. Which M function removes rows with null values in a specific column?
A) Table.RemoveRows
B) Table.SelectRows with each [Column] <> null
VERIFIED AND WELL DETAILED ANSWERS | PLUS
RATIONALES | GUARANTEED PASS | LATEST EXAM
UPDATE | EXAM PREP | STUDY GUIDE | PRACTICE
TEST
Domain 1: Prepare the Data (25 questions)
1. You need to connect to a CSV file stored in a SharePoint Online folder. Which connector should you use?
,A) Web
B) SharePoint Folder
C) File > Text/CSV
D) OData Feed
Answer: B
Rationale: The SharePoint Folder connector is designed to navigate SharePoint document libraries. While you
can use Web with a direct URL, SharePoint Folder is the recommended and most reliable method for
SharePoint-stored files.
2. You have a column containing "2023-01-15 14:30:00". You need only the date. Which transformation is most
efficient?
A) Split Column by Delimiter
B) Change Type to Date
C) Extract > Date Only
D) Add a custom column with Date.From
Answer: B
,Rationale: Changing the data type directly to Date removes the time portion in a single, efficient step. Extract >
Date Only also works but adds an extra transformation step.
3. Which Power Query feature allows you to combine rows from two tables with matching columns?
A) Merge
B) Append
C) Join
D) Pivot
Answer: B
Rationale: Append combines rows (union) from tables with the same column structure. Merge joins columns
based on matching keys.
4. You need to combine two tables where each row in Table A matches one row in Table B by CustomerID.
Which join kind returns only matching rows?
A) Left Outer
B) Right Outer
C) Inner
D) Full Outer
, Answer: C
Rationale: An Inner Join returns only rows where keys exist in both tables, discarding non-matching rows.
5. A query is slow because it loads a 50-million-row table but you only need aggregated results. What should
you do?
A) Use DirectQuery
B) Enable query folding and aggregate in the source
C) Add an index
D) Increase refresh timeout
Answer: B
Rationale: Query folding pushes transformations back to the source, reducing data transferred. Aggregating at
the source minimizes rows loaded.
6. Which M function removes rows with null values in a specific column?
A) Table.RemoveRows
B) Table.SelectRows with each [Column] <> null
