PL-300 MS Learn - Prepare data for
analysis with Power BI Exam
Questions & Answers (Grade A+)
Unlike Import mode, DirectQuery models do not store ______ in
Power BI. -
What is a flat file?
A. A file with multiple linked tables
B. A file that supports hierarchies
C. A file with a single data table and uniform row structure
D. A compressed binary file -
correct answer ✅C
Which file storage option allows automatic synchronization
between the Excel file and Power BI?
A. Local storage
,PL-300 MS Learn - Prepare data for
analysis with Power BI Exam
Questions & Answers (Grade A+)
B. SharePoint on-premises
C. OneDrive for Business
D. USB drives -
correct answer ✅C
What happens when you load data from a local Excel file into Power
BI?
A. The file remains linked for ongoing updates
B. A new semantic model is created and changes to the original file
are not reflected
C. Data is automatically refreshed every 24 hours
D. Power BI uploads the entire file to the cloud -
correct answer ✅B
,PL-300 MS Learn - Prepare data for
analysis with Power BI Exam
Questions & Answers (Grade A+)
Which Power BI feature allows you to preview and select tables
from an Excel workbook?
A. Power Query
B. Model View
C. Navigator Window
D. Dashboard Editor -
correct answer ✅C
Power BI's _______ Editor allows users to clean and transform data
before loading it into a model. -
correct answer ✅Power Query
When using Power BI Desktop, the button used to access data
sources is labeled.... -
correct answer ✅Get data
, PL-300 MS Learn - Prepare data for
analysis with Power BI Exam
Questions & Answers (Grade A+)
To maintain synchronization between an Excel file and Power BI
dashboards, it is best to store the file on what sources? -
correct answer ✅OneDrive for Business, SharePoint Team Sites
Files saved to a __________ drive will not automatically update
Power BI models when changed. -
correct answer ✅Local
This is a file containing a single table with a uniform structure and
no hierarchies, such as .csv or .txt files. -
correct answer ✅Flat file
This is a Power BI tool used to review, clean, and transform data
before loading it into the model. -
correct answer ✅Power Query Editor
This is a window in Power BI that displays the tables/entities
available in the selected data source and allows previewing and
selection before import. -
correct answer ✅Navigator Window
analysis with Power BI Exam
Questions & Answers (Grade A+)
Unlike Import mode, DirectQuery models do not store ______ in
Power BI. -
What is a flat file?
A. A file with multiple linked tables
B. A file that supports hierarchies
C. A file with a single data table and uniform row structure
D. A compressed binary file -
correct answer ✅C
Which file storage option allows automatic synchronization
between the Excel file and Power BI?
A. Local storage
,PL-300 MS Learn - Prepare data for
analysis with Power BI Exam
Questions & Answers (Grade A+)
B. SharePoint on-premises
C. OneDrive for Business
D. USB drives -
correct answer ✅C
What happens when you load data from a local Excel file into Power
BI?
A. The file remains linked for ongoing updates
B. A new semantic model is created and changes to the original file
are not reflected
C. Data is automatically refreshed every 24 hours
D. Power BI uploads the entire file to the cloud -
correct answer ✅B
,PL-300 MS Learn - Prepare data for
analysis with Power BI Exam
Questions & Answers (Grade A+)
Which Power BI feature allows you to preview and select tables
from an Excel workbook?
A. Power Query
B. Model View
C. Navigator Window
D. Dashboard Editor -
correct answer ✅C
Power BI's _______ Editor allows users to clean and transform data
before loading it into a model. -
correct answer ✅Power Query
When using Power BI Desktop, the button used to access data
sources is labeled.... -
correct answer ✅Get data
, PL-300 MS Learn - Prepare data for
analysis with Power BI Exam
Questions & Answers (Grade A+)
To maintain synchronization between an Excel file and Power BI
dashboards, it is best to store the file on what sources? -
correct answer ✅OneDrive for Business, SharePoint Team Sites
Files saved to a __________ drive will not automatically update
Power BI models when changed. -
correct answer ✅Local
This is a file containing a single table with a uniform structure and
no hierarchies, such as .csv or .txt files. -
correct answer ✅Flat file
This is a Power BI tool used to review, clean, and transform data
before loading it into the model. -
correct answer ✅Power Query Editor
This is a window in Power BI that displays the tables/entities
available in the selected data source and allows previewing and
selection before import. -
correct answer ✅Navigator Window
