Valid 70-761 Dumps shared by ExamDiscuss.com for Helping Passing 70-761 Exam! ExamDiscuss.com now offer the newest 70-761 exam dumps, the ExamDiscuss.com 70-761 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com 70-761 dumps with Test Engine here:
You are building a stored procedure that will update data in a table named Table1 by using a complex query as the data source. You need to ensure that the SELECT statement in the stored procedure meets the following requirements: Data being processed must be usable in several statements in the stored procedure. Data being processed must contain statistics. What should you do?
Correct Answer: B
Explanation/Reference: Explanation: Temp Tables... Are real materialized tables that exist in tempdb Have dedicated stats generated by the engine Can be indexed Can have constraints Persist for the life of the current CONNECTION Can be referenced by other queries or subproce Incorrect Answers: A: CTEs do not have dedicated stats. They rely on stats on the underlying objects C: Unlike a derived table, a CTE can be self-referencing and can be referenced multiple times in the same query. References: https://technet.microsoft.com/en-us/library/ms190766(v=sql.105).aspx https://dba.stackexchange.com/questions/13112/whats-the-difference-between-a-cte-and-a-temp-table