nerdexam
Microsoft

70-465 · Question #36

Drag and Drop Question You plan to deploy a database by using SQL Server 2014. Your company identifies the following requirements for the database: - The name of all stored procedures must start…

The correct answer is Policy-Based Management; a maintenance plan. Policy-Based Management is the correct feature for enforcing naming conventions on stored procedures because it allows administrators to define and enforce policies (such as naming standards) across SQL Server objects, automatically checking or preventing non-compliant object…

Submitted by eva_at· Mar 5, 2026Manage and Maintain SQL Server Databases - including implementing database policies, automating maintenance tasks, and understanding SQL Server feature capabilities

Question

Drag and Drop Question You plan to deploy a database by using SQL Server 2014. Your company identifies the following requirements for the database: - The name of all stored procedures must start with "usp_"always. - All distribution statistics must be updated daily. You need to identify which feature must be used to meet each database requirement. Which features should you identify? To answer, drag the appropriate feature to the correct database requirement in the answer area. Answer:

Exhibit

70-465 question #36 exhibit

Answer Area

Drag items

change data capturethe CHECK constraintExtended Eventa maintenance planPolicy-Based Management

Correct arrangement

  • Policy-Based Management
  • a maintenance plan

Explanation

Policy-Based Management is the correct feature for enforcing naming conventions on stored procedures because it allows administrators to define and enforce policies (such as naming standards) across SQL Server objects, automatically checking or preventing non-compliant object names. A maintenance plan is the correct feature for updating distribution statistics daily because maintenance plans use SQL Server Agent jobs to schedule and automate routine database maintenance tasks, including the 'Update Statistics' task, on a defined schedule.

Topics

#Policy-Based Management#SQL Server Maintenance Plans#Database Administration#SQL Server 2014

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-465 Practice