You design a Business Intelligence (BI) solution by using SQL Server 2008. You plan to deploy a new database to the SQL Server 2008 Analysis Services (SSAS) instance. The database contains a cube…

You design a Business Intelligence (BI) solution by using SQL Server 2008. You plan to deploy a new database to the SQL Server 2008 Analysis Services (SSAS) instance. The database contains a cube. The cube contains three Type 1 slowly changing dimensions. The database is updated throughout the day by adding 5,000 rows of data every hour. You need to ensure that the cube always contains up-to-date data. You also need to ensure that the users can access the cube during cube processing. What should you do?