Data pipelines and data quality
38 practice items · needed by 11 roles
Easy 6Medium 16Hard 16
Practice questions
- The non-idempotent methodeasy
- At-least-once deliverymedium
- Safe retries for paymentshard
- Welcome email sent twicehard
- Unexpected group sizeshard
- Bad data reached trainingeasy
- Silent wrong predictions from bad inputmedium
- Daily batch missing late eventshard
- Revenue doubled after a joinmedium
- Report total does not match financemedium
- Daily numbers do not matchhard
- Latest order changes between runshard
- Uneven groups in a 50/50 testhard
- ETL vs ELTeasy
- Idempotent pipelineseasy
- Built-in dbt testseasy
- Incremental load with updated_atmedium
- Upserting into a target tablemedium
- Table state after a MERGEmedium
- Log-based CDC advantagesmedium
- Duplicates from at-least-once deliverymedium
- Surprise runs from catchupmedium
- Filtering new rows in dbtmedium
- Detecting stale source datamedium
- What a data contract doesmedium
- Rerunning a half-failed loadmedium
- Applying CDC eventshard
- Upstream renamed a columnhard
- Rows missed by a strict watermarkhard
- Overwrite deleted the whole tablehard
- Reusing an idempotency keyhard
- Migration check returns nothinghard
- An uneven 50/50 splitmedium
- A suspicious jump in active usershard
- A suspicious drop in the datahard
- Duplicate customer recordshard
- Duplicate CRM recordseasy
- Bad data in the CS platformmedium