SnowPro Advanced: Architect — Question 109

A table, T1, has a table stream defined, named S1. The data retention time on the table is set for 10 days. Stream S1has not been consumed for 10 consecutive days.

What consideration needs to be made if an Architect wants to implement an ELT process on the stream?

Answer options

• A. Because of the data retention time setting on table T1, from the 11th day forward if any ETL process tries to access stream S1 the records from the stream will be inaccessible.
• B. An ETL process can access stream S1 after the 11th day because Snowflake automatically puts a temporary extension on the stream offset for 7 additional days.
• C. An ETL process can access stream S1 after the 11th day because Snowflake automatically puts a temporary extension on the stream offset for 14 additional days.
• D. An ETL process can access the stream S1 after the 11th day because streams have no dependency on the table DATA_RETENTION_TIME_IN_DAYS parameter.

Correct answer: A

Explanation

The correct answer is A because when the data retention time is reached, the stream becomes inaccessible. Options B and C incorrectly suggest that Snowflake provides an extension for accessing the stream, which is not the case. Option D is also incorrect, as streams are dependent on the data retention settings of the underlying table.