Business Intelligence Final Exam UPDATED
ACTUAL Exam Questions and CORECT
Answers
Concept of location hierarchy - CORRECT ANSWER Street -> city -> state -> country
Starnet model - CORRECT 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 - CORRECT ANSWER selection of relevant data
Business query - CORRECT ANSWER end user perspective
Data warehouse design approaches/methods - CORRECT ANSWER Top down approach,
bottom up approach, combined approach, waterfall method, spiral method
ROLAP meaning - CORRECT ANSWER Relational online analytical processing
MOLAP meaning - CORRECT ANSWER Multidimensional Online Analytical Processing
HOLAP meaning - CORRECT ANSWER Hybrid online analytical processing
ROLAP uses - CORRECT ANSWER Great scalability, intermediate server between client
and back-end server, optimized for DBMS back0end and use DBMS to manage data
MOLAP uses - CORRECT 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 - CORRECT 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 - CORRECT 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 - CORRECT 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 - CORRECT ANSWER collect data, provide simple reports
for aggregations and charts. slice and dice functions are allowed.
3 kinds of data warehousing - CORRECT ANSWER Information processing
Analytical processing
Data mining
Information processing (4) - CORRECT ANSWER Queries
Charts
Crosstab reports
Tables
OLAP operations (4) - CORRECT ANSWER Slice and dice
drill down
roll up
pivot
ACTUAL Exam Questions and CORECT
Answers
Concept of location hierarchy - CORRECT ANSWER Street -> city -> state -> country
Starnet model - CORRECT 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 - CORRECT ANSWER selection of relevant data
Business query - CORRECT ANSWER end user perspective
Data warehouse design approaches/methods - CORRECT ANSWER Top down approach,
bottom up approach, combined approach, waterfall method, spiral method
ROLAP meaning - CORRECT ANSWER Relational online analytical processing
MOLAP meaning - CORRECT ANSWER Multidimensional Online Analytical Processing
HOLAP meaning - CORRECT ANSWER Hybrid online analytical processing
ROLAP uses - CORRECT ANSWER Great scalability, intermediate server between client
and back-end server, optimized for DBMS back0end and use DBMS to manage data
MOLAP uses - CORRECT 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 - CORRECT 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 - CORRECT 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 - CORRECT 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 - CORRECT ANSWER collect data, provide simple reports
for aggregations and charts. slice and dice functions are allowed.
3 kinds of data warehousing - CORRECT ANSWER Information processing
Analytical processing
Data mining
Information processing (4) - CORRECT ANSWER Queries
Charts
Crosstab reports
Tables
OLAP operations (4) - CORRECT ANSWER Slice and dice
drill down
roll up
pivot
