Explanation:You should not change the database name after creation, because all of the jobs created to manage the database collection refer to the database by the original name and will generate errors if the name is changed. 6. Which of the following is best Practice and Caveat for Management Data Warehouse ?
A. Use a centralized server for the MDW database
B. The XML parameters for a single T-SQL collection item can have multiple elements
C. Use a distributed server for the MDW database
D. All of the mentioned
Answer:A
Explanation:You should not change the database name after creation, because all of the jobs created to manage the database collection refer to the database by the original name and will generate errors if the name is changed. 6. Which of the following is best Practice and Caveat for Management Data Warehouse ?
A. Use a centralized server for the MDW database B. The XML parameters for a single T-SQL collection item can have multiple elements C. Use a distributed server for the MDW database D. All of the mentioned
Explanation:Centralized server allows you to use a single point for viewing reports for multiple instances. 7. ____________ stores information about how the management data warehouse reports should group and aggregate performance counters.