Snowflake Exam DSA-C02 Topic 1 Question 14 Discussion

Actual exam question for Snowflake's DSA-C02 exam

Question #: 14
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 Martina at Mar 18, 2024, 07:22 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Pete

5 months ago

I see where you're coming from, but I still think it's D. An standard-only stream should track all types of changes, not just row inserts.

upvoted 0 times

...

Leigha

5 months ago

I actually think it's A, because Snowflake doesn't automatically resize and scale compute resources for serverless tasks.

upvoted 0 times

...

Kanisha

5 months ago

I agree with user Alishia, D seems to be the incorrect statement.

upvoted 0 times

...

Isaiah

5 months ago

I disagree, I believe it is B.

upvoted 0 times

...

Alishia

5 months ago

I think the incorrect statement is D.

upvoted 0 times

...

Esteban

6 months ago

I think you're right, David. Option C sounds correct to me as well.

upvoted 0 times

...

Emelda

6 months ago

I'm not sure about which option is incorrect, but I think option C is the most plausible answer because streams in Snowflake do support repeatable read isolation.

upvoted 0 times

...