ExamGecko
Question list
Search
Search

Question 19 - DSA-C02 discussion

Report
Export

Which object records data manipulation language (DML) changes made to tables, including inserts, updates, and deletes, as well as metadata about each change, so that actions can be taken using the changed data of Data Science Pipelines?

A.
Task
Answers
A.
Task
B.
Dynamic tables
Answers
B.
Dynamic tables
C.
Stream
Answers
C.
Stream
D.
Tags
Answers
D.
Tags
E.
Delta
Answers
E.
Delta
F.
OFFSET
Answers
F.
OFFSET
Suggested answer: C

Explanation:

A stream object records data manipulation language (DML) changes made to tables, including inserts, updates, and deletes, as well as metadata about each change, so that actions can be taken using the changed data. This process is referred to as change data capture (CDC). An individual table stream tracks the changes made to rows in a source table. A table stream (also referred to as simply a ''stream'') makes a ''change table'' available of what changed, at the row level, between two transactional points of time in a table. This allows querying and consuming a sequence of change records in a transactional fashion.

Streams can be created to query change data on the following objects:

* Standard tables, including shared tables.

* Views, including secure views

* Directory tables

* Event tables

asked 23/09/2024
Solange Castro
32 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first