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
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Snowflake DSA-C02 Exam - Topic 1 Question 51 Discussion

Mark the incorrect statement regarding usage of Snowflake Stream & Tasks?
D) An standard-only stream tracks row inserts only.
A) Snowflake automatically resizes and scales the compute resources for serverless tasks.
B) Snowflake ensures only one instance of a task with a schedule (i.e. a standalone task or the root task in a DAG) is executed at a given time. If a task is still running when the next scheduled execution time occurs, then that scheduled time is skipped.
C) Streams support repeatable read isolation.

Snowflake DSA-C02 Exam - Topic 1 Question 51 Discussion

Actual exam question for Snowflake's DSA-C02 exam
Question #: 51
Topic #: 1
[All DSA-C02 Questions]

Mark the incorrect statement regarding usage of Snowflake Stream & Tasks?

Show Suggested Answer Hide Answer
Suggested Answer: D

All are correct except a standard-only stream tracks row inserts only.

A standard (i.e. delta) stream tracks all DML changes to the source object, including inserts, up-dates, and deletes (including table truncates).


by Alaine at Jan 05, 2026, 05:16 AM

Limited Time Offer

25%

Off

Get Premium DSA-C02 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Margarita
4 months ago
I feel confident about A. Snowflake does auto-resize for serverless tasks.
upvoted 0 times
...
Cecil
4 months ago
I’m leaning towards D. A standard-only stream should track more than just inserts.
upvoted 0 times
...
Ashlyn
4 months ago
I agree, C seems off. Streams are more about change data capture.
upvoted 0 times
...
Tamera
4 months ago
I think option C is incorrect. Streams don’t support repeatable read isolation.
upvoted 0 times
...
Eulah
5 months ago
I thought streams could track updates too, not just inserts.
upvoted 0 times
...
Catalina
5 months ago
B is spot on, only one instance runs at a time.
upvoted 0 times
...
Sharen
5 months ago
Wait, are you serious? D is misleading, standard-only streams track more than just inserts!
upvoted 0 times
...
Ettie
5 months ago
I disagree with C, streams don't support repeatable read isolation.
upvoted 0 times
...
Hollis
5 months ago
A) is correct, Snowflake does auto-resize for serverless tasks.
upvoted 0 times
...
Gail
6 months ago
I thought Snowflake was all about the snow, but now they're talking about streams and tasks? Make up your mind, Snowflake!
upvoted 0 times
...
Carman
6 months ago
Streams with repeatable read isolation? Sounds like a party I want to be at!
upvoted 0 times
...
Carin
6 months ago
Option B is correct. Snowflake ensures only one instance of a scheduled task is executed at a time.
upvoted 0 times
...
Delmy
7 months ago
Snowflake's serverless tasks are pretty cool, but I heard they can be a bit of a diva and demand their own private jet.
upvoted 0 times
...
Yan
7 months ago
Option D is incorrect. A standard-only stream tracks both inserts and updates.
upvoted 0 times
...
Marylou
7 months ago
I’m pretty confident that option A is true because I remember reading about Snowflake's automatic scaling for serverless tasks.
upvoted 0 times
...
Jovita
7 months ago
I have a vague recollection that standard-only streams track more than just inserts, so maybe option D is the one that's incorrect?
upvoted 0 times
...
Page
7 months ago
I remember practicing a question about task execution, and I think option B is correct since it mentions skipping the scheduled time if a task is still running.
upvoted 0 times
...
Lenora
7 months ago
I think option C might be the incorrect one, but I'm not entirely sure about the isolation levels in Snowflake.
upvoted 0 times
...
Cristina
8 months ago
I've got this! The incorrect statement is B. Snowflake does not skip the scheduled execution time if a task is still running - it will queue the next run instead.
upvoted 0 times
...
Lynelle
8 months ago
Okay, let me think this through. I know tasks automatically scale the compute resources, and that tasks are scheduled to run at specific times. I think the tricky part here is understanding the behavior when a task is still running when the next scheduled execution occurs.
upvoted 0 times
...
Linwood
8 months ago
Hmm, I'm a bit confused on the difference between streams and tasks. I'll need to review my notes to make sure I understand the correct usage of each.
upvoted 0 times
...
Lemuel
8 months ago
I'm pretty sure the incorrect statement is D. An standard-only stream tracks row inserts, updates, and deletes, not just inserts.
upvoted 0 times
Ricarda
2 months ago
Right! Streams are more versatile than just inserts.
upvoted 0 times
...
Shala
4 months ago
Agreed! D doesn't cover updates and deletes.
upvoted 0 times
...
Ardella
4 months ago
I think D is definitely the wrong one.
upvoted 0 times
...
...

Save Cancel