Microsoft
70-465 · Question #148
Drag and Drop Question You need to create a job to automate some database maintenance tasks. Which code fragment should you use in each location in the command to complete one of the commands you will
Sign in or unlock 70-465 to reveal the answer and full explanation for question #148. The question stem and answer options stay visible for context.
Submitted by kavita_s· Mar 5, 2026Implement database maintenance plans and automate administrative tasks, including managing statistics for query optimizer performance in SQL Server
Question
Drag and Drop Question You need to create a job to automate some database maintenance tasks. Which code fragment should you use in each location in the command to complete one of the commands you will need to include in the job? To answer, drag the appropriate lines of code to the correct locations in the command. Each line of code may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. Answer:
Exhibit
Answer Area
Drag items
STATISTICSCONSTRAINTMEMBERWITH FULLSCANWITH SAMPLE 50 PERCENTWITH SAMPLE 1000 ROWSRECOMPUTENOCOMPUTENORECOMPUTE
Unlock 70-465 to see the answer
You've previewed enough free 70-465 questions. Unlock 70-465 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.
Topics
#UPDATE STATISTICS#SQL Server Database Maintenance#Query Optimization#T-SQL Jobs