Question

Point out the wrong statement.

(a) The Data Collection is performed primarily through SSIS packages that control the collection frequency on the target

(b) You should  change the database name after creation

(c) Do not change any of the job specifications for the data collection and upload jobs

(d) None of the mentioned

I have been asked this question by my college professor while I was bunking the class.

I want to ask this question from Management Data Warehouse in chapter Monitoring and Auditing of SQL Server

Answer 1

Correct choice is (b) You should  change the database name after creation

To elaborate: 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.