Exam SnowPro Core All QuestionsBrowse all questions from this exam
Question 995

Which type of loop requires a BREAK statement to stop executing?

    Correct Answer: B

    A LOOP statement typically runs indefinitely until a BREAK statement is encountered. In contrast, FOR, REPEAT, and WHILE loops have inherent terminating conditions. The FOR loop iterates a set number of times, the REPEAT loop executes until a specific condition is met, and the WHILE loop continues as long as its condition remains true. Therefore, the correct answer is LOOP.

Discussion
0e504b5Option: B

https://docs.snowflake.com/en/developer-guide/snowflake-scripting/loops#terminating-a-loop BREAK is required in a LOOP but is not necessary in WHILE, FOR, and REPEAT.

GwoOption: B

B. BREAK is required in a LOOP but is not necessary in WHILE , FOR , and REPEAT .

ac1433bOption: D

I would say answer D.

tidzOption: B

https://docs.snowflake.com/en/developer-guide/snowflake-scripting/loops