ROLAP
简述ROLAP和MOLAP的区别。
点击查看答案
ROLAP是基于()的OLAP实现,而MOLAP是基于多维数据结构组织的OLAP实现。
You need to ensure the Client dimension is able to support new orders and new client records. Which setting should you configure?()A、ROLAP storageB、Lazy aggregationsC、Write Enabled propertyD、Unknown Member functionality
You need to design a storage mode for the ProductOrderStatus measure group. What should you do?()A、Use ROLAP for the Historical partition and MOLAP for the CurrentDay partition.B、Use MOLAP for the Historical partition and ROLAP for the CurrentDay partition.C、Use ROLAP for the Historical partition and Automatic MOLAP for the CurrentDay partition.D、Use HOLAP for the Historical partition and Low-latency MOLAP for the CurrentDay partition.
You design a Business Intelligence (BI) solution by using SQL Server 2008. The solution includes a SQL Server 2008 Analysis Services (SSAS) database. A cube in the database contains a large dimension named Customers. The database uses a data source that is located on a remote server. Each day, an application adds millions of fact rows and thousands of new customers. Currently, a full process of the cube takes several hours. You need to ensure that queries return the most recent customer data with the minimum amount of latency. Which cube storage model should you use?()A、 hybrid online analytical processing (HOLAP)B、 relational online analytical processing (ROLAP)C、 multidimensional online analytical processing (MOLAP)D、 automatic multidimensional online analytical processing (automatic MOLAP)
由于数据在物理上存储方式的不同,形成了OLAP的三种实现方式,即()。A、HOLAPB、MOLAPC、NOLAPD、ROLAP
问答题比较ROLAP与MOLAP在数据存储、技术及特点上的不同。