IBM Interview Question

SQL Optimizing. How do we create ETL pipeline environment free ( No dependency) How do we maintain Logs