Data warehouse exam

What is the primary purpose of a data warehouse?

• Real-time business transactions

• Data analysis for business decisions

• Data validation during transactions

• Data redundancy reduction

Which of the following is a characteristic of a data warehouse?

• Transaction-oriented

• Integrated data from multiple sources

• Volatile data

• Non-subject-oriented

Which type of data is organized around subjects in a data warehouse?

• Transactional

• Time-referenced

• Non-volatile

• Subject-oriented

What is the main goal of a data warehouse?

• Provide easy access to corporate data

• Support real-time business transactions

• Minimize data redundancy

• Enhance data validation during transactions

Which layer of the Data Warehouse Architecture is responsible for transporting data from source systems to the warehouse?

• Metadata management layer

• Data processing layer

• Data integration layer

• End user reporting layer

What is a characteristic of a snowflake schema in a dimensional model?

• Complex dimensions are normalized

• It consists of a central fact table

• It is easy to understand and relate to business needs

• It supports simplified business queries

What is the granularity of data?

• The level of detail at which data is recorded

• The size of the data warehouse

• The number of dimensions in a star schema

• The type of data stored in a warehouse

Which of the following is a true statement about additive facts in a data warehouse?

• They cannot be added along any dimension

• They are usually non-numeric values

• They are always fully additive

• They are typically numeric and additive along all dimensions

What is the purpose of a helper table in a dimensional model?

• To store multi-valued dimensions

• To handle complex hierarchies

• To normalize complex dimensions

• To simplify data retrieval processes

Which of the following is a characteristic of a dimensional model?

• It uses an E-R diagram to represent relationships

• It consists of a set of detailed business facts

• It is optimized for real-time business transactions

• It requires a normalized structure to minimize redundancy