Which statement describes a limitation related to attaching a row access policy to streams?

Master the SnowPro Advanced Architect Test with flashcards, multiple-choice questions, and detailed explanations. Prepare thoroughly for your certification!

Multiple Choice

Which statement describes a limitation related to attaching a row access policy to streams?

Explanation:
Row access policies filter data by applying predicates at read time, and they are attached to tables (or views) in Snowflake. Streams, however, are change-tracking objects tied to a base table and do not store data themselves. Because streams aren’t data containers, Snowflake doesn’t support attaching a row access policy to the stream object itself. To enforce row-level access, you attach the policy to the underlying base table (or use a secure view that references the stream). This is why the statement describing this limitation is the best fit.

Row access policies filter data by applying predicates at read time, and they are attached to tables (or views) in Snowflake. Streams, however, are change-tracking objects tied to a base table and do not store data themselves. Because streams aren’t data containers, Snowflake doesn’t support attaching a row access policy to the stream object itself. To enforce row-level access, you attach the policy to the underlying base table (or use a secure view that references the stream). This is why the statement describing this limitation is the best fit.

Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy