BUZZ SESSION 1 : DATA WAREHOUSE 20242025

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

Based on history, in what year EDW architecture has been designed?

• 2000

• 1990

• 1980

• 2020

Characteristics of datawarehouse?

• subject-oriented

• integrated

• time-variant

• All the above

Non-volatile means data in the data warehouse is updated or deleted

• TRUE

• FALSE

The maintaining period for the data warehouse is significantly must longer than ___?

• 1 - 3 years

• 5- 10 years

• 3 - 5 years

• 1 year

Two types of data operations performed in the data warehousing

• Read and Write

• Update and delete

• Data load and access

• None all the above

Integrated means_____?

• Data is categorized and stored by subject rather than by application

• Data is stored as a series of snapshots, each representing a period of time

• The establishment of a common unit of measure for all similar data

• None all above

What does "time-variant" mean in a data warehouse context

• Data is always current

• Historical data and current data are stored for analysis

• Data is organized by time

• Data changes every minute

A data warehouse uses either a relational structure or multidimensional structured called

• Metadata

• Real time

• Subject Oriented

• Relational

What is the role of metadata in data warehouse?

• To store data

• To transform data

• To delete data

• To provide information about data