Which Snowflake command is used to associate a public key with a user for key pair authentication?

CREATE USER ... WITH PUBLIC_KEY = '...'

SET USER ... PUBLIC_KEY = '...'

ALTER USER ... SET RSA_PUBLIC_KEY = '...'

A third-party BI tool needs to access Snowflake data using OAuth. The tool will be used by multiple users, and each user should see only the data they are authorized to see. What type of OAuth flow should be configured?

Implicit flow with a client that uses the user's session token.

Authorization code flow with a client that can act on behalf of users.

Client credentials flow with a service account that has broad access.

Resource owner password credentials flow with the user's Snowflake credentials.

A company is setting up SSO for Snowflake using Okta as the SAML identity provider. They want to ensure that users are prompted for MFA when they log in to Snowflake. What is the recommended way to configure this?

Configure MFA in Okta and ensure that the SAML assertion includes the MFA context.

Use Snowflake's built-in MFA by setting the authentication policy to require MFA for all users.

Enable MFA in Snowflake's authentication policy and set the SAML SSO to use the 'snowflake' login flow.

Set up a separate OAuth integration to handle MFA for SSO users.

Which command is used to enforce Multi-Factor Authentication (MFA) for a Snowflake user?

CREATE USER ... WITH MFA = TRUE

Snowflake SnowPro Advanced:Security Engineer

Domain 2Objective 2

Configure Authentication Including SSO, MFA, OAuth, and Key Pair SNOWPRO-ADVANCED-SECURITY-ENGINEER Practice Questions (Page 1)

Part of the Identity and Access Management domain, which makes up ~24% of our current practice bank.

17questions here

4free pages

5concepts

Questions 1–5

1foundation · medium
Which Snowflake command is used to associate a public key with a user for key pair authentication?
Select an answer first
2application · medium
A third-party BI tool needs to access Snowflake data using OAuth. The tool will be used by multiple users, and each user should see only the data they are authorized to see. What type of OAuth flow should be configured?
Select an answer first
3application · medium
A company is setting up SSO for Snowflake using Okta as the SAML identity provider. They want to ensure that users are prompted for MFA when they log in to Snowflake. What is the recommended way to configure this?
Select an answer first
4foundation · medium
Which command is used to enforce Multi-Factor Authentication (MFA) for a Snowflake user?
Select an answer first
5foundation · medium
Which Snowflake object is created to register an OAuth client?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to SNOWPRO-ADVANCED-SECURITY-ENGINEER

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Snowflake. “SNOWPRO-ADVANCED-SECURITY-ENGINEER” is a trademark of its owner, used for identification only.