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.
Bạn đang xem 8. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P141 DOC