Q.What are SQL Server Analysis Services cubes?
A.In analysis services, cube is the basic unit of storage. A cube has data collected from various sources that enables faster execution of queries. Cubes have dimensions and measures.Example: A cube storing employee details may have dimensions like date of joining and name which helps in faster queries requesting for finding employees who joined in a particular week.
A.In analysis services, cube is the basic unit of storage. A cube has data collected from various sources that enables faster execution of queries. Cubes have dimensions and measures.Example: A cube storing employee details may have dimensions like date of joining and name which helps in faster queries requesting for finding employees who joined in a particular week.
Q.Explain the purpose of synchronization feature provided in Analysis Services 2005.
A.Synchronization feature is used to copy database from one source server to a destination server. While the synchronization is in progress, users can still browse the cubes. Once the synchronization is complete, the user is redirected to the new Synchronized database.
A.Synchronization feature is used to copy database from one source server to a destination server. While the synchronization is in progress, users can still browse the cubes. Once the synchronization is complete, the user is redirected to the new Synchronized database.
No comments:
Post a Comment