Describe ETL, ELT, and Related Schedulers DATA-ENGINEERING-OPTIMIZE Practice Questions (Page 3)

Questions 11–15

1. 11application · medium

   A startup is building a new data platform. They expect to ingest large volumes of raw data from multiple sources and want to allow data scientists to explore and transform the data flexibly using SQL. They plan to use a cloud data warehouse with powerful processing capabilities. Which approach is most suitable?

   • AELT, because it loads raw data first and allows transformations in the warehouse.
   • BETL, because it is the traditional and proven approach.
   • CETL, because it ensures data quality before loading.
   • DELT, because it requires less storage than ETL.
   Reveal Solution Discussion Select an answer first
2. 12application · medium

   A company has a legacy ETL pipeline that transforms data on a dedicated server before loading it into a data warehouse. The data volume is growing, and the transformation server is becoming a bottleneck. The company is considering moving to an ELT approach. What is the primary benefit of ELT in this scenario?

   • AIt requires less storage because raw data is not stored.
   • BIt guarantees faster query performance in the data warehouse.
   • CIt reduces the load on the transformation server by moving transformation to the data warehouse.
   • DIt eliminates the need for data transformation entirely.
   Reveal Solution Discussion Select an answer first
4. 13foundation · easy

   What is the primary role of a scheduler in an ETL/ELT workflow?

   • ATo store the transformed data
   • BTo extract data from source systems
   • CTo manage the timing and dependencies of jobs
   • DTo execute transformations on the data
   Reveal Solution Discussion Select an answer first
5. 14foundation · easy

   In the context of data integration, what is the primary purpose of the Transform step in an ETL process?

   • ATo load the raw data into the target system without any changes
   • BTo schedule the entire ETL pipeline
   • CTo extract data from multiple source systems
   • DTo convert and clean the data to meet business requirements
   Reveal Solution Discussion Select an answer first
6. 15application · medium

   A retail company's nightly data pipeline extracts sales transactions, transforms them by aggregating daily sales per store, and then loads the aggregated results into a reporting database. The transformation step is CPU-intensive and runs on a dedicated cluster. The reporting database is used by business analysts who need results by 6 AM. Which approach best describes the current pipeline?

   • AELT, because the transformation happens after loading into the reporting database.
   • BETL, because data is transformed before being loaded into the reporting database.
   • CELT, because the reporting database is the final destination for the data.
   • DETL, because the transformation is CPU-intensive and requires a dedicated cluster.
   Reveal Solution Discussion Select an answer first