Reviewed by Aditya Kumar · Last reviewed 2026-03-24
Architectural logic: Glue runs in AWS; connector/agent in on-prem network proxies connection. Efficient extraction: (1) Pushdown—filter at source. (2) Partition-based extract (date). (3) Incremental via bookmarks/watermark. (4) Parallel reads by splitting on numeric key. Why:...
Architectural logic: Glue runs in AWS; connector/agent in on-prem network proxies connection. Efficient extraction: (1) Pushdown—filter at source. (2) Partition-based extract (date). (3) Incremental via bookmarks/watermark. (4) Parallel reads by splitting on numeric key. Why: Full scans over WAN are slow and expensive. Best practice: Connector in same network as DB; connection pooling; always use predicates.
Red Flag: Full table extract when incremental is possible. Pro-Move: 'We use bookmark on updated_at; pushdown WHERE; 10 partitions—extract 50M rows in 15 min vs 2 hours full.'
According to DataEngPrep.tech, this is one of the most frequently asked Cloud/Tools interview questions, reported at 1 company. DataEngPrep.tech maintains an editor-reviewed database of 1,863 data engineering interview questions across 7 categories.