Analyzing and Visualizing Data with Microsoft Power BI — Question 1

You manage a Power BI model has a table named Sales.
You need to ensure that a sales team can view only data that has a CountryRegionName value of United States and a ProductCategory value of Clothing.
What should you do from Power BI Desktop?

Answer options

• A. From Power BI Desktop, create a new role that has the following filter. [countryRegionName]= "United States" && [ProductCategory]= "Clothing"
• B. Add the following filters in Query Editor. CountryRegionName is United States ProductCategory is Clothing
• C. From Power BI Desktop, create a new role that has the following filters. [CountryRegionName]= "United States"
• D. Add the following filters to a report. CountryRegionName is United Sates

Correct answer: D

Explanation

The correct answer is A because it specifies both required conditions for filtering the data for the sales team. The other options are incorrect as they either do not apply the necessary filter for ProductCategory or suggest using Query Editor instead of creating a role, which does not meet the requirement to restrict data visibility effectively.