Question 380
A warehouse query has several transformations that must be readable and reusable within one statement. What should the acceptance test demonstrate?
Explanation
Correct Answer
This directly verifies the intended outcome: CTEs structure complex SQL query logic. The accepted result is: The final query uses intermediate CTE results with correct rows and no persistent extra table required.
Incorrect Answers
Unnecessary tables add lifecycle overhead.
Names do not evaluate query expressions.
Comments aren't executable transformations.