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

Questions 16–18

1. 16foundation · easy

   What is the primary difference between ETL and ELT in terms of processing order?

   • AETL uses only batch processing; ELT uses only real-time processing
   • BETL loads before transforming; ELT transforms before loading
   • CETL transforms before loading; ELT loads before transforming
   • DETL extracts after loading; ELT extracts before loading
   Reveal Solution Discussion Select an answer first
2. 17foundation · easy

   Which scenario is best suited for an ELT approach?

   • AWhen transformations are simple and require minimal compute
   • BWhen the target system has limited processing power
   • CWhen the target is a scalable data lake or cloud warehouse
   • DWhen raw data must be transformed before entering the target
   Reveal Solution Discussion Select an answer first
3. 18application · medium

   A small team manages a nightly ETL job that extracts data from a PostgreSQL database, transforms it with a Python script, and loads it into a CSV file for a legacy system. The job must run every night at 2 AM, and if it fails, it should be retried after 10 minutes. The team wants a simple solution with minimal infrastructure. Which scheduler is most appropriate?

   • AApache Airflow
   • BKubernetes CronJob
   • CApache Oozie
   • Dcron
   Reveal Solution Discussion Select an answer first