21) Which of the following techniques is used to optimize query performance in data warehouses?

22) What is the purpose of indexing in a data warehouse?

23) Which of the following is a common approach to handle large volumes of data in ETL processes?

24) What is data partitioning?

25) In the context of ETL, what is meant by "data latency"?

26) What is the primary purpose of a data lake?

27) Which technology is often used for real-time data streaming in ETL processes?

28) What is the purpose of a data warehouse bus architecture?

29) What is the primary difference between ETL and ELT?

30) In which scenario would you use a slowly changing dimension (SCD)?

31) What is data governance?

32) What is a data quality dimension?

33) Which of the following is NOT a common data quality issue?

34) What is the primary purpose of data profiling?

35) Which of the following best describes a data steward?

36) What is the primary purpose of a business intelligence (BI) tool?

37) What type of report is used for decision-making at the operational level?

38) Which of the following is a common visualization tool used in business intelligence?

39) What is a dashboard in the context of BI?

40) What is drill-down analysis?