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%

Off

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

Contribute your Thoughts:

Submit Cancel

Augustine

2 months ago

Option A seems right to me. Snowflake is supposed to automatically scale the compute resources for serverless tasks.

upvoted 0 times

Maryann

1 months ago

C) Streams support repeatable read isolation.

upvoted 0 times

...

Keneth

2 months ago

B) Snowflake ensures only one instance of a task with a schedule is executed at a given time.

upvoted 0 times

...

Nada

2 months ago

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

upvoted 0 times

...

Arminda

3 months ago

Haha, I bet the exam author got a little too creative with those options. Option C about 'repeatable read isolation' sounds like it was just thrown in there for good measure.

upvoted 0 times

...

Whitley

3 months ago

I'm not sure, but I think D is incorrect because streams can also track row updates and deletes.

upvoted 0 times

...

Verda

3 months ago

I think Option B is the correct answer. Snowflake does ensure only one instance of a scheduled task is executed at a time.

upvoted 0 times

Mike

2 months ago

You're correct, option D is the incorrect statement. Standard-only streams track both row inserts and updates.

upvoted 0 times

...

Charlene

2 months ago

I think option D is incorrect. Standard-only streams track row inserts and updates, not just inserts.

upvoted 0 times

...

Felicidad

2 months ago

Yes, that's right. Snowflake does a great job in managing tasks and schedules.

upvoted 0 times

...

Lynsey

3 months ago

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

upvoted 0 times

...

Bettina

3 months ago

I believe D is incorrect because streams can track more than just row inserts.

upvoted 0 times

...

Ryan

3 months ago

I agree with Dorian, D seems incorrect.

upvoted 0 times

...

Dorian

3 months ago

I think the incorrect statement is D.

upvoted 0 times

...

Shizue

4 months ago

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

upvoted 0 times

Dorcas

3 months ago

D) An standard-only stream tracks row inserts only.

upvoted 0 times

...

Yong

3 months ago

C) Streams support repeatable read isolation.

upvoted 0 times

...

Tarra

3 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

...

Domonique

3 months ago

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

upvoted 0 times

...