MENU
What are the possible values within a METADATASACTION column in a Snowflake stream? (Select TWO).
Suggested Answer: A, C
Get Premium COF-C02 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
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
35 comments · newest first
SH
Shaun
11 months ago
I disagree, I thought UPSERT was in there too.
RA
Raina
11 months ago
Yup, INSERT and DELETE are the right picks!
CA
Casey
11 months ago
Wait, can TRUNCATE even be a value? Seems off.
TW
Twana
11 months ago
I think UPDATE is also a possible value!
GL
Glenna
11 months ago
Definitely INSERT and DELETE are valid options.
DE
Detra
12 months ago
I definitely recall INSERT being one of the values, but I’m torn between UPDATE and UPSERT for the second choice.
MA
Marg
12 months ago
I’m a bit confused about TRUNCATE. I feel like it could be a valid option, but I’m not certain if it’s included in the METADATASACTION column.
LA
Lavina
12 months ago
I practiced a similar question last week, and I think UPDATE and DELETE were mentioned as possible values.
MA
Margurite
1 year ago
I remember studying the METADATASACTION column, but I’m not entirely sure which values are correct. I think INSERT and DELETE might be options.
SH
Shonda
1 year ago
I'm a little confused by this question. I know Snowflake has streams, but I'm not super familiar with the metadata associated with them. I'll have to do some quick research to refresh my memory on this topic.
CH
Cheryl
1 year ago
This is a good question to test our knowledge of Snowflake stream metadata. I'm going to review the options and eliminate any that don't seem like valid DML operations for a stream.
DO
Doyle
1 year ago
Okay, let me see. The metadata for a Snowflake stream should include the basic DML operations, so I'm guessing INSERT and UPDATE are two of the possible values. I'll double-check the other options to be sure.
RO
Rodolfo
1 year ago
Hmm, I'm a bit unsure about this one. I know Snowflake streams have metadata, but I can't recall the specific values off the top of my head. I'll have to think this through carefully.
GL
Glynda
1 year ago
This looks like a straightforward question about Snowflake stream metadata. I'm pretty confident I can identify the two correct values here.
TA
Talia
1 year ago
This seems like a straightforward question about equipment replacement decisions. I think the key is to focus on the factors that don't affect the decision-making process.
BE
Berry
2 years ago
I'm pretty sure the answer is 42. That's the answer to everything, right?
AB
Abel
2 years ago
B) UPDATE
MI
Micheal
2 years ago
A) INSERT
GE
Gerald
2 years ago
Ooh, what about E) UPSERT? I feel like that's a common operation in data warehousing, so it might be included too.
AN
Angelyn
2 years ago
I'm just here for the free snacks. Can we get some popcorn in the exam room?
LE
Lenora
2 years 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.
DE
Desmond
2 years ago
In Snowflake streams, the possible values are INSERT, UPDATE, DELETE, and UPSERT.
LE
Leslie
2 years ago
You're right, TRUNCATE is not a valid value in the METADATA$ACTION column.
AU
Audrie
2 years ago
I think TRUNCATE events are not supported in Snowflake streams.
BA
Basilia
2 years ago
I'm not sure about DELETE, but I think TRUNCATE is not a valid value.
DO
Dorothea
2 years ago
I agree with Julene, INSERT and UPDATE make sense for METADATASACTION.
SO
Socorro
2 years 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?
RO
Rolf
2 years ago
B) UPDATE
LA
Lakeesha
2 years ago
A) INSERT
JU
Julene
2 years ago
I think the possible values are INSERT and UPDATE.
MO
Monte
2 years 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.
CR
Cristal
2 years ago
Yes, those are the possible values for a METADATASACTION column in a Snowflake stream.
MA
Marci
2 years ago
I think you're right, A) INSERT and B) UPDATE make sense for metadata actions.
JA
Jaclyn
2 years ago
Yeah, those are the most common actions you would see in a metadata stream.
TR
Trinidad
2 years ago
I think you're right, INSERT and UPDATE make sense for metadata actions.