Mid. Data Warehousing Def.

Question 1

1. The collection of processes and data designed to support business analysis and decision-making.

Answer 1

Data warehouse

Question 2

2. The phrase used to emphasize that a data warehouse serves as the authoritative reference point for information.

Answer 2

Single source of truth

Question 3

3. The characteristic that organizes data by business topics such as customers products

Answer 3

Subject oriented

Question 4

4. The characteristic that involves combining and consolidating data from multiple sources to provide a single comprehensive view.

Answer 4

Integrated

Question 5

5. The characteristic that means once data is loaded it is not updated

Answer 5

Nonvolatile

Question 6

6. The characteristic that allows data to be analyzed across historical or longitudinal time periods.

Answer 6

Time Variant

Question 7

7. The property that ensures the data warehouse is distinct from operational systems and used only for analysis and reporting.

Answer 7

Separation

Question 8

8. The property that refers to the ability of the system to handle increasing amounts of data and users without sacrificing performance.

Answer 8

Scalability

Question 9

9. The property that means a data warehouse can add new features data sources

Answer 9

Extensibility

Question 10

10. The property that ensures only authorized users can access strategic data.

Answer 10

Security

Question 11

11. The property that emphasizes ease of management monitoring

Answer 11

Administrability

Question 12

12. A subset of a data warehouse that focuses on a specific business area or department.

Answer 12

Data mart

Question 13

13. The type of database that handles daily business transactions and uses normalized structures optimized for inserts updates

Answer 13

Operational database

Question 14

14. The type of database that stores historical time-variant data and is structured for fast querying and analysis.

Answer 14

Data warehouse

Question 15

15. The type of database used by clerks cashiers

Answer 15

Operational database

Question 16

16. The type of database used by analysts managers

Answer 16

Data warehouse

Question 17

17. The system that provides a strategic reliable

Answer 17

Data warehouse

Question 18

18. The system that differs from operational databases by focusing on analysis history

Answer 18

Data warehouse