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

6 months ago

100% Streams! No doubt about it.

upvoted 0 times

...

Catherin

6 months ago

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

upvoted 0 times

...

Glory

6 months ago

Yeah, Streams are the way to go for that!

upvoted 0 times

...

Lezlie

7 months ago

I thought it was Tasks. Not sure about Streams.

upvoted 0 times

...

Bulah

7 months ago

Definitely Streams! They track DML changes.

upvoted 0 times

...

Dean

7 months ago

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

upvoted 0 times

...

Vivan

7 months ago

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

upvoted 0 times

...

Lorrie

7 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

8 months ago

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

upvoted 0 times

...

Janna

8 months ago

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

upvoted 0 times

...

Nguyet

8 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

8 months ago

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

upvoted 0 times

...

Aliza

8 months ago

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

upvoted 0 times

...

Mammie

8 months ago

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

upvoted 0 times

...

Ira

1 year 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

11 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

11 months ago

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

upvoted 0 times

...

Alysa

12 months ago

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

upvoted 0 times

...

Mitsue

12 months ago

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

upvoted 0 times

...

Adaline

1 year 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

12 months ago

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

upvoted 0 times

...

Catina

12 months ago

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

upvoted 0 times

...

Theresia

12 months ago

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

upvoted 0 times

...

Eun

1 year 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

12 months ago

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

upvoted 0 times

...

Wilda

1 year ago

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

upvoted 0 times

...

Tonja

1 year ago

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

upvoted 0 times

...

Nu

1 year 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

1 year ago

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

upvoted 0 times

...

Pamella

1 year 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

...