What should you do?

You have 10 Microsoft SQL Server 2016 servers.
You deploy a management data warehouse named DW1. You configure DW1 to gather all the performance data from the servers.
You configure a Data Collector on a SQL server named SV1.
You query the data warehouse on DW1 and discover that data from SV1 is unavailable.
You need to ensure that you can review the performance data from SV1 when you query DW1.
What should you do?
A. Start the SQL Server Agent service on DW1.
B. Execute the msdb.sp_syscollector_set_warehouse_connection_user stored procedure on SV1.
C. Execute the msdb.sp_syscollector_enable_collector stored procedure on DW1.
D. Start the SQL Server Agent service on SV1.

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.