DRAG DROP
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:

Explanation:

* Policy-Based Management
Each Stored Procedure that are created and that will be created has to have prefix “USP_”.
* Maintenance plans create a workflow of the tasks required to make sure that your
database is optimized, regularly backed up, and free of inconsistencies.