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
Mail Us support@pass4success.com
Location PL
Mob_nav_barsMENU

Snowflake Exam DSA-C02 Topic 1 Question 21 Discussion

Actual exam question for Snowflake's DSA-C02 exam
Question #: 21
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 Susy at Jun 20, 2024, 11:32 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel
Lawrence
5 months ago
Because Snowflake does not automatically resize and scale compute resources for serverless tasks.
upvoted 0 times
...
Penney
6 months ago
Option B sounds like it could be a good trick question. I better read the details carefully on that one.
upvoted 0 times
...
Pamella
6 months ago
Whoa, I'm glad I don't have to worry about manually managing the compute resources for my Snowflake tasks. That would be a headache!
upvoted 0 times
...
Yun
6 months ago
Why do you think it's A?
upvoted 0 times
...
Lawrence
6 months ago
I disagree, I believe the incorrect statement is A.
upvoted 0 times
...
Ronald
6 months ago
Wait, Snowflake can automatically resize and scale the compute resources for serverless tasks? That's pretty cool, I didn't know that!
upvoted 0 times
Wendell
5 months ago
It's a great feature that makes managing tasks much easier.
upvoted 0 times
...
Alverta
5 months ago
Yes, that's right! Snowflake can automatically resize and scale the compute resources for serverless tasks.
upvoted 0 times
...
...
Yun
6 months ago
I think the incorrect statement is D.
upvoted 0 times
...
Augustine
6 months ago
I think option D is incorrect. Standard-only streams track both inserts and updates, not just inserts.
upvoted 0 times
Titus
5 months ago
Snowflake automatically resizes and scales the compute resources for serverless tasks.
upvoted 0 times
...
Vivan
5 months ago
That's right, Snowflake ensures only one instance of a task with a schedule is executed at a given time.
upvoted 0 times
...
Fidelia
6 months ago
I agree, option D is incorrect. Standard-only streams track both inserts and updates.
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