Power BI: PL-300 Exam Study Set
Questions and Answers
How do you fix relationships to allow visuals to be filtered by attributes in two
different tables - ANSWER-Set the cross filter direction to both and select apply
security filter in both directions
Is the quick insight feature available in power bi desktop? - ANSWER-No, it is only
available on power bi service
Does quick insight require a data source to be set to DirectQuery? - ANSWER-No
Can quick insights discover the overall trends in a time series - ANSWER-Yes
How can you set weekly email updates about data? - ANSWER-Create a
subscription, data alerts only email you when a target is reached
Why should you set interaction behavior to none? - ANSWER-When you don't want
to filter a visual based on other visual selections
What is the difference between highlight and filter? - ANSWER-Filter only shows the
information pertaining to an insight you are looking for. Highlighting doesn't get rid of
information but instead focuses on the relevant information
What does the SAMEPERIODLASTYEAR function do? - ANSWER-It shows the
information from a given period for the context in a visual from the year prior to the
date context you are looking at
What does the PARALLELPERIOD function do? - ANSWER-Fetches the information
from a period prior, you must determine how far back you are looking (ie. -1 provides
last period) and what data hierarchy values you are looking for (ie. MONTH provides
the information for the parallel month)
How to create an aggregation? - ANSWER-1. Create a new table for the
aggregations with the same fields of the table you wish to aggregate
2. Select the original table and select manage aggregations
3. Select the new table as the aggregation table
4. Select the summarization type
5. Select the table and column from the original table
What is query folding? - ANSWER-The ability for Power Query to generate a single
query statement to retrieve and transform source data
What is the possible cause for the View Native Query option being disabled? -
ANSWER-The Common data Service connector does not support query folding
, When to use AverageX instead of Average - ANSWER-to evaluate the correct value
when filters are applied
Column Profile - ANSWER-Shows the entire profile of data for a column with all rows
included
Column quality - ANSWER-Shows valid empty or error values in a column. By
default only shows the first 1000 rows, but if you change the profiling it can show the
entire column
Column Distribution - ANSWER-Shows the amount of distinct and unique values in a
column
Should you enable Power Query background refresh to ensure data is up to date? -
ANSWER-No, the data is cached and not updated when the dataset is refreshed
Calendar vs. Calendar Auto - ANSWER-Calendar requires a start and end date
Calendar Auto requires an end date (ie. If you want the fiscal year to start in may
then select April because that is the month the year will end on)
When to use Quick Insights - ANSWER-To generate charts and graph visuals for an
entire dataset
What feature should you use to generate chart and graph visuals for the data in a
visual - ANSWER-View Insights
What steps are involved for configuring email alerts? - ANSWER-1. Choose more
options on the manufacturing efficiency card visual and click on manage alerts
2. Click the + add alert rule button
3. Choose below in the condition field and set the threshold value
What two ways can you filter for all pages on a report? - ANSWER-1. Add a slicer to
each of the pages with the same field selected and configure synch slicers
2. Add a report level filter
How to enable drill through? - ANSWER-1. Create a visual on a new page
2. On the new page enable keep all filters on
3. On new visual add the field you want to drill through on
4. Every visual that includes that field will allow drill through when right clicked on
How to combine tables from JSON source - ANSWER-Combine Files
Questions and Answers
How do you fix relationships to allow visuals to be filtered by attributes in two
different tables - ANSWER-Set the cross filter direction to both and select apply
security filter in both directions
Is the quick insight feature available in power bi desktop? - ANSWER-No, it is only
available on power bi service
Does quick insight require a data source to be set to DirectQuery? - ANSWER-No
Can quick insights discover the overall trends in a time series - ANSWER-Yes
How can you set weekly email updates about data? - ANSWER-Create a
subscription, data alerts only email you when a target is reached
Why should you set interaction behavior to none? - ANSWER-When you don't want
to filter a visual based on other visual selections
What is the difference between highlight and filter? - ANSWER-Filter only shows the
information pertaining to an insight you are looking for. Highlighting doesn't get rid of
information but instead focuses on the relevant information
What does the SAMEPERIODLASTYEAR function do? - ANSWER-It shows the
information from a given period for the context in a visual from the year prior to the
date context you are looking at
What does the PARALLELPERIOD function do? - ANSWER-Fetches the information
from a period prior, you must determine how far back you are looking (ie. -1 provides
last period) and what data hierarchy values you are looking for (ie. MONTH provides
the information for the parallel month)
How to create an aggregation? - ANSWER-1. Create a new table for the
aggregations with the same fields of the table you wish to aggregate
2. Select the original table and select manage aggregations
3. Select the new table as the aggregation table
4. Select the summarization type
5. Select the table and column from the original table
What is query folding? - ANSWER-The ability for Power Query to generate a single
query statement to retrieve and transform source data
What is the possible cause for the View Native Query option being disabled? -
ANSWER-The Common data Service connector does not support query folding
, When to use AverageX instead of Average - ANSWER-to evaluate the correct value
when filters are applied
Column Profile - ANSWER-Shows the entire profile of data for a column with all rows
included
Column quality - ANSWER-Shows valid empty or error values in a column. By
default only shows the first 1000 rows, but if you change the profiling it can show the
entire column
Column Distribution - ANSWER-Shows the amount of distinct and unique values in a
column
Should you enable Power Query background refresh to ensure data is up to date? -
ANSWER-No, the data is cached and not updated when the dataset is refreshed
Calendar vs. Calendar Auto - ANSWER-Calendar requires a start and end date
Calendar Auto requires an end date (ie. If you want the fiscal year to start in may
then select April because that is the month the year will end on)
When to use Quick Insights - ANSWER-To generate charts and graph visuals for an
entire dataset
What feature should you use to generate chart and graph visuals for the data in a
visual - ANSWER-View Insights
What steps are involved for configuring email alerts? - ANSWER-1. Choose more
options on the manufacturing efficiency card visual and click on manage alerts
2. Click the + add alert rule button
3. Choose below in the condition field and set the threshold value
What two ways can you filter for all pages on a report? - ANSWER-1. Add a slicer to
each of the pages with the same field selected and configure synch slicers
2. Add a report level filter
How to enable drill through? - ANSWER-1. Create a visual on a new page
2. On the new page enable keep all filters on
3. On new visual add the field you want to drill through on
4. Every visual that includes that field will allow drill through when right clicked on
How to combine tables from JSON source - ANSWER-Combine Files
