Answer: Privileges on securable objects can be granted and revoked to a role.

Option D is correct because roles in Snowflake can be granted and revoked privileges on securable objects like databases, schemas, and tables, which is a fundamental characteristic of role-based access control. Option A is incorrect as roles can be granted to other roles, enabling role hierarchies. Option B is incorrect because system-defined roles (e.g., ACCOUNTADMIN) cannot be dropped, as confirmed by Snowflake documentation and community consensus. Option C is incorrect since privileges granted to system roles by Snowflake (e.g., built-in privileges of SYSADMIN) cannot be revoked, only custom grants can be modified. The community discussion, including upvoted comments referencing official documentation, strongly supports D as the only correct answer, with clear evidence against A, B, and C.

Author: LeetQuiz Editorial Team