Business Intelligence Final Exam 2025
Questions and Answers
Concept of location hierarchy - --Answer --Street -> city -> state -> country
Starnet model - --Answer --A visualization with a central point, surrounded
by dimension tables. Represents multidimensional data. Easy to use, great
scalability. Use for sales, customer, or product analysis
Top-down - --Answer --selection of relevant data
Business query - --Answer --end user perspective
Data warehouse design approaches/methods - --Answer --Top down
approach, bottom up approach, combined approach, waterfall method, spiral
method
ROLAP meaning - --Answer --Relational online analytical processing
MOLAP meaning - --Answer --Multidimensional Online Analytical
Processing
....COPYRIGHT ©️ 2025 ALL RIGHTS RESERVED...TRUSTED & VERIFIED 1
, HOLAP meaning - --Answer --Hybrid online analytical processing
ROLAP uses - --Answer --Great scalability, intermediate server between
client and back-end server, optimized for DBMS back0end and use DBMS to
manage data
MOLAP uses - --Answer --Multidimensional view of data through arrays of
data, map directly into data cubes, allows indexing and faster searching, employ
compression technology for data storage
HOLAP uses - --Answer --Hybrid of MOLAP and ROLAP, greater
scalability (ROLAP), faster computation (MOLAP), simply more advantages since
each part of the system will perform what it does best
Hypothesis-driven exploration - --Answer --Discoverer uses their own
intuition, large number of interesting patterns, manual data discovery is
complicated, high level aggregation gives indication of abnormalities, easy to
overlook interesting patterns
Discovery driven exploration - --Answer --Data exceptions guide discovery,
exceptions in data cube are investigated, coloring is used to highlight the degree of
exception, efficient use of data cubes
Data warehousing to data mining - --Answer --collect data, provide simple
reports for aggregations and charts. slice and dice functions are allowed.
....COPYRIGHT ©️ 2025 ALL RIGHTS RESERVED...TRUSTED & VERIFIED 2
Questions and Answers
Concept of location hierarchy - --Answer --Street -> city -> state -> country
Starnet model - --Answer --A visualization with a central point, surrounded
by dimension tables. Represents multidimensional data. Easy to use, great
scalability. Use for sales, customer, or product analysis
Top-down - --Answer --selection of relevant data
Business query - --Answer --end user perspective
Data warehouse design approaches/methods - --Answer --Top down
approach, bottom up approach, combined approach, waterfall method, spiral
method
ROLAP meaning - --Answer --Relational online analytical processing
MOLAP meaning - --Answer --Multidimensional Online Analytical
Processing
....COPYRIGHT ©️ 2025 ALL RIGHTS RESERVED...TRUSTED & VERIFIED 1
, HOLAP meaning - --Answer --Hybrid online analytical processing
ROLAP uses - --Answer --Great scalability, intermediate server between
client and back-end server, optimized for DBMS back0end and use DBMS to
manage data
MOLAP uses - --Answer --Multidimensional view of data through arrays of
data, map directly into data cubes, allows indexing and faster searching, employ
compression technology for data storage
HOLAP uses - --Answer --Hybrid of MOLAP and ROLAP, greater
scalability (ROLAP), faster computation (MOLAP), simply more advantages since
each part of the system will perform what it does best
Hypothesis-driven exploration - --Answer --Discoverer uses their own
intuition, large number of interesting patterns, manual data discovery is
complicated, high level aggregation gives indication of abnormalities, easy to
overlook interesting patterns
Discovery driven exploration - --Answer --Data exceptions guide discovery,
exceptions in data cube are investigated, coloring is used to highlight the degree of
exception, efficient use of data cubes
Data warehousing to data mining - --Answer --collect data, provide simple
reports for aggregations and charts. slice and dice functions are allowed.
....COPYRIGHT ©️ 2025 ALL RIGHTS RESERVED...TRUSTED & VERIFIED 2
