A provider is developing a Snowflake Native Application that shares event data with consumers. The provider wants to ensure that specific columns in the event data are obfuscated for certain consumer accounts, while remaining visible to others. Which of the following approaches is the MOST secure and maintainable way to achieve this?
Correct Answer: B
B is the correct answer. Dynamic data masking policies offer a scalable and maintainable solution. By using the or function within the masking policy's expression, you can selectively mask columns based on the consumer account. This eliminates the need for creating separate views or complex stored procedures. A is not scalable and difficult to maintain. C & D are more complex than B and potentially less secure. E is wrong. Data masking is supported.