exam questions

Exam 70-778 All Questions

View all questions & answers for the 70-778 exam

Exam 70-778 topic 2 question 1 discussion

Actual exam question from Microsoft's 70-778
Question #: 1
Topic #: 2
[All 70-778 Questions]

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?

  • 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
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
References: https://docs.microsoft.com/en-us/power-bi/power-bi-how-to-report-filter

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Dik
Highly Voted 5 years, 10 months ago
should be A, only filter by country won't work, plus other users should be able to see the same report with other data
upvoted 45 times
sjonghe
4 years, 1 month ago
Cannot be A either as CountryRegionName is not written with capital 'C' in the filter expression.
upvoted 1 times
Lhouss
4 years ago
Column names is not case sensitive
upvoted 3 times
...
...
...
GeDei
Highly Voted 4 years, 8 months ago
The answer is A We have one Table so we can concatenate with && the Values. D would be correct for two Tables and the Filter Clothing would not miss
upvoted 7 times
Mabuse1
1 year, 4 months ago
If you wasn't lazy enough to try it, you won't write this nonsense here.
upvoted 1 times
...
...
Lhouss
Most Recent 4 years ago
A is correct answer. We have only one table Sales that contains the two columns needed in the role.
upvoted 1 times
...
Lhouss
4 years ago
should be A
upvoted 2 times
...
CDL
4 years, 1 month ago
A is right, RLS, https://docs.microsoft.com/en-us/learn/modules/row-level-security-power-bi/
upvoted 2 times
...
borut
4 years, 4 months ago
Correct answer is: [CountryRegionName] = "United States" [ProductCategory] = "Clothing" 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. The answer in this question is incomplete.
upvoted 5 times
v__
4 years, 3 months ago
We have just one table here. The correct answer is A!
upvoted 3 times
Mabuse1
1 year, 4 months ago
why are you writing a non-sense which you was lazy enough to not even try on your PBI desktop?
upvoted 1 times
...
...
...
Echicken69
4 years, 5 months ago
Assuming that others Outside the United States and Clothing are viewing this data, B won't work because you have to go in and keep changing it when you give it to Users who need to see other data "Outside" of United States and Clothing. Using an RLS helps because you can do all the changes you need in the report knowing that the right users can only see what they are meant to see....Filtering it specifically and locking the dataset so that the report only shows United States and Clothing is not best practice because you have to do it for EVERYONE which is admin intensive because you have to go in and change the filters everytime you have it to another Sales Team. Mind you, the example doesn't give a context of who are my Users, how many they are ,what the data looks like and is there any other Categories I should be aware... it's a badly written question tba. But I don't agree with D because the requirement states for United States and Clothing...and if you filtering with only just United States then obviously the Clothing bit is not applied... admin please confirm...
upvoted 1 times
...
Kristiannl
4 years, 6 months ago
Should be A, you can only create a role in desktop
upvoted 1 times
...
Agustin
4 years, 6 months ago
I tried the sintaxis from A and it did work for me.
upvoted 2 times
...
maqk1985
4 years, 10 months ago
I believe the answer is A, table name is sales, the logic says that sales table will be consumed by sales team and no other teams, so no need to create a role in this case as sales team are the only people who will see the dashboard, so it is enough to fiter the dashboard on these values (assuming that D is missed compared to previous question in this series
upvoted 1 times
...
mohroshdy
4 years, 11 months ago
A is the correct answer You have to use RLS (Row-level Security) to prevent some users to see some data, so you have to make a new role for that sales team Here, the data is in one table names Sales so you can add && between the filters in the role
upvoted 6 times
Dirk
4 years, 9 months ago
I think the writing && is not allowed in a DAX formula https://docs.microsoft.com/de-de/power-bi/service-admin-rls
upvoted 1 times
CYRUSD
4 years, 7 months ago
Its Allowded
upvoted 3 times
...
vcyc
4 years, 5 months ago
It's allowed. &&- AND ||- OR
upvoted 1 times
...
...
...
twane
5 years, 3 months ago
You can apply a filter on report-level and lock it, so option D can be the right option: https://community.powerbi.com/t5/Desktop/How-to-lock-filters-so-that-end-users-cannot-change-them/td-p/577736 However this answer misses the Productcategory "clothing"... I don't see why changing the query filters would not be the best solution though.
upvoted 3 times
...
Hien
5 years, 3 months ago
The question #10 in Topic 1 is similar, and complete answer is "Add the following filters to a report. CountryRegionName is United States ProductCategory is Clothing" it is similar answer here is D, only missing the ProductCategory is Clothing.
upvoted 5 times
Hien
5 years, 3 months ago
in this question, answer is B, you can filter either in report or in Query editor.
upvoted 1 times
Dirk
4 years, 9 months ago
I agree because B represents both criteria - Product Category and CountryRegion as well. Above this a filter may be locked, so a role must not be the solution. To me it's the most complete approach.
upvoted 3 times
...
...
DDS
5 years, 3 months ago
I have other dump. According to my dump "D" is "Add the following filters to a report. CountryRegionName is United States ProductCategory is Clothing"
upvoted 2 times
JohnFan
5 years ago
https://docs.microsoft.com/en-us/power-bi/desktop-rls
upvoted 2 times
...
...
sumitmalik
4 years, 6 months ago
i think here we have only 1 table so A should work
upvoted 3 times
...
...
TiaanR
5 years, 5 months ago
Agree with Dik, should be A. A filter doesn't stop users from changing the filter settings and then seeing restricted data.
upvoted 2 times
...
rohit
5 years, 6 months ago
I too blv the same but another site gave D too
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago