Which of the following processes is typically the most time- and resource-consuming?
A)Creating the data warehouse tables using the DBMS functionalities
B)Creating the OLAP query
C)Creating the ETL infrastructure
D)Creating the data warehouse model

Question

Quizplus · Accepted Answer

Creating the ETL infrastructure is typically the most time- and resource-consuming process in building a data warehouse. ETL involves extracting, transforming, and loading data from various sources into the data warehouse, and can require a significant amount of coding and testing. Creating the data warehouse tables using the DBMS functionalities and creating the data warehouse model are also important processes, but are typically less time-consuming than ETL. Creating the OLAP query is a process that occurs after the data warehouse has been built, and is used to retrieve specific information from the warehouse.

Which of the Following Processes Is Typically the Most Time-