Snowflake Exam DSA-C02 Topic 3 Question 37 Discussion

Actual exam question for Snowflake's DSA-C02 exam

Question #: 37
Topic #: 3

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 Adelle at Jan 23, 2025, 02:53 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Rupert

1 months ago

Option A is definitely correct. Snowflake is known for its serverless and auto-scaling capabilities, including for tasks.

upvoted 0 times

Angella

10 days ago

Yes, that's true. Snowflake is great for serverless tasks.

upvoted 0 times

...

Marnie

13 days ago

I agree, Snowflake does automatically resize and scale compute resources for tasks.

upvoted 0 times

...

Fanny

1 months ago

Oh, I see. That makes sense.

upvoted 0 times

...

Devora

1 months ago

Wow, this question is really testing our Snowflake knowledge! I hope I can remember all the details about streams and tasks.

upvoted 0 times

...

Jamie

1 months ago

I'm a bit confused about option C. Aren't Snowflake streams based on change data capture, not repeatable read isolation?

upvoted 0 times

...

Alishia

1 months ago

Option B is correct. Snowflake does ensure that only one instance of a scheduled task is executed at a time to avoid conflicts.

upvoted 0 times

Catarina

That's right. It helps to avoid conflicts and ensures smooth execution of tasks.

upvoted 0 times

...

Cristen

8 days ago

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

upvoted 0 times

...

Donette

1 months ago

Because Snowflake does not automatically resize and scale compute resources for serverless tasks.

upvoted 0 times

...

Fanny

1 months ago

Why do you think it's A?

upvoted 0 times

...

Donette

2 months ago

I disagree, I believe the incorrect statement is A.

upvoted 0 times

...

Fanny

2 months ago

I think the incorrect statement is D.

upvoted 0 times

...

Hubert

2 months ago

I think option D is incorrect. Snowflake streams can track both inserts and updates, not just inserts.

upvoted 0 times

Karima

1 months ago

C) Streams support repeatable read isolation.

upvoted 0 times

...

Deeanna

1 months ago

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.

upvoted 0 times

...

Louisa

1 months ago

A) Snowflake automatically resizes and scales the compute resources for serverless tasks.

upvoted 0 times

...