Answer: 4 hours

The correct answer is C (4 hours) based on Snowflake documentation and community consensus. According to the official Snowflake documentation referenced in multiple community comments, a cached MFA token is valid for up to four hours when using the ALLOW_CLIENT_MFA_CACHING parameter. This duration allows users to minimize authentication prompts during multiple connection attempts within a reasonable timeframe while maintaining security. The community discussion shows 100% agreement on option C, with multiple users citing the official documentation and receiving upvotes for their accurate responses. Options A (1 hour), B (2 hours), and D (8 hours) are incorrect as they do not match the documented validity period specified by Snowflake.

Author: LeetQuiz Editorial Team