The ingestion lead is reviewing how a new source enters bronze. Some questions concern executable file reads, while others concern guarantees you must establish before connecting a real system. The browser fixtures let you inspect local results; they cannot grant access to an enterprise database or prove a cloud notification configuration.
Reuse the reader, COPY and Auto Loader rules from this unit. Separate source discovery from business-key reconciliation. A repeatable file load can still contain repeated business records, and an append is different from an upsert. Consider frequency, source support, data volume and governance before choosing a connector. The right answer is the one that meets the stated recovery requirement with an explicit data contract, rather than the one with the fewest lines of notebook code.