ExamGecko
Question list
Search
Search

Question 20 - DSA-C02 discussion

Report
Export

Which are the following additional Metadata columns Stream contains that could be used for creating Efficient Data science Pipelines & helps in transforming only the New/Modified data only?

A.
METADATA$ACTION
Answers
A.
METADATA$ACTION
B.
METADATA$FILE_ID
Answers
B.
METADATA$FILE_ID
C.
METADATA$ISUPDATE
Answers
C.
METADATA$ISUPDATE
D.
METADATA$DELETE
Answers
D.
METADATA$DELETE
E.
METADATA$ROW_ID
Answers
E.
METADATA$ROW_ID
Suggested answer: A, C, E

Explanation:

A stream stores an offset for the source object and not any actual table columns or data. When que-ried, a stream accesses and returns the historic data in the same shape as the source object (i.e. the same column names and ordering) with the following additional columns:

METADATA$ACTION

Indicates the DML operation (INSERT, DELETE) recorded.

METADATA$ISUPDATE

Indicates whether the operation was part of an UPDATE statement. Updates to rows in the source object are represented as a pair of DELETE and INSERT records in the stream with a metadata column METADATA$ISUPDATE values set to TRUE.

Note that streams record the differences between two offsets. If a row is added and then updated in the current offset, the delta change is a new row. The METADATA$ISUPDATE row records a FALSE value.

METADATA$ROW_ID

Specifies the unique and immutable ID for the row, which can be used to track changes to specific rows over time.

asked 23/09/2024
Mariusz Szczubelek
35 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first