nerdexam
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…

The correct answer is STATISTICS; WITH FULLSCAN; NORECOMPUTE. The correct arrangement builds a valid UPDATE STATISTICS command with NORECOMPUTE option, which follows the syntax: UPDATE STATISTICS [table] [statistics_name] WITH FULLSCAN, NORECOMPUTE. FULLSCAN scans all rows for maximum accuracy (ideal for database maintenance jobs), and…

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

70-465 question #148 exhibit

Answer Area

Drag items

STATISTICSCONSTRAINTMEMBERWITH FULLSCANWITH SAMPLE 50 PERCENTWITH SAMPLE 1000 ROWSRECOMPUTENOCOMPUTENORECOMPUTE

Correct arrangement

  • STATISTICS
  • WITH FULLSCAN
  • NORECOMPUTE

Explanation

The correct arrangement builds a valid UPDATE STATISTICS command with NORECOMPUTE option, which follows the syntax: UPDATE STATISTICS [table] [statistics_name] WITH FULLSCAN, NORECOMPUTE. FULLSCAN scans all rows for maximum accuracy (ideal for database maintenance jobs), and NORECOMPUTE disables automatic future statistics updates, giving the DBA manual control over when statistics are refreshed - a common database maintenance pattern.

Topics

#UPDATE STATISTICS#SQL Server Database Maintenance#Query Optimization#T-SQL Jobs

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-465 Practice