SnowPro Advanced: Architect — Question 44

When loading data into a table that captures the load time in a column with a default value of either CURRENT_TIME() or CURRENT_TIMESTAMP() what will occur?

Answer options

• A. All rows loaded using a specific COPY statement will have varying timestamps based on when the rows were inserted.
• B. Any rows loaded using a specific COPY statement will have varying timestamps based on when the rows were read from the source.
• C. Any rows loaded using a specific COPY statement will have varying timestamps based on when the rows were created in the source.
• D. All rows loaded using a specific COPY statement will have the same timestamp value.

Correct answer: D

Explanation

The correct answer is D because when using CURRENT_TIME() or CURRENT_TIMESTAMP() as a default value, all rows loaded in a single COPY statement will receive the same timestamp at the beginning of the load process. The other options suggest varying timestamps, which is not accurate as the default values are evaluated once per statement, not per row.