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

Questions 6–10

1. 6foundation · easy

   How does a scheduler handle a job that fails during an ETL workflow?

   • AIt deletes the job from the workflow
   • BIt automatically fixes the data issue
   • CIt ignores the failure and continues
   • DIt retries the job according to configured policies
   Reveal Solution Discussion Select an answer first
2. 7foundation · easy

   Which scheduler is commonly used in Hadoop ecosystems to orchestrate complex ETL workflows?

   • Acron
   • BApache Flume
   • CApache Sqoop
   • DApache Oozie
   Reveal Solution Discussion Select an answer first
4. 8application · medium

   A financial services company must comply with regulations that require data masking and validation before data enters the data warehouse. The warehouse is optimized for high-speed querying but has limited transformation capabilities. Which data integration pattern should the company use?

   • AELT, because the warehouse can handle the transformation after loading.
   • BETL, because transformation must occur before data is loaded into the warehouse.
   • CELT, because it is always faster and more scalable than ETL.
   • DETL, because it is the only pattern that supports data masking.
   Reveal Solution Discussion Select an answer first
5. 9foundation · easy

   Which of the following is a commonly used scheduler for orchestrating ETL/ELT jobs?

   • AApache Airflow
   • BApache Kafka
   • CApache Spark
   • DApache Hive
   Reveal Solution Discussion Select an answer first
6. 10foundation · easy

   Which statement best describes the overall purpose of an ETL process in data integration?

   • ATo consolidate data from multiple sources into a consistent, queryable target
   • BTo replace the need for a data warehouse entirely
   • CTo move data from a data warehouse to operational systems
   • DTo provide real-time streaming data processing
   Reveal Solution Discussion Select an answer first