What criteria does Snowflake use to determine the current role when initiating a session? (Select TWO).

Question

Options

• AIf a role was specified as part of the connection and that role has been granted to the Snowflake
• BIf no role was specified as part of the connection and a default role has been defined for the
• CIf no role was specified as part of the connection and a default role has not been set for the
• DIf a role was specified as part of the connection and that role has not been granted to the
• EIf a role was specified as part of the connection and that role has not been granted to the

• A
  87% (34)
• C
  3% (1)
• D
  8% (3)
• E
  3% (1)

Explanation

Snowflake evaluates role assignment at session start using this priority order: (A) If a role is explicitly specified in the connection parameters AND that role has been granted to the connecting user, that role is used as the session's current role. (B) If no role is specified in the connection but the user has a default role defined on their account, that default role is used. If neither condition is met (no role specified and no default role set), Snowflake falls back to the PUBLIC role. Options C–E describe fallback or invalid scenarios that do not take priority over A and B.

No community discussion yet for this question.