DATAWAREHOUSE BRAIN TEASER

A data warehouse is which of the following?

• Can be updated by end users

• Contains numerous naming conventions and formats.

• Organized around important subject areas.

• Contains only current data.

Which small logical units do data warehouses hold large amounts of information?

• Data Storage

• Data Marts

• Access Layer

• Data Miners

14. What is the primary problem with redundant information?

• A. It is difficult to determine which values are the most current

• B. It is often inconsistent

• C. It is difficult to determine which values are the most accurate

• D. All of the above

13. What is information redundancy?

• A. Duplication of information

• B. Storing the same information in multiple places

• C. Storing duplicate information in multiple places

• D. All of the above

7. All of the following are advantages of database-stored information, except:

• A. Increased flexibility

• B. Increased performance

• C. Increased information redundancy

• D. Increased information integrity

Process of analyzing the data in different dimensions or perspectives and summarizing into a useful information is called:

• Data Warehousing

• Data modeling

• Data Analysis / Data Mining

• None

what option is not included in data warehouse modeling?

• _{Fact tables and dimensions tables}

• _{Bottom-up drive approach}

• _{Star schemas and Multidimensional models (cube)}

• _{Normalization and denormalization}

What does OLTP stand for?

• Online transaction processing
• Offline transaction processing
• Outline trajectory processing
• Online traffic processing

Metadata is data about data

• True
• False

Which among the two is the modern approach that handles all the transformation in warehouse?

• ETL

• ELT