Snowflake Exam DSA-C02 Topic 4 Question 25 Discussion

Actual exam question for Snowflake's DSA-C02 exam

Question #: 25
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 Amira at Aug 06, 2024, 08:15 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Valda

4 months ago

I think C is the incorrect statement because Streams do not support repeatable read isolation.

upvoted 0 times

...

Jordan

4 months ago

I believe A is incorrect because Snowflake doesn't automatically resize compute resources.

upvoted 0 times

...

Vernell

4 months ago

I agree with Gary, D seems incorrect.

upvoted 0 times

...

Allene

4 months ago

Serverless tasks? Sounds like the perfect job for a snowman. 'Let it go, let it go, can't hold me back anymore!'

upvoted 0 times

...

Chantell

4 months ago

I thought this was a question about snowflakes, not database tasks. Guess I need to chill out and focus!

upvoted 0 times

...

Bette

4 months ago

Option A is correct. Snowflake does automatically scale the compute resources for serverless tasks.

upvoted 0 times

Franklyn

3 months ago

C) Streams support repeatable read isolation.

upvoted 0 times

...

Laticia

3 months ago

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

upvoted 0 times

...

Gary

4 months ago

I think the incorrect statement is D.

upvoted 0 times

...

Junita

4 months ago

I think C is incorrect because Streams do not support repeatable read isolation.

upvoted 0 times

...

Lai

4 months ago

Option C is correct. Streams do support repeatable read isolation.

upvoted 0 times

Kenny

3 months ago

C) Streams support repeatable read isolation.

upvoted 0 times

...

Berry

4 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

...