Data warehousing OLAP

Data warehousing OLAP

1) Which includes the following?
1) Implementation of aggregation navigation logic.
2) Optimization for each DBMS back-end.
3) Additional tools and services.

A) Relational OLAP
B) Multidimensional OLAP
C) Hybrid OLAP
D) Specialized SQL servers
View Answer / Hide Answer


2) Which OLAP is a combination of both ROLAP and MOLAP?
A) Hybrid OLAP
B) Specialized SQL servers
C) Multidimensional OLAP
D) None of the above
View Answer / Hide Answer


3) Which performs aggregation on a data cube in any of the following ways?
1) By climbing up a concept hierarchy for a dimension
2) By dimension reduction

A) Roll-up
B) Drill-down
C) Slice and dice
D) Pivot
View Answer / Hide Answer


4) What is the reverse operation of roll-up. It is performed by either of the following ways:
1) By stepping down a concept hierarchy for a dimension
2) By introducing a new dimension

A) Roll-up
B) Drill-down
C) Slice and dice
D) Pivot
View Answer / Hide Answer


5) Which operation is also known as rotation. It rotates the data axes in view in order to provide an alternative presentation of data.
A) Roll-up
B) Drill-down
C) Slice and dice
D) Pivot
View Answer / Hide Answer


6) Which systems are used by knowledge workers such as executives, managers, and analysts?
A) OLAP
B) OLTP
C) Both A & B
D) None of the above
View Answer / Hide Answer


7) Which is based on Entity Relationship Model?
A) OLAP
B) OLTP
C) Both A & B
D) None of the above
View Answer / Hide Answer


8) OLAP database size is from 100 MB to 1 GB.
A) True
B) False
View Answer / Hide Answer


9) Relational OLAP architecture includes which of these components.
A) Database server
B) ROLAP server
C) Front-end tool
D) All mentioned above
View Answer / Hide Answer


10) These are disadvantages of
1) Poor query performance.
2) Some limitations of scalability depending on the technology architecture that is utilized.

A) Relational OLAP
B) Multidimensional OLAP
C) Hybrid OLAP
D) None of the above
View Answer / Hide Answer


11) What Uses sparse array to store datasets.
A) ROLAP
B) MOLAP
C) Both A & B
D) None of the above
View Answer / Hide Answer


12) DBMS facility is weak in ROLAP.
A) True
B) False
View Answer / Hide Answer


13) Which maintains a separate database for data cubes?
A) MOLAP
B) ROLAP
C) Both A & B
D) None of the above
View Answer / Hide Answer


14) Multidimensional OLAP (MOLAP) uses array-based multidimensional storage engines for multidimensional views of data.
A) Yes
B) No
View Answer / Hide Answer


15) Which server provide advanced query language and query processing support for SQL queries over star and snowflake schemas in a read-only environment.
A) Relational OLAP
B) Multidimensional OLAP
C) Hybrid OLAP
D) Specialized SQL servers
View Answer / Hide Answer


16) What selects one particular dimension from a given cube and provides a new sub-cube.
A) Dice
B) Slice
C) Rotate
D) None of the above
View Answer / Hide Answer


17) Dice selects two or more dimensions from a given cube and provides a new sub-cube.
A) True
B) False
View Answer / Hide Answer


18) Abbreviate the term OLTP.
A) Online Transactional Processing
B) Object Transformation Processing
C) Object Transactional Processing
D) Online Transformation Process
View Answer / Hide Answer


19) Which contains current information that is required to run the business?
A) Data warehouse
B) Operational database
C) Both A & B
D) None of the above
View Answer / Hide Answer


20) Query Manager is responsible for directing the queries to the suitable tables.
A) True
B) False
View Answer / Hide Answer


21) Multidimensional OLAP is faster than Relational OLAP.
A) True
B) False
View Answer / Hide Answer


22) How many fact tables are there in a star schema?
A) 1
B) 2
C) 3
D) 4
View Answer / Hide Answer


23) Data Warehousing involves,
A) Data cleaning
B) Data integration
C) Data consolidations
D) All mentioned above
View Answer / Hide Answer


24) Abbreviate the term OLAP.
A) Online Analysis Processing
B) Online Analytical Processing
C) Online Analysis Performance
D) Online Analytical Performance
View Answer / Hide Answer


25) Which servers allow to store large data volumes of detailed information?
A) Hybrid OLAP
B) Relational OLAP
C) Multidimensional OLAP
D) None of the above
View Answer / Hide Answer


26) When roll-up is performed, one or more dimensions from the data cube are removed.
A) True
B) False
View Answer / Hide Answer


27) OLTP systems are used by clerks, DBAs, or database professionals.
A) True
B) False
View Answer / Hide Answer


28) Which involves historical processing of information?
A) Operational Database OLTP
B) Data warehouse OLAP
C) Both A & B
D) None of the above
View Answer / Hide Answer


29) MOLAP includes which of these components:
A) Database server
B) MOLAP server
C) Front-end tool
D) All mentioned above
View Answer / Hide Answer


30) From the following give the disadvantage of MOLAP.
A) MOLAP allows fastest indexing to the pre-computed summarized data.
B) Helps the users connected to a network who need to analyze larger, less-defined data.
C) Easier to use, therefore MOLAP is suitable for inexperienced users.
D) The storage utilization may be low if the data set is sparse
View Answer / Hide Answer