Snowflake DSA-C02 Exam - Topic 1 Question 51 Discussion

Actual exam question for Snowflake's DSA-C02 exam

Question #: 51
Topic #: 1

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

ASnowflake automatically resizes and scales the compute resources for serverless tasks.

BSnowflake 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.

CStreams support repeatable read isolation.

DAn standard-only stream tracks row inserts only.

Show Suggested 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:

Submit Cancel

Eulah

3 days ago

I thought streams could track updates too, not just inserts.

upvoted 0 times

...

Catalina

8 days ago

B is spot on, only one instance runs at a time.

upvoted 0 times

...

Sharen

13 days ago

Wait, are you serious? D is misleading, standard-only streams track more than just inserts!

upvoted 0 times

...

Ettie

18 days ago

I disagree with C, streams don't support repeatable read isolation.

upvoted 0 times

...

Hollis

24 days ago

A) is correct, Snowflake does auto-resize for serverless tasks.

upvoted 0 times

...

Gail

29 days 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

2 months ago

Streams with repeatable read isolation? Sounds like a party I want to be at!

upvoted 0 times

...

Carin

2 months ago

Option B is correct. Snowflake ensures only one instance of a scheduled task is executed at a time.

upvoted 0 times

...

Delmy

2 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

2 months ago

Option D is incorrect. A standard-only stream tracks both inserts and updates.

upvoted 0 times

...

Marylou

2 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

3 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

3 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

3 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

3 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

3 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

3 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

4 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

...