Examice

Exam SnowPro Core All QuestionsBrowse all questions from this exam

Question 583

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

If a role was specified as part of the connection and that role has been granted to the Snowflake user, the specified role becomes the current role.

If no role was specified as part of the connection and a default role has been defined for the Snowflake user, that role becomes the current role.

If no role was specified as part of the connection and a default role has not been set for the Snowflake user, the session will not be initiated and the log in will fail.

If a role was specified as part of the connection and that role has not been granted to the Snowflake user, it will be ignored and the default role will become the current role.

If a role was specified as part of the connection and that role has not been granted to the Snowflake user, the role is automatically granted and it becomes the current role.

Correct Answer: A, B

When initiating a session in Snowflake, if a role was specified as part of the connection and that role has been granted to the Snowflake user, the specified role becomes the current role. Additionally, if no role was specified as part of the connection and a default role has been defined for the Snowflake user, that role becomes the current role. These criteria ensure proper role assignment that aligns with the user's permissions and configurations.

Discussion

KarBiswa

the answer is correct https://docs.snowflake.com/en/user-guide/security-access-control-overview#label-access-control-role-enforcement:~:text=If%20a%20role,PUBLIC%20is%20used.

majewOptions: AD

what about D?

MultiCloudIronManOptions: AB

Correct