Exam 70-778 topic 1 question 10 discussion

A filter can be modified by the end-user. To restrict access to data to certain users, roles is the feature to be used. Correct - D

Correct answer is B. First, You have 2 tables (Sales & Products), Second, You have to use RLS to prevent a sales team to view some data, Third, You have to create 2 filters, one for Sales(CountryRegionName) & one for Product(ProductCategory) as there are 2 different tables, so there are 2 filters NOT just one filter. Note: you can't filter 2 columns from 2 DIFFERENT TABLES using && but you can use && in case of the columns you wanna filter in the SAME TABLE only, so D in incorrect.

The best Answer is B, Creating a new role that has the two filters for the sale team is the best option one can opt to

Answer is definitely A, because it ask to do something from Power BI Desktop and you cant create role from powerbi desktop.

B is the correct answer

B is the Definitive Ans

Correct Answer is B. I tested it by creating two tables. You apply one filter on the table having CountryRegionName and the other having ProductCategory. D is not correct because it is using the '&&' operator which would work only within a single table.

seeing many people mentioning 2 tables so B, but how do we know exactly that sales table doesn''t have a ''product category''?

B is correct. Repost Link: https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls

Answer is B https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls

The key phrase is "What should you do from Power BI Desktop?" Only answer A can be used. You can set filters in Power BI desktop and publish. With Answer B, you can set the Role, but you have to add that Role in a Security Group.

It can't be D. You cannot build an expression the way it is shown. They are built per table. No && can be used. C is not in the spirit of the question. A and B can both work. You can lock filters. And you can set the individual DAX statement for both tables. How they choose A over B, I don't know.

D https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls#define-roles-and-rules-in-power-bi-desktop

Correct Ans is B as D refers to fields from two different tables. This will give an error

Could be a trick question where it says "model" not "table", the model is that what makes up the report so answer A is correct. What if the table was shared you might want a different filter for another report so you would not want to apply role security. If the question specifically mentions roles or security or shared but all it says ensure Sales see only so is there an implication towards assuming this report is only for sales and they just want a specific filter for this report otherwise I would have to tend towards B). Wonder if you would get partial marks in an exam for getting the second best answer as this is a mean question.

Answer is B: If both the columns are in same table, then we can use (Option D: [CountryRegionName] = "United States" && [ProductCategory] = "Clothing" But in this case, it is 2 differrent tables, we cannot use &&, have to use filters separately on tables. [CountryRegionName] = "United States" On Sales Table [ProductCategory] = "Clothing" On Product Table

Correct Answer is B