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%

Off

Get Premium DEA-C01 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Aleisha

10 months 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

10 months 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

Christoper

10 months ago

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

upvoted 0 times

...

Osvaldo

10 months ago

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

upvoted 0 times

...

Freida

10 months ago

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

upvoted 0 times

...

Gussie

11 months 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

Dorian

9 months ago

I think C is the correct answer. It includes all change records and table rows from the current offset to the current time.

upvoted 0 times

...

Jenelle

9 months ago

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

upvoted 0 times

...

Milly

10 months ago

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

upvoted 0 times

...

Reed

10 months ago

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

upvoted 0 times

...

Chaya

11 months 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

11 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

...