Snowflake Exam COF-C02 Topic 6 Question 40 Discussion

Actual exam question for Snowflake's COF-C02 exam

Question #: 40
Topic #: 6

[All COF-C02 Questions]

What are the possible values within a METADATASACTION column in a Snowflake stream? (Select TWO).

AINSERT

BUPDATE

CDELETE

DTRUNCATE

EUPSERT

Show Suggested Answer

Suggested Answer: A, C

In Snowflake streams, the METADATASACTION column indicates the type of data manipulation operation that has occurred. The possible values include INSERT and DELETE.

INSERT: Indicates that a new row has been inserted into the table.

DELETE: Indicates that a row has been deleted from the table.

References:

Snowflake Documentation: Change Data Capture (CDC) with Streams

Snowflake Documentation: Stream Data Capture

by Benedict at Sep 10, 2024, 08:50 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Berry

10 months ago

I'm pretty sure the answer is 42. That's the answer to everything, right?

upvoted 0 times

Abel

9 months ago

B) UPDATE

upvoted 0 times

...

Micheal

10 months ago

A) INSERT

upvoted 0 times

...

Gerald

10 months ago

Ooh, what about E) UPSERT? I feel like that's a common operation in data warehousing, so it might be included too.

upvoted 0 times

...

Angelyn

10 months ago

I'm just here for the free snacks. Can we get some popcorn in the exam room?

upvoted 0 times

...

Lenora

10 months ago

Hmm, I don't know about that. What if we need to handle TRUNCATE events as well? Maybe D) TRUNCATE should be one of the options.

upvoted 0 times

Desmond

9 months ago

In Snowflake streams, the possible values are INSERT, UPDATE, DELETE, and UPSERT.

upvoted 0 times

...

Leslie

9 months ago

You're right, TRUNCATE is not a valid value in the METADATA$ACTION column.

upvoted 0 times

...

Audrie

10 months ago

I think TRUNCATE events are not supported in Snowflake streams.

upvoted 0 times

...

Basilia

10 months ago

I'm not sure about DELETE, but I think TRUNCATE is not a valid value.

upvoted 0 times

...

Dorothea

11 months ago

I agree with Julene, INSERT and UPDATE make sense for METADATASACTION.

upvoted 0 times

...

Socorro

11 months ago

Hold up, I think C) DELETE should be in there too. You can't have a metadata stream without being able to track deletions, right?

upvoted 0 times

Rolf

11 months ago

B) UPDATE

upvoted 0 times

...

Lakeesha

11 months ago

A) INSERT

upvoted 0 times

...

Julene

11 months ago

I think the possible values are INSERT and UPDATE.

upvoted 0 times

...

Monte

11 months ago

I'm pretty sure it's A) INSERT and B) UPDATE. Those seem like the most logical options for a metadata stream in Snowflake.

upvoted 0 times

Cristal

11 months ago

Yes, those are the possible values for a METADATASACTION column in a Snowflake stream.

upvoted 0 times

...

Marci

11 months ago

I think you're right, A) INSERT and B) UPDATE make sense for metadata actions.

upvoted 0 times

...

Jaclyn

11 months ago

Yeah, those are the most common actions you would see in a metadata stream.

upvoted 0 times

...

Trinidad

11 months ago

I think you're right, INSERT and UPDATE make sense for metadata actions.

upvoted 0 times

...