YOU WANT TO ENFORCE A STANDARD NAMING CONVENTION FOR TABLES AND STO...

8. You want to enforce a standard naming convention for tables and stored

procedures. Your company has two SQL Server 2008 servers and 60 SQL Server

2005 servers. You need to use the same solution on all servers. What’s the best

way to do this in SQL Server 2005 and SQL Server 2008?

A. Create a DDL trigger for all servers

B. Use the performance data warehouse

C. Create DML triggers

D. Use the SQL Server 2008 Declarative Management Framework

The correct answer is A. This will work on SQL Server 2005 and SQL Server

2008 servers. While Answer D is correct, the DMF will allow you to perform

the task at hand only on SQL Server 2008 servers. Answer B has nothing to

do with enforcing naming conventions. D will not allow you to perform the

task of enforcing naming conventions.