You need to view the status of the data warehouse

Your network environment includes a Microsoft Visual Studio Team Foundation Server (TFS) 2012 server with
Microsoft SQL Server 2012 Reporting Services (SSRS)and Analysis Services (SSAS). Users report that the
data in their reports is out of date. You need to view the status of the data warehouse. You also needto view
the analysis database jobs and see when each last ran successfully.
What should you do?

Your network environment includes a Microsoft Visual Studio Team Foundation Server (TFS) 2012 server with
Microsoft SQL Server 2012 Reporting Services (SSRS)and Analysis Services (SSAS). Users report that the
data in their reports is out of date. You need to view the status of the data warehouse. You also needto view
the analysis database jobs and see when each last ran successfully.
What should you do?

A.
From any computer on the network:
· Browse to http://<servername> :8080/tfs/teamfoundation/administration/ v3.0/warehousecontrolservice.
asmx
· Invoke the GetProcessingStatus operation.

B.
From the TFS server:
· Browse to http ://<servername> : 8080/tfs/teamfoundation/administration/ v3.0/warehousecontrolservice.
asmx
· Invoke the GetProcessingStatus operation.

C.
From the Team Foundation Server Administration Console:
· Expand the application-tier tree.
· Select Reporting.
· View the Warehouse Database and Analysis ServicesDatabase status.

D.
From any computer on the network:
· Use SQL Server Management Studio.
· Connect to the SQL server that hosts the TFS databases.
· Query the TFS configuration database’s _LastUpdatedTime table.



Leave a Reply 2

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