When created, a stream logically takes an initial snapshot of every row in the source object and the contents of a stream change as DML statements execute on the source table.
A Data Engineer, Sophie Created a view that queries the table and returns the CURRENT_USER and CURRENT_TIMESTAMP values for the query transaction. A Stream has been created on views to capture CDC.
Tony, another user inserted the data e.g.
insert into
values (1),(2),(3); Emily, another user also inserted the data e.g.
insert into
values (4),(5),(6); What will happened when Different user queries the same stream after 1 hour?

Question

When created, a stream logically takes an initial snapshot of every row in the source object and the contents of a stream change as DML statements execute on the source table.

A Data Engineer, Sophie Created a view that queries the table and returns the CURRENT_USER and CURRENT_TIMESTAMP values for the query transaction. A Stream has been created on views to capture CDC.

Tony, another user inserted the data e.g.

insert into <table> values (1),(2),(3); Emily, another user also inserted the data e.g.

insert into <table> values (4),(5),(6); What will happened when Different user queries the same stream after 1 hour?

values (4),(5),(6); What will happened when Different user queries the same stream after 1 hour?

ERIK BURDETT · Accepted Answer

All the Six Records would be displayed with CURRENT_USER & CUR-RENT_TIMESTAMP while querying Streams.

ERIK BURDETT · Answer

All the 6 records would be shown with METADATA$ACTION as 'INSERT' out of which 3 records would be displayed with username 'Tony' & rest 3 records would be displayed with username 'Emily'.

ERIK BURDETT · Answer

All the Six records would be displayed with User 'Sohpie' Who is the owner of the View.

ERIK BURDETT · Answer

User would be displayed with the one who queried during the session, but Recorded timestamp would be of past 1 hour i.e. actual records insertion time.

Question list

List of questions

Question 1

(0)

Question 2

(0)

Question 3

(0)

Question 4

(0)

Question 5

(0)

Question 6

(0)

Question 7

(0)

Question 8

(0)

Question 9

(0)

Question 10

(0)

Related questions

Question 12 - DEA-C01 discussion

Suggested answer: B

0 comments