Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

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?

Show Suggested Answer Hide 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.


Contribute your Thoughts:

Aleisha
11 days ago
Option A sounds like it would lead to some serious performance issues. Imagine querying a stream and it just keeps advancing the offset automatically? No, thank you!
upvoted 0 times
...
Chantay
12 days ago
Haha, this question is like a game of 'guess which one is the trap answer'. I'm going with B, just to be safe.
upvoted 0 times
...
Gussie
16 days ago
Hmm, I was thinking D was the right answer. Wouldn't all committed and uncommitted transactions show up in the stream? That would make the most sense.
upvoted 0 times
...
Chaya
21 days ago
Hmm, that makes sense too. I can see why that would be a characteristic of the operations of streams in Snowflake.
upvoted 0 times
...
Cortney
1 months ago
I disagree, I believe the correct answer is C) Querying a stream returns all change records and table rows from the current offset to the current time.
upvoted 0 times
...
Chaya
1 months ago
I think the answer is A) Whenever a stream is queried, the offset is automatically advanced.
upvoted 0 times
...
Tamie
1 months ago
I'm not sure about that. Querying a stream should only return the changes, not the entire table, right? I think C is the correct answer.
upvoted 0 times
...
Lavelle
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
...
...

Save Cancel