You work as a Database Administrator (DBA) for a company named ABC.com. The
company uses a Microsoft SQL Server 2012 infrastructure.
You plan to deploy a new SQL Server named ABC-Dev1. The server will be used by users
in the Development department for testing their applications.

You need to ensure that all stored procedures start with “usp_” to comply with the
company naming convention.
How can you ensure that stored procedures on ABC-Dev1 comply with the company
naming convention?

A.
By configuring a maintenance plan.

B.
By configuring a trigger.

C.
By using policy-based management.

D.
By enabling C2 Audit Mode.

Explanation: