DEA-C01 Exam Dumps | As part of Table Designing, Data Engineer added a timestamp column that inserts the current timestamp

<< Prev Question Next Question >>

Question 17/57

As part of Table Designing, Data Engineer added a timestamp column that inserts the current timestamp as the default value as records are loaded into a table. The intent is to capture the time when eachrecord was loaded into the table; however, the timestamps are earlier than the LOAD_TIME column values returned by COPY_HISTORY view (Account Usage). What could be reason of this issue?

A. LOAD_TIME column values returned by COPY_HISTORY view (Account Usage) gives the same time as returned by CURRENT_TIMESTAMP.

B. CURRENT_TIMESTAMP values might be different due to query gets executed in warehouse located in different region.

C. It might be possible that Cloud Provider hosted on Snowflake belongs to region having server time zone lagging Cluster time zone of warehouse where queries get processed & committed.

D. The reason is, CURRENT_TIMESTAMP is evaluated when the load operation is com-piled in cloud services rather than when the record is inserted into the table (i.e. when the transaction for the load operation is committed).

Question 17/57

LEAVE A REPLY

Download PDF File