A user can change session parameters using which roles?

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

Multiple Choice

A user can change session parameters using which roles?

Explanation:
Changing session parameters affects how Snowflake runs commands in your current session (things like time zone, date formats, and how metadata is applied to your queries). Access to alter these settings is governed by who can manage session-level configurations. The roles that can do this are the broad, high-privilege account roles (ACCOUNTADMIN and SECURITYADMIN) and any user who has been granted the specific privilege to alter session settings. Therefore, the ability to change session parameters comes from either having one of the top admin roles or having the necessary privilege granted to your user. The other options miss one of these essential paths: a plain user role without the privilege cannot alter session parameters, and excluding one of the admin roles omits a valid way to adjust session behavior across the account.

Changing session parameters affects how Snowflake runs commands in your current session (things like time zone, date formats, and how metadata is applied to your queries). Access to alter these settings is governed by who can manage session-level configurations. The roles that can do this are the broad, high-privilege account roles (ACCOUNTADMIN and SECURITYADMIN) and any user who has been granted the specific privilege to alter session settings. Therefore, the ability to change session parameters comes from either having one of the top admin roles or having the necessary privilege granted to your user. The other options miss one of these essential paths: a plain user role without the privilege cannot alter session parameters, and excluding one of the admin roles omits a valid way to adjust session behavior across the account.

Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy