Question 40
An object owner wants to delegate SELECT permission in a regular schema to an audit role. The team proposes this action: Use the object owner's discretionary grant authority, subject to Snowflake privilege rules. Why should that action address the stated requirement?
Explanation
Correct Answer
Discretionary access control lets an object's owner grant allowed privileges in a regular schema. This explains the proposed action: use the object owner's discretionary grant authority, subject to Snowflake privilege rules.
Incorrect Answers
Row access policies control which rows are visible based on configured conditions and context. That rationale explains apply a row access policy to the protected table or view. It does not establish the mechanism needed here: discretionary access control lets an object's owner grant allowed privileges in a regular schema.
Alerts can evaluate conditions and initiate supported actions or notifications. That rationale explains create an appropriate Snowflake alert or notification mechanism for the measurable condition. It does not establish the mechanism needed here: discretionary access control lets an object's owner grant allowed privileges in a regular schema.
Lineage reveals upstream and downstream relationships used for governance and change impact analysis. That rationale explains use available data lineage information to inspect dependencies among governed objects. It does not establish the mechanism needed here: discretionary access control lets an object's owner grant allowed privileges in a regular schema.





SnowPro Core COF-C03 Practice Tests