Microsoft Power BI Data Analyst PL-300 Certification
Exam Graded A+
Which source lets you connect your data to other business applications? - ANSWER-
Microsoft Dataverse
Which source lets users connect to a set of pre-wired connections? - ANSWER-PBIDS
Files
Which source contains sites, document libraries, and folders? - ANSWER-SharePoint
Online
Which sources can Power BI connect to (examples)? - ANSWER-SQL Database
Google Analytics
R Scripts
What is the Query Editor used for? - ANSWER-To shape & transform data, then load it
into Power BI
In which storage mode are tables solely stored in-memory and queries fulfilled by
cached data? - ANSWER-Import
How can you use parameters when connecting to data? - ANSWER-To change data
source values dynamically
You plan to publish your SSAS Tabular (live connection) data model to Power BI
Service. What must be used in order for this to be possible? - ANSWER-Data Gateway
When should you use DirectQuery? - ANSWER-Dataset is too large to be stored in-
memory
When would you need to access the Data Source Settings? - ANSWER-If the file name
or location changes
What data profiling tools does Power Query have? - ANSWER-Column quality,
distribution, and profile
What can the column distribution be used for? - ANSWER-To identify primary keys
What is the purpose of data profiling in Power Query? - ANSWER-Provide a visual way
to explore data
Get a sense of your dataset composition
, To solve column quality issues
Which data profiling tool provides detailed column statistics and value distribution for a
selected column? - ANSWER-Column profile
Which data profiling tool can you use to check the number of errors in a column? -
ANSWER-Column quality & column profile
When would you use a tool from the Transform tab over the Add Column tab? -
ANSWER-When you want to overwrite the values of existing columns
Which Power Query tool can you use when you know the outcome of a column you
want but don't know which transformation(s) to use? - ANSWER-Column from examples
Which Power Query tool can you use to roll-up daily transaction data into monthly
transactions - ANSWER-Group by
You work as an analyst at Cat Slacks and you've just been handed a csv file with yearly
sales by department. After connecting to it in Power BI, you notice that each year has its
own column. Which Power Query tool can you use to turn the multiple "Year" columns
into rows? - ANSWER-Unpivot
Which of these statements is true about merging queries? - ANSWER-Merging queries
allows you to join tables based on a single column
Merging adds columns to an existing table
You can merge queries by different join kinds (left outer, inner, etc.)
Which of these operations adds rows to an existing table? - ANSWER-Appending
queries
What happens "under the hood" whenever you apply a transformation in Power Query?
- ANSWER-The Query Editor writes the corresponding M code for the applied step
Which two blocks make up the M code that runs your query? - ANSWER-Let & in
What can be useful to create unique IDs and form relationships between tables? -
ANSWER-Adding an index column
What turns a collection of independent tables into a data model? - ANSWER-
Connecting the table via relationships, based on their common fields
Which is a data model best practice? - ANSWER-Contain relationships with one-way
filters (vs. bidirectional)
Which fields would you typically find in a data table? - ANSWER-Quantity sold
Exam Graded A+
Which source lets you connect your data to other business applications? - ANSWER-
Microsoft Dataverse
Which source lets users connect to a set of pre-wired connections? - ANSWER-PBIDS
Files
Which source contains sites, document libraries, and folders? - ANSWER-SharePoint
Online
Which sources can Power BI connect to (examples)? - ANSWER-SQL Database
Google Analytics
R Scripts
What is the Query Editor used for? - ANSWER-To shape & transform data, then load it
into Power BI
In which storage mode are tables solely stored in-memory and queries fulfilled by
cached data? - ANSWER-Import
How can you use parameters when connecting to data? - ANSWER-To change data
source values dynamically
You plan to publish your SSAS Tabular (live connection) data model to Power BI
Service. What must be used in order for this to be possible? - ANSWER-Data Gateway
When should you use DirectQuery? - ANSWER-Dataset is too large to be stored in-
memory
When would you need to access the Data Source Settings? - ANSWER-If the file name
or location changes
What data profiling tools does Power Query have? - ANSWER-Column quality,
distribution, and profile
What can the column distribution be used for? - ANSWER-To identify primary keys
What is the purpose of data profiling in Power Query? - ANSWER-Provide a visual way
to explore data
Get a sense of your dataset composition
, To solve column quality issues
Which data profiling tool provides detailed column statistics and value distribution for a
selected column? - ANSWER-Column profile
Which data profiling tool can you use to check the number of errors in a column? -
ANSWER-Column quality & column profile
When would you use a tool from the Transform tab over the Add Column tab? -
ANSWER-When you want to overwrite the values of existing columns
Which Power Query tool can you use when you know the outcome of a column you
want but don't know which transformation(s) to use? - ANSWER-Column from examples
Which Power Query tool can you use to roll-up daily transaction data into monthly
transactions - ANSWER-Group by
You work as an analyst at Cat Slacks and you've just been handed a csv file with yearly
sales by department. After connecting to it in Power BI, you notice that each year has its
own column. Which Power Query tool can you use to turn the multiple "Year" columns
into rows? - ANSWER-Unpivot
Which of these statements is true about merging queries? - ANSWER-Merging queries
allows you to join tables based on a single column
Merging adds columns to an existing table
You can merge queries by different join kinds (left outer, inner, etc.)
Which of these operations adds rows to an existing table? - ANSWER-Appending
queries
What happens "under the hood" whenever you apply a transformation in Power Query?
- ANSWER-The Query Editor writes the corresponding M code for the applied step
Which two blocks make up the M code that runs your query? - ANSWER-Let & in
What can be useful to create unique IDs and form relationships between tables? -
ANSWER-Adding an index column
What turns a collection of independent tables into a data model? - ANSWER-
Connecting the table via relationships, based on their common fields
Which is a data model best practice? - ANSWER-Contain relationships with one-way
filters (vs. bidirectional)
Which fields would you typically find in a data table? - ANSWER-Quantity sold
