Data Warehouse and Database Concepts Quiz

A data warehouse is a _________ collection of information, gathered from many different ___________ databases, that supports business analysis activities and decision-making tasks.

• Physical, transactional

• Logical, operational

• Physical, operational

• Logical, transactional

Classification is a type of unsupervised learning technique.

• True

• False

What are the primary differences between a data warehouse and a data mart?

• Data warehouses have a physical focus; data marts have logical focus.

• Data warehouses have a more organization wide focus; data marts have functional focus.

• Data warehouse tackle ethical issues; data marts tackle hypothetical issues.

• Data warehouses make quick decisions; data marts make slow decisions.

A primary key in a table is:

• all of these

• borrowed by other tables as foreign keys

• required to be unique.

• used to identify each row uniquely

In the field of database rows and records are synonymous.

• True

• False

Redundancy is when the same piece of data is stored in multiple places.

• True

• False

ETL stands for Execution, Transformation and Loading.

• True

• False

In the field of database columns and fields are synonymous.

• True

• False

To normalize a database means to design it in a way that:

• all of these

• reduces data redundancy

• maintains data consistency

• ensure data integrity

Which of the following terms is synonymous with "tuple"?

• Row

• Field

• Table

• Attribute