Which of the following is presented as a limitation of using Row Access Policies?

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

Multiple Choice

Which of the following is presented as a limitation of using Row Access Policies?

Explanation:
Row-based filtering is applied by binding a policy to a specific table or view, so the policy isn’t automatically applied to objects created in the future. The limitation here is that you can’t use a future-grants mechanism to automatically attach a row access policy to new objects as they are created. Future grants pertain to privileges on future objects, not to the automatic binding of row access policies, so you must explicitly attach the policy to each new table or view (or set up an automated process to do so). The other options describe capabilities or scenarios that aren’t the limiting factor being highlighted.

Row-based filtering is applied by binding a policy to a specific table or view, so the policy isn’t automatically applied to objects created in the future. The limitation here is that you can’t use a future-grants mechanism to automatically attach a row access policy to new objects as they are created. Future grants pertain to privileges on future objects, not to the automatic binding of row access policies, so you must explicitly attach the policy to each new table or view (or set up an automated process to do so). The other options describe capabilities or scenarios that aren’t the limiting factor being highlighted.

Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy