• I'm a bit surprised to see the question asking for two answers (one about step 2, one about step 4), and only one answer option for step 2. Why not simply omit that part, present two answer options for step 4, and make us choose the correct one?

    (Or, better yet, provide more answer options for step 2).

    Or was the question changed to remove an error before I got here?


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/