DWH Interview Question and Answers

37. Define MDBMS?
 
  • OLAP server, also known as Multi Dimensional Database Management System (MDBMS) server.
  • This is a proprietary database management system which stores the multidimensional data in 'multidimensional cubes' and contains the data in summarized form, based on the type of reports required.
 
Your Name Your Email-ID
Your Answer
38. What are the advantages of Rolap?
 
  • It provides a lot of flexibility because ad hoc queries can be given. Also, there is no limit on the number of dimensions.
  • The tools are less expensive.
  • RDBMS requires less storage.
  • The network bandwidth requirements will be low because only the results are sent to the client over the network.
 
Your Name Your Email-ID
Your Answer
39. Define HOLAP?
 
  • Hybrid OLAP (HOLAP) servers combine both technologies, benefiting from the storage capacity of ROLAP and the processing capabilities of MOLAP.
  • For example, a HOLAP server may store large volumes of detailed data in a relational database, while aggregations are kept in a separate MOLAP store.
 
Your Name Your Email-ID
Your Answer
40. What o you mean by data source view?
 
  • Once the data source objects have been created, a data source view (DSV) allows one to define the relational schema that will be used in the Analysis Services database.
  • This schema is derived from the schemas of the various data sources. Cubes and dimensions are created from data source views rather than directly from data source objects.
 
Your Name Your Email-ID
Your Answer
12345678910 Page 10 of 10