Cyber Monday 2024! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

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).


Contribute your Thoughts:

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

Save Cancel
az-700  pass4success  az-104  200-301  200-201  cissp  350-401  350-201  350-501  350-601  350-801  350-901  az-720  az-305  pl-300  

Warning: Cannot modify header information - headers already sent by (output started at /pass.php:70) in /pass.php on line 77