A streaming table created with read_files over a landing directory has been live for weeks. A faulty transformation in the pipeline polluted its contents; the source files are still intact in cloud storage, and the transformation has now been fixed. The team decides to rebuild the table with a full refresh. Which statement describes what REFRESH TABLE ... FULL REFRESH does?

1. A. It re-executes only the micro-batches whose output the faulty transformation affected, leaving every correctly loaded batch untouched in the table 💬 A
2. B. It discards the streaming state that tracks processed data and reprocesses everything from the source, fully re-deriving the table ✓ B
3. C. It drops and recreates the table schema before reloading, resetting column types and constraints to their original definitions 💬 C
4. D. It fires automatically whenever the source schema changes, so issuing it manually after fixing a transformation is redundant 💬 D

Revelar gabarito

Resposta correta: It discards the streaming state that tracks processed data and reprocesses everything from the source, fully re-deriving the table

Referência: https://docs.databricks.com/aws/en/ldp/concepts/streaming-tables