Answer: Federated authentication, Key-pair authentication, OAuth

The question asks for three valid user authentication methods in Snowflake. Based on the community discussion with strong consensus (100% agreement on BDE) and reference to Snowflake documentation, the correct answers are B (Federated authentication), D (Key-pair authentication), and E (OAuth). Federated authentication allows integration with external identity providers, Key-pair authentication uses public-private key pairs for programmatic access, and OAuth enables token-based authentication. Option A (SCIM) is incorrect as it's for user provisioning/management, not authentication. Option C (TLS 1.2) is a transport security protocol, not an authentication method. Option F (OCSP authentication) is not a standard Snowflake authentication method.

Author: LeetQuiz Editorial Team