Quiz 2- FEDM

A data warehouse is optimized for transactional processing.

• True

• False

A data warehouse integrates data from multiple sources into a single repository

• True

• False

It is a focused subsets of a data warehouse designed for specific business areas

Data warehouses follow the normalization process to minimize redundancy.

• True

• False

A __________table in a star schema primarily contains descriptive attributes.

Which component of a data warehouse helps users perform data analysis and reporting?

• ETL Process

• OLAP Tools

• Staging Area

• Transaction Logs

What is a fact table in a data warehouse?

• A table that stores historical logs

• A table that contains foreign keys and measures

• A table used to store only metadata

• A table containing only textual descriptions

Which of the following statements about a Snowflake Schema is true?

• It has denormalized dimension tables

• It is less complex than a Star Schema

• It normalizes dimension tables to reduce redundancy

• It does not contain a fact table

____________provides descriptive information about the data warehouse structure and contents.

Bill Inmon's approach to data warehousing is best described as:

• Bottom-up approach

• Top-down approach

• Hybrid approach

• OLTP-based approach