Answer: Key-pair authentication

The question asks which authentication method requires access to a secure file stored exclusively on the user's local device. Key-pair authentication (Option B) fits this description perfectly, as it relies on a private key file that must be securely stored on the user's local machine and is never transmitted over the network. The community discussion shows strong consensus for Option B (75% of votes), with the top-voted comment explicitly confirming this answer. Option A (Password authentication) is incorrect because passwords are typically entered manually or stored in password managers, not as exclusive local files. Option C (MFA) involves additional verification methods but doesn't specifically require a local secure file. Option D (Federated authentication) relies on external identity providers and doesn't require exclusive local file storage. The comment suggesting Option A was based on incorrect reasoning that the question wasn't related to Snowflake, but key-pair authentication is indeed a supported Snowflake authentication method.

Author: LeetQuiz Editorial Team