You design a Business Intelligence (BI) solution by using SQL Server 2008. Several developers work on a large SQL Server 2008 Analysis Services (SSAS) project. Developers will work in parallel on the same cubes in the solution.
You need to manage the cube definitions to ensure that each developer’s work is not overwritten. You also need to ensure that conflicts can be easily resolved.
What should you recommend the developers to do?
A.
Work in online mode against a shared server.
B.
Work in disconnected mode and deploy the solution to a shared server frequently.
C.
Work in disconnected mode and check in the project to a source control system frequently.
D.
Work in online mode against a local server and synchronize the SSAS database with a shared server frequently.
Explanation:
Tip: "work is not overwritten" = "disconnected … check in"