Posted by: Pdfprep
Post Date: October 26, 2020
You have 10 Microsoft SQL Server 2016 servers.
You deploy a management data warehouse named dwi. You configure dwi to gather all the performance data from the servers.
You configure a Data Collector on a SQL server named svi.
You query the data warehouse on dwi and discover that data from svi is unavailable.
You need to ensure that you can review the performance data from svi when you query dwi.
What should you do?
A . Start the SQL Server Agent service on SV1.
B . Execute the msdb.sp_syscollector_enable_collector stored procedure on DW1.
C . Start the SQL Server Agent service on DW1.
D . Execute the msdb. sp_syscollector_set_warehouse_connection_user Stored procedure on SV
Answer: C
Leave a Reply