Snowflake Exam DEA-C01 Topic 5 Question 37 Discussion

Actual exam question for Snowflake's DEA-C01 exam

Question #: 37
Topic #: 5

[All DEA-C01 Questions]

What is a characteristic of the operations of streams in Snowflake?

AWhenever a stream is queried, the offset is automatically advanced.

BWhen a stream is used to update a target table the offset is advanced to the current time.

CQuerying a stream returns all change records and table rows from the current offset to the current time.

DEach committed and uncommitted transaction on the source table automatically puts a change record in the stream.

Show Suggested Answer

Suggested Answer: C

A stream is a Snowflake object that records the history of changes made to a table. A stream has an offset, which is a point in time that marks the beginning of the change records to be returned by the stream. Querying a stream returns all change records and table rows from the current offset to the current time. The offset is not automatically advanced by querying the stream, but it can be manually advanced by using the ALTER STREAM command. When a stream is used to update a target table, the offset is advanced to the current time only if the ON UPDATE clause is specified in the stream definition. Each committed transaction on the source table automatically puts a change record in the stream, but uncommitted transactions do not.

by Jess at Sep 15, 2024, 03:42 AM

Limited Time Offer

25%

1 months ago

Option B seems the most logical to me. Advancing the offset to the current time makes sense when updating a target table.

upvoted 0 times

Carissa

15 days ago

B) When a stream is used to update a target table the offset is advanced to the current time.

upvoted 0 times

...

Krystal

19 days ago

A) Whenever a stream is queried, the offset is automatically advanced.

upvoted 0 times

...