SQL Database Concepts Question:
Download Questions PDF

Explain what is Analysis service repository?

Answer:

Each server running analysis service has a repository to store objects of the computer running Analysis Services an Analysis service repository stores the information about the cubes, dimensions and other objects of the analysis server. By default the repository is an .mdb database on the server computer where the analysis service is installed..

Download Basic SQL Server Interview Questions And Answers PDF

Previous QuestionNext Question
Do you know what is SQL Injection?Explain what is DBCC?