Role 'DATA ENGINEER' owns the external stage. The security team mandates that ownership be transferred to ADMIN'. Post-transfer, which privileges are automatically revoked or changed for the 'DATA ENG

Question

Exhibit

Options

• AOption A
• BOption B
• COption C
• DOption D
• EOption E

• B
  4% (1)
• C
  14% (4)
• D
  7% (2)
• E
  75% (21)

Explanation

Ownership transfer in Snowflake revokes only the OWNERSHIP privilege from DATA ENGINEER - all other privileges previously granted to that role on the stage remain intact. This is Option E's core point: the role loses ownership but keeps any explicitly granted privileges (like READ or WRITE) that were assigned separately.

Why the distractors are wrong:

• Options suggesting all privileges are revoked are incorrect - Snowflake does not cascade-revoke non-ownership grants upon transfer.
• Options claiming DATA ENGINEER retains OWNERSHIP are wrong - ownership is singular and moves entirely to ADMIN.
• Options suggesting privileges granted by DATA ENGINEER to other roles are automatically revoked are incorrect by default; using GRANT OWNERSHIP ... REVOKE CURRENT GRANTS would do that, but it must be explicitly specified.

Memory tip: Think of Snowflake ownership like a deed to a house - transferring the deed means the previous owner loses title (OWNERSHIP), but any keys (access privileges) they were given by others still work until someone explicitly changes the locks. The new owner controls future access, not past grants.

No community discussion yet for this question.