SnowPro Core Certification — Question 490

What is a characteristic of a role in Snowflake?

Answer options

• A. Roles cannot be granted to other roles.
• B. System-defined roles can be dropped.
• C. Privileges granted to system roles by Snowflake can be revoked.
• D. Privileges on securable objects can be granted and revoked to a role.

Correct answer: D

Explanation

The correct answer is D because roles in Snowflake can indeed have privileges on securable objects granted to or revoked from them. Option A is incorrect as roles can be granted to other roles, and option B is misleading since system-defined roles typically cannot be dropped. Option C is incorrect because privileges granted to system roles cannot be revoked.