A data engineer schedules this statement as the single task of a nightly Lakeflow Job. The source folder accumulates Parquet files throughout the day: ```sql COPY INTO main.ops.bookings_raw FROM 'abfss://landing@storacct.dfs.core.windows.net/bookings/' FILEFORMAT = PARQUET; ``` What happens on a night when no new files have arrived since the last successful run?

1. A. The statement completes successfully and loads zero rows, because files that were already loaded by previous runs are skipped ✓ A
2. B. The statement fails with a duplicate-file error, because COPY INTO re-inserts every file in the folder on every run 💬 B
3. C. The statement reloads all files, and the team must schedule a MERGE job afterwards to remove the duplicates 💬 C
4. D. The statement blocks until new files arrive, because COPY INTO behaves like a streaming source waiting for data 💬 D

Revelar gabarito

Resposta correta: The statement completes successfully and loads zero rows, because files that were already loaded by previous runs are skipped

Referência: https://docs.databricks.com/aws/en/ingestion/cloud-object-storage/copy-into