nerdexam
Exams70-465Questions#148
MicrosoftMicrosoft

70-465 · Question #148

70-465 Question #148: Real Exam Question with Answer & 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 NORE

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:

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 PracticeBrowse All 70-465 Questions