Free Printable UCCD3233 Data Warehouse Modelling and Implementation

Worksheets

UCCD3233 Data Warehouse Modelling and Implementation

Total questions: 17

Worksheet time: 14mins

Name

Class

Date

. An operational system is which of the following?

A system that is used to run the business in real time and is based on historical data.

A system that is used to run the business in real time and is based on current data.

A system that is used to support decision making and is based on current data.

A system that is used to support decision making and is based on historical data.

What is an operational system in data warehousing?

A system that is used to process the day-to-day transactions of an organisation

A system that sets up the data warehouse

A system that runs the data warehouse

A system that identifies error in the data warehouse

What is a data warehouse?

Is a relational database that is designed for query and analysis

Is a non-relational database that is designed for query and analysis

In data warehousing what is time-variant data?

Data in the warehouse is only accurate and valid at some point in time or over time interval

Data in the warehouse is always accurate and valid

Data in the warehouse is not accurate

Data in the warehouse is only accurate sometimes

Is the data in a dataware house generally updated in real-time?

Yes

What does OLTP stand for?

Online transaction processing

Offline transaction processing

Outline trajectory processing

Online traffic processing

What does ERP stand for?

Enterprise Resource Planning

Ether Resource Planning

Enterprise Resource Procedure

Enteringg Resource Procedure

Metadata is data about data

True

False

What is a Data Mart?

A data mart is a subgroup of the data warehouse

A data mart is another type of data warehouse

A data mart is not actually related to data warehouses

None of these

10.

What does DM stand for?

Database Model

Database Management

Dimensional Model

Dimensional Management

11.

What is a Star Schema?

A star schema consists of a fact table with a single table for each dimension

A star schema is a type of database system

A star schema is used when exporting data from the database

None of these

12.

What is a Snowflake Schema?

Each dimension table is normalized, which may create additional tables attached to the dimension tables

A Snowflake schema is a type of database system

A Snowflake schema is used when exporting data from the database

None of these

13.

A basic concept of data warehouse is which of the following?

Can be updated by end users.

Contains numerous naming conventions and formats.

Store the data in formats suitable for easy access for decision making.

Contains only current data.

14.

Which of the following are characteristics of data warehouse?

Subject-oriented.

Integrated.

Non-volatile.

All of the above.

15.

The data collected in data warehouse can be used for analyzing purpose.

True

False

16.

In the early stages, four significant factors drove many companies to move into data warehousing, Except?

Fierce competition.

Need to revamp internal processes.

Convenient place to create and store metadata.

Government deregulation.

17.

Which schema is best for data warehouse development?

Reset

UCCD3233 Data Warehouse Modelling and Implementation

Total questions: 17

Worksheet time: 14mins

Similar Resources on Wayground