Answer: REPEAT

The question asks which loop type iterates until a condition becomes true. In Snowflake scripting, the REPEAT loop (also known as DO...WHILE in other languages) executes the loop body first and then checks the condition. This means it always runs at least once and continues iterating until the specified condition evaluates to TRUE. In contrast, WHILE loops check the condition before execution and only run if the condition is initially true. FOR loops iterate a fixed number of times based on a counter, and LOOP is not a standard loop type in Snowflake. The community discussion strongly supports C (REPEAT) with 93% consensus and multiple verified answers, with detailed explanations confirming that REPEAT loops guarantee at least one execution and continue until the condition becomes true.

Author: LeetQuiz Editorial Team