SOL-C01 · Question #225
SOL-C01 Question #225: Real Exam Question with Answer & Explanation
The correct answer is C: Row-level security policies. Row-level security policies allow you to define policies that filter rows based on user or role attributes. In this scenario, you can create a policy that checks the account ID of the consumer and filters the rows accordingly. Data masking policies obscure data, but do not filter
Question
You are a data provider on the Snowflake Marketplace. You want to restrict access to specific rows in a shared table based on the consumer's account ID. Which of the following features in Snowflake can you use to accomplish this?
Options
- AData Masking policies
- BSecure Data Sharing with Reader Accounts
- CRow-level security policies
- DDynamic Data Masking
- EExternal Tables with Custom Views
Explanation
Row-level security policies allow you to define policies that filter rows based on user or role attributes. In this scenario, you can create a policy that checks the account ID of the consumer and filters the rows accordingly. Data masking policies obscure data, but do not filter rows. Reader accounts don't apply row level filtering. Dynamic data masking is for obscuring, and External tables are for external data sources not native sharing filtering.
Topics
Community Discussion
No community discussion yet for this question.