You are a professional level SQL Sever 2008 Database Administrator in an international corporation
named Wiikigo. You are experienced in managing databases in an enterprise-level organization, optimizing
and sustaining the database life cycle.
In the company, your job is to implement solutions on security, troubleshooting, deployment and optimization.
A SQL Server 2008 infrastructure is managed by you. Your company wants to enforce naming standards for the database objects.
A solution should be designed by you to enforce naming standards, and the least amount of administrative and programming efforts should be utilized.
Which action should you perform?
A.
Policy-Based Management policies should be created, and then the policies should be distributed by utilizing a configuration server.
B.
Event notifications should be utilized to handle the DDL events.
C.
DDL triggers should be created for one of the instances, and then SQL Server Management Objects (SMO) should be utilized to script the definition of the DDL triggers. At last, the script should be run by utilizing Microsoft Windows PowerShell on all instances.
D.
DDL triggers should be created for one of the instances, and then Microsoft SQL Server Management Studio (SSMS) should be utilized to script the definition of the DDL triggers. At last, the script should be run on all instances by utilizing the registered server??s node from SSMS.