Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Snowflake Exam DSA-C02 Topic 1 Question 16 Discussion

Actual exam question for Snowflake's DSA-C02 exam
Question #: 16
Topic #: 1
[All DSA-C02 Questions]

Mark the incorrect statement regarding usage of Snowflake Stream & Tasks?

Show Suggested Answer Hide 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 Kris at Apr 22, 2024, 07:42 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel
Stephaine
10 months ago
Agreed. Let's go with D then.
upvoted 0 times
...
Amie
10 months ago
Makes sense. So D is likely incorrect. Agreed?
upvoted 0 times
...
Rory
10 months ago
Right, Standard streams track inserts, updates, and deletes.
upvoted 0 times
...
Dorian
10 months ago
Option D seems off. Standard streams track inserts and other things too, right?
upvoted 0 times
...
Stephaine
11 months ago
True. But I remember reading something about streams and tasks.
upvoted 0 times
...
Amie
11 months ago
I think the question is tricky. Lots of technical terms.
upvoted 0 times
...
Una
11 months ago
A) Snowflake automatically resizes and scales the compute resources for serverless tasks.
upvoted 0 times
...
Ariel
11 months ago
B) Snowflake ensures only one instance of a task with a schedule is executed at a given time.
upvoted 0 times
...
Daryl
11 months ago
D) An standard-only stream tracks row inserts only.
upvoted 0 times
...
Ludivina
11 months ago
C) Streams support repeatable read isolation.
upvoted 0 times
...

Save Cancel