Microsoft
70-433 · Question #79
70-433 Question #79: Real Exam Question with Answer & Explanation
Sign in or unlock 70-433 to reveal the answer and full explanation for question #79. The question stem and answer options stay visible for context.
Question
You need to determine the result of executing this code segment. DECLARE @RangeStart INT = 0; DECLARE @RangeEnd INT = 10000; DECLARE @RangeStep INT = 1; WITH NumberRange(ItemValue) AS ( SELECT ItemValue FROM (SELECT @RangeStart AS ItemValue) AS t UNION ALL SELECT ItemValue + @RangeStep FROM NumberRange WHERE ItemValue < @RangeEnd) SELECT ItemValue FROM NumberRange OPTION (MAXRECURSION 100) Which result will be returned?
Options
- A101 rows will be returned with no error.
- B10,001 rows will be returned with no error.
- C101 rows will be returned with a maximum recursion error.
- D10,001 rows will be returned with a maximum recursion error.
Unlock 70-433 to see the answer
You've previewed enough free 70-433 questions. Unlock 70-433 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.