Data Warehousing Quiz

Which of the following best describes a data warehouse according to W. H. Inmon?

• A) A collection of data that is subject-oriented, integrated, time-variant, and nonvolatile.

• B) A database used for daily transactions.

• C) A repository for only financial data.

• D) A system for storing emails.

Which characteristic distinguishes a data warehouse from an operational database?

• A) It is used for decision support and is maintained separately.

• B) It processes real-time transactions.

• C) It only stores customer information.

• D) It is used for network management.

Which of the following best describes the organization of a subject-oriented data warehouse?

• Organized around major subjects such as customer, product, and sales.

• Organized around daily operations and transaction processing.

• Organized randomly without any specific subjects.

• Organized based on employee schedules.

What is the correct sequence of processes before data is stored in a data warehouse?

• Data extraction process → Data cleanup process → Data warehouse

• Data cleanup process → Data extraction process → Data warehouse

• Data warehouse → Data extraction process → Data cleanup process

• Data extraction process → Data warehouse → Data cleanup process

Which of the following best describes the time horizon for a data warehouse compared to operational systems?

• It is shorter than operational systems.

• It is the same as operational systems.

• It is significantly longer than operational systems.

• It does not have a time horizon.

What operations are required for accessing data in a data warehouse?

• Initial loading and access of data

• Transaction processing and recovery

• Real-time updating and deletion

• Concurrency control and backup

What does a Data Warehouse provide to an enterprise?

• Intelligence

• Memory

• Security

• Speed

Explain how Data Mining and Data Warehousing complement each other in an enterprise environment.

• Data Mining and Data Warehousing both provide memory to the enterprise.

• Data Mining provides intelligence, while Data Warehousing provides memory, enabling enterprises to store data and extract useful insights.

• Data Mining and Data Warehousing both provide intelligence to the enterprise.

• Data Mining and Data Warehousing are unrelated processes in an enterprise.

What does OLTP stand for?

• Online Transaction Processing

• Online Table Processing

• Offline Transaction Processing

• Online Technical Processing

Which type of database system is primarily used for day-to-day operations?

• OLTP

• OLAP

• NoSQL

• Data Warehouse