Exam 70-764 topic 1 question 311 discussion

Actual exam question from Microsoft's 70-764

Question #: 311
Topic #: 1

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.

Show Suggested Answer

Suggested Answer: C 🗳️
sp_syscollector_enable_collector enables the data collector.
References: https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-syscollector-enable-collector-transact-sql

by TheSwedishGuy at Feb. 4, 2020, 12:56 p.m.

Comments

Submit Cancel

TheSwedishGuy

5 years, 5 months ago

DW queries requires data collector.

upvoted 1 times

...