Valid 70-765 Dumps shared by ExamDiscuss.com for Helping Passing 70-765 Exam! ExamDiscuss.com now offer the newest 70-765 exam dumps, the ExamDiscuss.com 70-765 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com 70-765 dumps with Test Engine here:
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets stated goals. You manage a Microsoft SQL Server environment with several databases. You need to ensure that queries use statistical data and do not initialize values for local variables. Solution: You enable the QUERY_OPTIMIZER_HOTFIXES option for the databases. Does the solution meet the goal?
Correct Answer: B
QUERY_OPTIMIZER_HOTFIXES = { ON | OFF | PRIMARY } enables or disables query optimization hotfixes regardless of the compatibility level of the database. This is equivalent to Trace Flag 4199. References:https://msdn.microsoft.com/en-us/library/mt629158.aspx