Which features should you identify?

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.

Select and Place:

View Answer

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.