FlexiQuiz - Data Warehousing : Quiz 22

For full functionality of this site it is necessary to enable JavaScript.

Submitting ...

1. What is not true?

A dimension that has no context except its primary key.

Every dimension (table) has not a primary key.

A hierarchical dimension (table) could be normalized.

Each dimension has multiple hierarchies

2. What is the name of data that can be modeled as dimension attributes and measure attributes?

Single dimensional

Multidimensional

Measured

Single dimensional Dimensional

3. What is not a characteristic of OLAP system?

The OLAP systems are designed to be subject-oriented.

The OLAP systems view enterprise information as multidimensional

The OLAP systems are not designed for Decision makers.

The OLTP systems normally deal only with the current status of information.

4. measurements that result from an operational activity carried out by an organization is Conformed Dimension

FALSE

TRUE

5. normalization of the dimension tables are in the _______________ schema,

All of the above

Snowflake

Fact constellations

Star

6. Purpose data warehousing is

Faster decision making

Better decision making

A and B

only enabling the knowledge worker only

7. From the architecture point of view, there are three data warehouse models:
the enterprise warehouse, the data mart, and the virtual warehouse.
Below statment discribe about virtual warehouse.
select most correct statement/s from the statements,

A) A virtual warehouse is a set of views over operational databases.

B) For efficient query processing, only some of the possible summary views may
be materialized.

C) A virtual warehouse is hard to build but requires excess capacity on operational
database servers.

only B, C true

only A true

A, B, C true

All false

only A, B true

8. Check whether the given statement is TRUE or FALSE.
"The OLAP tool should not provide transparency to the input data for the users"

TRUE

FALSE

9. A data warehouse is always a physically separate store of data transformed from
the application data found in the operational environment. Due to this separation,
a data warehouse does not require transaction processing, recovery, and
concurrency control mechanisms. It usually requires only two operations
in data accessing:__________________ and ___________________.

A) initial loading of data

B) encryption of data

C) sequential access of data

D) access of data

A and D

A and B

C and D

B and C

A and C

10. A design tool that supports an agile bottom-up delivery focusing on one process at a time

Online Analytical Processing (OLAP)

data mart tool

query driven approach

Enterprise DWH Bus Matrix

Submit

Data Warehousing : Quiz 22

Powered by FlexiQuiz.