Question

Which of the following is syntax for sp_add_collector_type procedure?

(a) core.sp_add_collector [ @collector_type_uid = ] ‘collector_type_uid’

(b) core.sp_add_collector_type [ @collector_type_uid = ].

(c) core.sp_add_collector_type [ @collector_type_uid = ] ‘collector_type_uid’

(d) none of the mentioned

This question was posed to me in a national level competition.

I'm obligated to ask this question of Management Data Warehouse in division Monitoring and Auditing of SQL Server

Answer 1

Correct option is (c) core.sp_add_collector_type [ @collector_type_uid = ] ‘collector_type_uid’

Explanation: core.sp_add_collector_type adds a new entry to the core.supported_collector_types view in the management data warehouse database.