BlackFriday 2024! 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 4 Question 25 Discussion

Actual exam question for Snowflake's DSA-C02 exam
Question #: 25
Topic #: 4
[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 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
2 months ago
I think C is the incorrect statement because Streams do not support repeatable read isolation.
upvoted 0 times
...
Jordan
2 months ago
I believe A is incorrect because Snowflake doesn't automatically resize compute resources.
upvoted 0 times
...
Vernell
2 months ago
I agree with Gary, D seems incorrect.
upvoted 0 times
...
Allene
2 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
2 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
3 months ago
Option A is correct. Snowflake does automatically scale the compute resources for serverless tasks.
upvoted 0 times
Franklyn
2 months ago
C) Streams support repeatable read isolation.
upvoted 0 times
...
Laticia
2 months ago
A) Snowflake automatically resizes and scales the compute resources for serverless tasks.
upvoted 0 times
...
...
Gary
3 months ago
I think the incorrect statement is D.
upvoted 0 times
...
Junita
3 months ago
I think C is incorrect because Streams do not support repeatable read isolation.
upvoted 0 times
...
Lai
3 months ago
Option C is correct. Streams do support repeatable read isolation.
upvoted 0 times
Kenny
2 months ago
C) Streams support repeatable read isolation.
upvoted 0 times
...
Berry
2 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
...
Kristofer
2 months ago
A) Snowflake automatically resizes and scales the compute resources for serverless tasks.
upvoted 0 times
...
...
Amber
3 months ago
Option B is correct. Snowflake ensures only one instance of a scheduled task is executed at a time.
upvoted 0 times
...
Tequila
3 months ago
I believe A is incorrect because Snowflake does not automatically resize compute resources for serverless tasks.
upvoted 0 times
...
Malcolm
3 months ago
Option D is incorrect. Streams track both inserts and updates, not just inserts.
upvoted 0 times
Alpha
2 months ago
D) An standard-only stream tracks row inserts only.
upvoted 0 times
...
Jacki
2 months ago
C) Streams support repeatable read isolation.
upvoted 0 times
...
Erin
2 months ago
B) Snowflake ensures only one instance of a task with a schedule is executed at a given time.
upvoted 0 times
...
Francesco
3 months ago
A) Snowflake automatically resizes and scales the compute resources for serverless tasks.
upvoted 0 times
...
...
Marla
3 months ago
I agree with Emogene, D seems incorrect.
upvoted 0 times
...
Emogene
3 months ago
I think the incorrect statement is D.
upvoted 0 times
...

Save Cancel