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

Questions 1–5

1. 1foundation · easy

   Which of the following is a key characteristic of the ELT approach?

   • ARaw data is loaded into the target and transformed later
   • BTransformation is performed exclusively on the source system
   • CThe target system must be a traditional relational database
   • DData is transformed before it is loaded into the target
   Reveal Solution Discussion Select an answer first
2. 2application · medium

   A media company ingests raw clickstream logs into a cloud data warehouse. Data scientists then run SQL queries to parse and enrich the logs directly in the warehouse for analysis. The company wants to minimize the time-to-insight for new data. Which pipeline design best fits this requirement?

   • AETL, because the data is extracted from logs and loaded into a warehouse.
   • BETL, because the transformation is done by data scientists using SQL.
   • CELT, because the data is loaded into a cloud warehouse, which is always ELT.
   • DELT, because raw data is loaded first and transformed later in the warehouse.
   Reveal Solution Discussion Select an answer first
4. 3foundation · easy

   In an ELT process, when does the transformation of data typically occur?

   • ADuring the extraction phase
   • BAfter the data is loaded into the target system
   • CBefore the data is loaded into the target system
   • DBefore the data is extracted from the source
   Reveal Solution Discussion Select an answer first
5. 4expert · hard

   A company is designing a new data pipeline. The data sources include transactional databases and streaming events. The data must be available for real-time dashboards and for historical analysis. The team is considering using a data lake and a data warehouse. They want to minimize the time between data generation and availability for analysis. Which approach best meets these requirements?

   • AUse ETL to load transformed data into the data warehouse for both real-time and historical analysis.
   • BUse a single ELT pipeline that loads raw data into the warehouse and transforms it there for both real-time and historical analysis.
   • CUse ETL for historical data and ELT for real-time data.
   • DUse ELT to load raw data into the data lake, then transform it in the warehouse for historical analysis, and use a separate streaming pipeline for real-time dashboards.
   Reveal Solution Discussion Select an answer first
6. 5expert · medium

   A company is migrating from an on-premises ETL tool to a cloud-based data platform. They have a mix of batch and streaming data sources. The data team wants to standardize on a single approach for data integration. They are considering ETL and ELT. Which factor is most important in deciding between ETL and ELT?

   • AThe processing capabilities of the target data platform.
   • BThe cost of the data platform.
   • CThe number of data sources.
   • DThe size of the data team.
   Reveal Solution Discussion Select an answer first