Microsoft
70-459 · Question #60
70-459 Question #60: Real Exam Question with Answer & Explanation
Sign in or unlock 70-459 to reveal the answer and full explanation for question #60. The question stem and answer options stay visible for context.
Question
You execute usp_SelectEmployeesByName multiple times, passing strings of varying lengths to @LastName. You discover that usp_SelectEmployeesByName uses inefficient execution plans. You need to update usp_SelectEmployeesByName to ensure that the most efficient execution plan is used. What should you add at line 31 of StoredProcedures.sql?
Options
- AOPTION (ROBUST plan)
- BOPTION (OPTIMIZE FOR UNKNOWN)
- COPTION (KEEP PLAN)
- DOPTION (KEEPFIXED PLAN)
Unlock 70-459 to see the answer
You've previewed enough free 70-459 questions. Unlock 70-459 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.