Snowflake COF-R02 Exam - Topic 1 Question 51 Discussion

Actual exam question for Snowflake's COF-R02 exam

Question #: 51
Topic #: 1

[All COF-R02 Questions]

Which Snowflake objects track DML changes made to tables, like inserts, updates, and deletes?

APipes

BStreams

CTasks

DProcedures

Show Suggested Answer

Suggested Answer: C

by Ernest at Feb 10, 2025, 06:00 PM

Limited Time Offer

25%

Off

Get Premium COF-R02 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Shaun

4 months ago

100% Streams! No doubt about it.

upvoted 0 times

...

Catherin

5 months ago

Wait, are you sure? I thought Procedures could do that too.

upvoted 0 times

...

Glory

5 months ago

Yeah, Streams are the way to go for that!

upvoted 0 times

...

Lezlie

5 months ago

I thought it was Tasks. Not sure about Streams.

upvoted 0 times

...

Bulah

5 months ago

Definitely Streams! They track DML changes.

upvoted 0 times

...

Dean

6 months ago

I remember reading about Pipes, but I don’t think they track DML changes like Streams do.

upvoted 0 times

...

Vivan

6 months ago

I’m a bit confused. I thought Tasks were related to scheduling, not tracking DML changes.

upvoted 0 times

...

Lorrie

6 months ago

I recall practicing a question about this, and I believe Streams were the answer. They seem to fit the description.

upvoted 0 times

...

Domonique

6 months ago

I think it might be Streams, but I’m not entirely sure. I remember something about tracking changes.

upvoted 0 times

...

Janna

6 months ago

Streams is the obvious choice here. It's the Snowflake feature built for tracking table changes.

upvoted 0 times

...

Nguyet

6 months ago

I'm leaning towards Streams, but I want to double-check the definitions of the other options just to be sure.

upvoted 0 times

...

Barney

6 months ago

Streams sounds right to me. That's the Snowflake object that captures DML changes, if I remember correctly.

upvoted 0 times

...

Aliza

6 months ago

Hmm, I'm a bit unsure about this one. I'll have to think it through carefully.

upvoted 0 times

...

Mammie

6 months ago

I'm pretty sure the answer is Streams, since they are designed to track changes to tables.

upvoted 0 times

...

Ira

11 months ago

I'm just picturing a bunch of snowflakes with little clipboards, taking notes on all the inserts, updates, and deletes. B) Streams is the way to go!

upvoted 0 times

Cherelle

9 months ago

It's like having a team of snowflake secret agents on the lookout for any changes to the tables.

upvoted 0 times

...

Alayna

10 months ago

Pipes, Tasks, and Procedures just don't have that same tracking ability.

upvoted 0 times

...

Alysa

10 months ago

Streams are like the little snowflake detectives keeping track of all the changes.

upvoted 0 times

...

Mitsue

10 months ago

I agree, B) Streams is definitely the way to go.

upvoted 0 times

...

Adaline

11 months ago

B) Streams, no doubt about it. Anything else would be like trying to use a hammer to screw in a nail. Streams are made for tracking DML changes.

upvoted 0 times

An

10 months ago

C) Tasks and Procedures are useful, but Streams are specifically designed for tracking DML changes.

upvoted 0 times

...

Catina

10 months ago

A) Pipes wouldn't be as effective for tracking DML changes as Streams.

upvoted 0 times

...

Theresia

10 months ago

B) Streams are definitely the way to go for tracking DML changes.

upvoted 0 times

...

Eun

11 months ago

Hmm, this is a tough one. I was thinking Procedures might be able to do that, but I guess B) Streams is the correct answer. Streams sound like the right tool for the job.

upvoted 0 times

Alfreda

10 months ago

I agree, Streams is the Snowflake object that tracks DML changes to tables.

upvoted 0 times

...

Wilda

11 months ago

Yes, you're right. Streams is the right tool for tracking inserts, updates, and deletes.

upvoted 0 times

...

Tonja

11 months ago

I think Streams is the correct answer. It tracks DML changes made to tables.

upvoted 0 times

...

Nu

12 months ago

I'm not sure about this one. Pipes, Tasks, and Procedures don't sound like they would track DML changes. I'm going to go with B) Streams.

upvoted 0 times

Casie

11 months ago

Yes, you're correct. Streams is the Snowflake object that tracks DML changes.

upvoted 0 times

...

Pamella

11 months ago

I think Streams is the right answer. It tracks DML changes.

upvoted 0 times

...

Carman

1 year ago

I think the answer is B) Streams. Snowflake Streams are specifically designed to track DML changes to tables.

upvoted 0 times

...

Princess

1 year ago

I'm not sure, but I think Streams make the most sense for tracking changes.

upvoted 0 times

...

Layla

1 year ago

I agree with Tyisha, Streams track DML changes to tables.

upvoted 0 times

...

Tyisha

1 year ago

I think the answer is B) Streams.

upvoted 0 times

...