1. What is ETL ? Junior A. reprocessing historical data, safe only when writes are idempotent B. re-running a job with the same input yields the same result, with no duplicates C. transforming data before loading it into the target D. overwriting a target partition rather than appending
2. Which term means: "transforming data before loading it into the target"? Junior A. idempotent write B. MERGE / upsert C. idempotency D. ETL
3. Which statement is correct? Junior A. ETL — transforming data before loading it into the target B. ETL — capturing changes from the database transaction log (e.g. Debezium), including deletes C. ETL — processing only new or changed rows since the last run D. ETL — updating matched rows and inserting new rows in one atomic statement
4. What is ELT ? Junior A. overwriting a target partition rather than appending B. reprocessing historical data, safe only when writes are idempotent C. capturing changes from the database transaction log (e.g. Debezium), including deletes D. loading raw data first, then transforming it inside the warehouse
5. Which term means: "loading raw data first, then transforming it inside the warehouse"? Junior A. ELT B. idempotent write C. log-based CDC D. ETL
6. Which statement is correct? Junior A. ELT — loading raw data first, then transforming it inside the warehouse B. ELT — reprocessing historical data, safe only when writes are idempotent C. ELT — overwriting a target partition rather than appending D. ELT — transforming data before loading it into the target
7. What is idempotency ? Mid A. re-running a job with the same input yields the same result, with no duplicates B. loading raw data first, then transforming it inside the warehouse C. capturing changes from the database transaction log (e.g. Debezium), including deletes D. overwriting a target partition rather than appending
8. Which term means: "re-running a job with the same input yields the same result, with no duplicates"? Mid A. MERGE / upsert B. idempotency C. incremental load D. idempotent write
9. Which statement is correct? Mid A. idempotency — re-running a job with the same input yields the same result, with no duplicates B. idempotency — transforming data before loading it into the target C. idempotency — processing only new or changed rows since the last run D. idempotency — capturing changes from the database transaction log (e.g. Debezium), including deletes
10. What is idempotent write ? Mid A. transforming data before loading it into the target B. capturing changes from the database transaction log (e.g. Debezium), including deletes C. overwriting a target partition rather than appending D. processing only new or changed rows since the last run
11. Which term means: "overwriting a target partition rather than appending"? Mid A. idempotency B. incremental load C. ELT D. idempotent write
12. Which statement is correct? Mid A. idempotent write — updating matched rows and inserting new rows in one atomic statement B. idempotent write — re-running a job with the same input yields the same result, with no duplicates C. idempotent write — overwriting a target partition rather than appending D. idempotent write — processing only new or changed rows since the last run
13. What is incremental load ? Mid A. capturing changes from the database transaction log (e.g. Debezium), including deletes B. reprocessing historical data, safe only when writes are idempotent C. processing only new or changed rows since the last run D. loading raw data first, then transforming it inside the warehouse
14. Which term means: "processing only new or changed rows since the last run"? Mid A. ELT B. incremental load C. idempotent write D. ETL
15. Which statement is correct? Mid A. incremental load — processing only new or changed rows since the last run B. incremental load — capturing changes from the database transaction log (e.g. Debezium), including deletes C. incremental load — updating matched rows and inserting new rows in one atomic statement D. incremental load — transforming data before loading it into the target
16. What is MERGE / upsert ? Mid A. transforming data before loading it into the target B. loading raw data first, then transforming it inside the warehouse C. updating matched rows and inserting new rows in one atomic statement D. processing only new or changed rows since the last run
17. Which term means: "updating matched rows and inserting new rows in one atomic statement"? Mid A. idempotency B. ETL C. incremental load D. MERGE / upsert
18. Which statement is correct? Mid A. MERGE / upsert — updating matched rows and inserting new rows in one atomic statement B. MERGE / upsert — processing only new or changed rows since the last run C. MERGE / upsert — overwriting a target partition rather than appending D. MERGE / upsert — reprocessing historical data, safe only when writes are idempotent
19. What is log-based CDC ? Senior A. loading raw data first, then transforming it inside the warehouse B. capturing changes from the database transaction log (e.g. Debezium), including deletes C. transforming data before loading it into the target D. reprocessing historical data, safe only when writes are idempotent
20. Which term means: "capturing changes from the database transaction log (e.g. Debezium), including deletes"? Senior A. idempotent write B. log-based CDC C. ETL D. MERGE / upsert
21. Which statement is correct? Senior A. log-based CDC — overwriting a target partition rather than appending B. log-based CDC — capturing changes from the database transaction log (e.g. Debezium), including deletes C. log-based CDC — re-running a job with the same input yields the same result, with no duplicates D. log-based CDC — transforming data before loading it into the target
22. What is backfill ? Mid A. transforming data before loading it into the target B. reprocessing historical data, safe only when writes are idempotent C. loading raw data first, then transforming it inside the warehouse D. processing only new or changed rows since the last run
23. Which term means: "reprocessing historical data, safe only when writes are idempotent"? Mid A. backfill B. log-based CDC C. MERGE / upsert D. idempotency
24. Which statement is correct? Mid A. backfill — updating matched rows and inserting new rows in one atomic statement B. backfill — loading raw data first, then transforming it inside the warehouse C. backfill — processing only new or changed rows since the last run D. backfill — reprocessing historical data, safe only when writes are idempotent