Snowflake Exam DSA-C02 Topic 4 Question 35 Discussion

Actual exam question for Snowflake's DSA-C02 exam

Question #: 35
Topic #: 4

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 Stefany at Dec 10, 2024, 01:02 PM

Limited Time Offer

25%

20 days ago

Option D is incorrect. Standard-only streams track both inserts and updates, not just inserts.

upvoted 0 times

Tarra

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

...

Domonique

13 days ago

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

upvoted 0 times

...