問題文
A table has a column holding customer email addresses. The support team must see the addresses, but the wider analyst group must be able to use the rest of the table without seeing them. Which approach meets both needs on the same table?
選択肢
- Apply a row filter that removes rows containing customer email addresses for the analyst group.
- Copy the table without the email column and grant the analyst group access to the copy, refreshing it nightly.
- Ask the analyst group to leave the email column out of their SELECT lists, since a column that is not selected cannot be seen.
- Apply a column mask to the email column so that the value is obscured for everyone except the group allowed to see it.