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

3 months ago

100% Streams! No doubt about it.

upvoted 0 times

...

Catherin

3 months ago

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

upvoted 0 times

...

Glory

3 months ago

Yeah, Streams are the way to go for that!

upvoted 0 times

...

Lezlie

4 months ago

I thought it was Tasks. Not sure about Streams.

upvoted 0 times

...

Bulah

4 months ago

Definitely Streams! They track DML changes.

upvoted 0 times

...

Dean

4 months ago

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

upvoted 0 times

...

Vivan

4 months ago

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

upvoted 0 times

...

Lorrie

4 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

5 months ago

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

upvoted 0 times

...

Janna

5 months ago

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

upvoted 0 times

...

Nguyet

5 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

5 months ago

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

upvoted 0 times

...

Aliza

5 months ago

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

upvoted 0 times

...

Mammie

5 months ago

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

upvoted 0 times

...

Ira

9 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

8 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

8 months ago

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

upvoted 0 times

...

Alysa

9 months ago

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

upvoted 0 times

...

Mitsue

9 months ago

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

upvoted 0 times

...

Adaline

10 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

9 months ago

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

upvoted 0 times

...

Catina

9 months ago

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

upvoted 0 times

...

Theresia

9 months ago

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

upvoted 0 times

...

Eun

10 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

9 months ago

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

upvoted 0 times

...

Wilda

9 months ago

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

upvoted 0 times

...

Tonja

9 months ago

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

upvoted 0 times

...

Nu

10 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

10 months ago

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

upvoted 0 times

...

Pamella

10 months ago

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

upvoted 0 times

...

Carman

10 months ago

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

upvoted 0 times

...

Princess

10 months ago

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

upvoted 0 times

...

Layla

11 months ago

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

upvoted 0 times

...

Tyisha

11 months ago

I think the answer is B) Streams.

upvoted 0 times

...