Which command assigns the read_only_rl role to the SYSADMIN role?

Master the SnowPro Advanced Architect Test with flashcards, multiple-choice questions, and detailed explanations. Prepare thoroughly for your certification!

Multiple Choice

Which command assigns the read_only_rl role to the SYSADMIN role?

Explanation:
In Snowflake, you control access by attaching roles to other roles, so privileges flow from the granted role to the grantee role. The correct command uses the GRANT ROLE syntax to attach one role to another. GRANT ROLE read_only_rl TO ROLE SYSADMIN; This assigns the read_only_rl role to SYSADMIN, meaning SYSADMIN inherits all privileges that read_only_rl has. The other options don’t perform this delegation: creating a role just makes a new role; altering a role with a grant isn’t valid syntax for granting another role; and adding a comment doesn’t grant any privileges.

In Snowflake, you control access by attaching roles to other roles, so privileges flow from the granted role to the grantee role. The correct command uses the GRANT ROLE syntax to attach one role to another.

GRANT ROLE read_only_rl TO ROLE SYSADMIN;

This assigns the read_only_rl role to SYSADMIN, meaning SYSADMIN inherits all privileges that read_only_rl has. The other options don’t perform this delegation: creating a role just makes a new role; altering a role with a grant isn’t valid syntax for granting another role; and adding a comment doesn’t grant any privileges.

Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy