Power BI: PL-300 Exam Study Set
Answered Correctly!!!
Role Hierarchy CORRECT ANSWERS ADMN, Member, Contributor, Viewer
Admin Role CORRECT ANSWERS All responsibilities
Member Role CORRECT ANSWERS Same as Admin but cannot assign roles, delete
workspaces, or change metadata
Contributor Role CORRECT ANSWERS Can create, update, and publish and set
refreshes for content and reports but cannot publish apps, delete reports change
metadata or assign roles
Viewer Role CORRECT ANSWERS Can only view information
Auto Date Hierarchy CORRECT ANSWERS Day, Month, Quarter, Year
Lineage View CORRECT ANSWERS Shows last refresh and can identify stale data
How to format for mobile view? CORRECT ANSWERS Resize visuals and set slicers to
be responsive. Adjusting page size only affects laptop layout
Why should you switch off interactions between visuals? CORRECT ANSWERS To
prevent data to filter when selecting certain values and visuals. Useful when there are
multiple visuals in the same view and they create performance issues
Best visual to show the factors that affect the outcome of sales opportunities CORRECT
ANSWERS Key influencers
Best visual to show progress of sales opportunities won against target CORRECT
ANSWERS KPI- shows target and how much above or below we were relative to goal
Best visual to show outliers CORRECT ANSWERS Scatter
How to optimize complex Dax? CORRECT ANSWERS Rewrite expression using
variables
How to show different context in matrices or filters CORRECT ANSWERS
REMOVEFILTERS()
Can excel workbooks be edited in power bi CORRECT ANSWERS No, but power query
can edit the data imported from excel workbooks
, When changing data, does the excel workbook need to have the same file path?
CORRECT ANSWERS No, each file has a different file path
When changing to different data, does the excel workbook need to have the same
structure? CORRECT ANSWERS Yes, otherwise there will be missing columns or
different names
Can you teach Q&A to understand certain key works CORRECT ANSWERS Yes, you
can refer to certain synonyms for keywords
Can you teach Q&A certain terms? CORRECT ANSWERS No, you can only provide
synonyms to certain terms to provide context
Do you have to create aggregations to help power bi recognize certain terms
CORRECT ANSWERS No, only synonyms help the software to understand certain
terms, aggregations have nothing to do with natural language
How can you show animation in graphics? CORRECT ANSWERS Play axis or D3.js
Does turning off data hierarchies reduce the size of a dataset? CORRECT ANSWERS
Yes
Can you configure automatic data hierarchies to start on a certain month or year
CORRECT ANSWERS No
How can you debug slow performance of visuals? CORRECT ANSWERS By using
performance analyzer
When to use Percentile.INC instead of Percentile.EXC CORRECT ANSWERS When
Percentile.EXC returns errors
Percentile.EXC is more accurate but only calculates .8-.2 percentiles
What are data classifications and how are they used? CORRECT ANSWERS Data
classifications warns users about security levels to prevent them from sharing
confidential information.
How are data classifications define? CORRECT ANSWERS Data classifications are
divined at the tenant level
Where are data classifications define? CORRECT ANSWERS Power bi service
Are data classifications always displayed in a dashboard? CORRECT ANSWERS No
they need to be manual input by the administrator
Answered Correctly!!!
Role Hierarchy CORRECT ANSWERS ADMN, Member, Contributor, Viewer
Admin Role CORRECT ANSWERS All responsibilities
Member Role CORRECT ANSWERS Same as Admin but cannot assign roles, delete
workspaces, or change metadata
Contributor Role CORRECT ANSWERS Can create, update, and publish and set
refreshes for content and reports but cannot publish apps, delete reports change
metadata or assign roles
Viewer Role CORRECT ANSWERS Can only view information
Auto Date Hierarchy CORRECT ANSWERS Day, Month, Quarter, Year
Lineage View CORRECT ANSWERS Shows last refresh and can identify stale data
How to format for mobile view? CORRECT ANSWERS Resize visuals and set slicers to
be responsive. Adjusting page size only affects laptop layout
Why should you switch off interactions between visuals? CORRECT ANSWERS To
prevent data to filter when selecting certain values and visuals. Useful when there are
multiple visuals in the same view and they create performance issues
Best visual to show the factors that affect the outcome of sales opportunities CORRECT
ANSWERS Key influencers
Best visual to show progress of sales opportunities won against target CORRECT
ANSWERS KPI- shows target and how much above or below we were relative to goal
Best visual to show outliers CORRECT ANSWERS Scatter
How to optimize complex Dax? CORRECT ANSWERS Rewrite expression using
variables
How to show different context in matrices or filters CORRECT ANSWERS
REMOVEFILTERS()
Can excel workbooks be edited in power bi CORRECT ANSWERS No, but power query
can edit the data imported from excel workbooks
, When changing data, does the excel workbook need to have the same file path?
CORRECT ANSWERS No, each file has a different file path
When changing to different data, does the excel workbook need to have the same
structure? CORRECT ANSWERS Yes, otherwise there will be missing columns or
different names
Can you teach Q&A to understand certain key works CORRECT ANSWERS Yes, you
can refer to certain synonyms for keywords
Can you teach Q&A certain terms? CORRECT ANSWERS No, you can only provide
synonyms to certain terms to provide context
Do you have to create aggregations to help power bi recognize certain terms
CORRECT ANSWERS No, only synonyms help the software to understand certain
terms, aggregations have nothing to do with natural language
How can you show animation in graphics? CORRECT ANSWERS Play axis or D3.js
Does turning off data hierarchies reduce the size of a dataset? CORRECT ANSWERS
Yes
Can you configure automatic data hierarchies to start on a certain month or year
CORRECT ANSWERS No
How can you debug slow performance of visuals? CORRECT ANSWERS By using
performance analyzer
When to use Percentile.INC instead of Percentile.EXC CORRECT ANSWERS When
Percentile.EXC returns errors
Percentile.EXC is more accurate but only calculates .8-.2 percentiles
What are data classifications and how are they used? CORRECT ANSWERS Data
classifications warns users about security levels to prevent them from sharing
confidential information.
How are data classifications define? CORRECT ANSWERS Data classifications are
divined at the tenant level
Where are data classifications define? CORRECT ANSWERS Power bi service
Are data classifications always displayed in a dashboard? CORRECT ANSWERS No
they need to be manual input by the administrator
