Microsoft PL-300 Practice Questions - Page 18

Which options cannot be added as a group member?

Which of the following filter options applies to all visuals across all pages of the report?

Report level filters apply to all visuals across all pages of the report.

What allows users to jump to different report pages while simultaneously filtering based on the specific item selected?

Drill through filters

Drill through filters allow users to jump to different report pages (like bookmarks), while simultaneously filtering based on the specific item selected

The account you use for registering an app for embedding Power BI content doesn't need a Power BI Pro license allocated to it. Is this statement true?

Which of the following is not a limitation of publishing a report to website?

Row level security won’ t work.

R visuals are not supported

Custom visuals are not supported

Reports that connect live to on-premises Analysis Services Tabular are not supported

What are the types of row context?

Row Context and Function Context

Function Context and Filter Context

Filter Context and Row Context

Which are calculated on demand?

Consider the following custom column formula: = if [Country] = “USA” then “United States” else [Country] Which of the following statements describes the value of the custom column formula?

The value will either be “United States” or whatever the value of the Country column is.

The value will be the same as the Country column.

The value will be “United States”.

The value will be “USA”.

As part of a large HR project you are working with a dataset of company employees, both past and present. The data includes columns for EthnicGroup, PayTypeID, HireDate (the date they started work), TermDate (the date they left) and several other columns. You want to create a new Calculated Column that determines if the person was a bad hire based on a set of rules. If they were a bad hire then the result is 1, otherwise the Calculated Column displays a zero. The bad hire rule is: BadHire = If the person stayed at the company less than 61 days Example: If a person joined the company on 27th June 2013 and left on 21st August 2013, then they would be a bad hire. Which DAX expression would you use for this Calculated Column?

IF(((([HireDate]-[TermDate]) *-1) < 61),1,0)

IF((([TermDate]-[HireDate]) *-1) < = 61,0,1)

IF(OR((([HireDate]-[TermDate])) < = 61, ISBLANK([TermDate])),0,1)

Which of the following functions removes filter context?

Instead of adding filter context, ALL removes it; use it when you need unfiltered values that won’t react to changes in filter context (i.e. % of Total, where the denominator needs to remain fixed)