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: