nerdexam
SnowflakeSnowflake

SOL-C01 · Question #69

SOL-C01 Question #69: Real Exam Question with Answer & Explanation

The correct answer is E: Option E. When ownership is transferred, the previous owner (in this case, the 'DATA ENGINEER role) loses the 'OWNERSHIP' privilege. Any other privileges previously granted to the role remain unless explicitly revoked. The ownership transfer itself does not automatically revoke other privi

Snowflake Account and Security

Question

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 ENGINEER role?

Options

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

Explanation

When ownership is transferred, the previous owner (in this case, the 'DATA ENGINEER role) loses the 'OWNERSHIP' privilege. Any other privileges previously granted to the role remain unless explicitly revoked. The ownership transfer itself does not automatically revoke other privileges. The ownership is implicitly revoked. But all other grants (USAGE etc) will remain.

Topics

#Ownership#Role-Based Access Control (RBAC)#Privilege Management#Security

Community Discussion

No community discussion yet for this question.

Full SOL-C01 PracticeBrowse All SOL-C01 Questions