POWER BI DATA ANALYST PL-300 CERTIFICATION
QUESTIONS AND CORRECT DETAILED ANSWERS
(VERIFIED ANSWERS) |ALREADY GRADED A+||BRAND NEW
Which source lets you connect your data to other business applications?
Ans✓✓✓Microsoft Dataverse
Which source lets users connect to a set of pre-wired connections?
Ans✓✓✓PBIDS Files
Which source contains sites, document libraries, and folders?
Ans✓✓✓SharePoint Online
Which sources can Power BI connect to (examples)? Ans✓✓✓SQL
Database
Google Analytics
R Scripts
What is the Query Editor used for? Ans✓✓✓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? Ans✓✓✓Import
How can you use parameters when connecting to data? Ans✓✓✓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?
Ans✓✓✓Data Gateway
When should you use DirectQuery? Ans✓✓✓Dataset is too large to be
stored in-memory
When would you need to access the Data Source Settings? Ans✓✓✓If
the file name or location changes
What data profiling tools does Power Query have? Ans✓✓✓Column
quality, distribution, and profile
What can the column distribution be used for? Ans✓✓✓To identify
primary keys
What is the purpose of data profiling in Power Query? Ans✓✓✓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? Ans✓✓✓Column profile
, Which data profiling tool can you use to check the number of errors in a
column? Ans✓✓✓Column quality & column profile
When would you use a tool from the Transform tab over the Add
Column tab? Ans✓✓✓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?
Ans✓✓✓Column from examples
Which Power Query tool can you use to roll-up daily transaction data
into monthly transactions Ans✓✓✓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?
Ans✓✓✓Unpivot
Which of these statements is true about merging queries?
Ans✓✓✓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.)
QUESTIONS AND CORRECT DETAILED ANSWERS
(VERIFIED ANSWERS) |ALREADY GRADED A+||BRAND NEW
Which source lets you connect your data to other business applications?
Ans✓✓✓Microsoft Dataverse
Which source lets users connect to a set of pre-wired connections?
Ans✓✓✓PBIDS Files
Which source contains sites, document libraries, and folders?
Ans✓✓✓SharePoint Online
Which sources can Power BI connect to (examples)? Ans✓✓✓SQL
Database
Google Analytics
R Scripts
What is the Query Editor used for? Ans✓✓✓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? Ans✓✓✓Import
How can you use parameters when connecting to data? Ans✓✓✓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?
Ans✓✓✓Data Gateway
When should you use DirectQuery? Ans✓✓✓Dataset is too large to be
stored in-memory
When would you need to access the Data Source Settings? Ans✓✓✓If
the file name or location changes
What data profiling tools does Power Query have? Ans✓✓✓Column
quality, distribution, and profile
What can the column distribution be used for? Ans✓✓✓To identify
primary keys
What is the purpose of data profiling in Power Query? Ans✓✓✓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? Ans✓✓✓Column profile
, Which data profiling tool can you use to check the number of errors in a
column? Ans✓✓✓Column quality & column profile
When would you use a tool from the Transform tab over the Add
Column tab? Ans✓✓✓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?
Ans✓✓✓Column from examples
Which Power Query tool can you use to roll-up daily transaction data
into monthly transactions Ans✓✓✓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?
Ans✓✓✓Unpivot
Which of these statements is true about merging queries?
Ans✓✓✓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.)
