Answer: To separate user authentication from user access

The correct answer is C because federated authentication in Snowflake specifically separates user authentication from user access management. This allows organizations to use their existing identity providers (like Active Directory, Okta, etc.) for authentication while Snowflake handles authorization and access control. The community discussion strongly supports this with 100% consensus on answer C, and the referenced Snowflake documentation confirms that in a federated environment, authentication is handled externally while Snowflake manages access. Option A is incorrect because federated authentication doesn't inherently enhance security - it shifts authentication responsibility. Option B is wrong as real-time monitoring isn't the primary purpose. Option D is incorrect since federated authentication deals with identity providers, not direct database integration.

Author: LeetQuiz Editorial Team