To list all privileges and roles that a role named PYTHON_DEV_ROLE has, which command is most appropriate?

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

Multiple Choice

To list all privileges and roles that a role named PYTHON_DEV_ROLE has, which command is most appropriate?

To see what privileges a specific role has, you use the SHOW GRANTS TO ROLE statement. It directly asks Snowflake to list all privileges granted to that role, making it the exact tool for auditing what a role can do.

Using the command SHOW GRANTS TO ROLE PYTHON_DEV_ROLE follows the proper syntax: SHOW GRANTS TO ROLE . That’s why it’s the best choice here. The other phrasings don’t match Snowflake’s syntax and wouldn’t reliably return the role’s privileges.

To list all privileges and roles that a role named PYTHON_DEV_ROLE has, which command is most appropriate?

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

To list all privileges and roles that a role named PYTHON_DEV_ROLE has, which command is most appropriate?

Get the latest from Passetra