1) What is a data warehouse?

2) What does ETL stand for?

3) Which of the following is NOT a benefit of a data warehouse?

4) What type of schema is commonly used in data warehouses?

5) Which of the following is an OLAP tool?

6) In the ETL process, what is the primary function of the Transform phase?

7) Which of the following tools is commonly used for ETL processes?

8) What is a staging area in ETL?

9) What is the purpose of data cleansing in ETL?

10) Which of the following is an example of an ETL tool?

11) What is a fact table?

12) What is a dimension table?

13) Which of the following best describes a snowflake schema?

14) In data warehousing, what is meant by "grain"?

15) What is an ETL workflow?

16) Which of the following is a common technique for data loading in data warehousing?

17) What is data federation in the context of data warehousing?

18) What does the term "data mart" refer to?

19) Which of the following best describes the purpose of data archiving?

20) What is a surrogate key?