Snowflake Exam COF-R02 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

Ira

3 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

1 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

2 months ago

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

upvoted 0 times

...

Alysa

2 months ago

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

upvoted 0 times

...

Mitsue

2 months ago

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

upvoted 0 times

...

Adaline

3 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

2 months ago

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

upvoted 0 times

...

Catina

2 months ago

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

upvoted 0 times

...

Theresia

2 months ago

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

upvoted 0 times

...

Eun

3 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

2 months ago

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

upvoted 0 times

...

Wilda

3 months ago

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

upvoted 0 times

...

Tonja

3 months ago

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

upvoted 0 times

...

Nu

4 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

3 months ago

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

upvoted 0 times

...

Pamella

3 months ago

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

upvoted 0 times

...

Carman

4 months ago

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

upvoted 0 times

...

Princess

4 months ago

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

upvoted 0 times

...

Layla

4 months ago

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

upvoted 0 times

...

Tyisha

4 months ago

I think the answer is B) Streams.

upvoted 0 times

...