Streams have no Fail-safe period or Time Travel retention period. The metadata in these objects cannot be recovered if a stream is dropped.

• A. True
• B. False
• C. Only fail-safe
• D. Only Time Travel

Answer: (A)

Streams are change-tracking metadata, not data with its own retention. Time Travel and Fail-safe apply to data stored in tables, not to the stream’s metadata. Because a stream doesn’t hold data and its state isn’t preserved by those retention mechanisms, dropping a stream means its internal offsets and change-tracking history cannot be recovered. To resume change tracking, you’d recreate a stream on the base table, and you can use Time Travel on the base table to inspect past data, but the dropped stream’s previous state isn’t recoverable.