Which of the following is best Practice and Caveat for Management Data – McqOptions

MCQOPTIONS

1.	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 <Query> elements
C.	Use a distributed server for the MDW database
D.	All of the mentioned
Answer» B. The XML parameters for a single T-SQL collection item can have multiple <Query> elements

Discussion

No Comment Found

Related MCQs

WHAT_DOES_COLLECTOR_TYPE_ID_STANDS_FOR_IN_THE_FOLLOWING_CODE_SNIPPET_??$
Which of the following is syntax for sp_add_collector_type procedure ?
Which of the following table is used in management data warehouse schema that is required for the Server Activity ?
____________ stores information about how the management data warehouse reports should group and aggregate performance counters.
Which of the following is best Practice and Caveat for Management Data Warehouse ?
Which of the following scenario favours cached mode ?
Which of the following mode allows for the collection and uploading of data to occur on demand ?
_________ introduces the Management Data Warehouse (MDW) to SQL Server Management Studio for streamlined performance troubleshooting.