Microsoft
70-450 · Question #112
You administer a SQL Server 2008 infrastructure. Your company wants to enforce naming standards for the database objects. You need to design a solution to enforce naming standards by using the…
The correct answer is B. Create Policy-Based Management policies, and then distribute the policies by using a. See the full explanation below for the reasoning.
Question
You administer a SQL Server 2008 infrastructure. Your company wants to enforce naming standards for the database objects. You need to design a solution to enforce naming standards by using the minimum amount of administrative and programming efforts. What should you do?
Options
- AUse event notifications to handle the DDL events.
- BCreate Policy-Based Management policies, and then distribute the policies by using a
- CCreate DDL triggers for one of the instances, and then use SQL Server Management
- DCreate DDL triggers for one of the instances, and then use Microsoft SQL Server
How the community answered
(34 responses)- A6% (2)
- B79% (27)
- C12% (4)
- D3% (1)
Community Discussion
No community discussion yet for this question.