SnowPro Advanced Architect Exam

Exam SnowPro Advanced Architect All QuestionsBrowse all questions from this exam

Question 33

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?

All rows loaded using a specific COPY statement will have varying timestamps based on when the rows were inserted.

Any rows loaded using a specific COPY statement will have varying timestamps based on when the rows were read from the source.

Any rows loaded using a specific COPY statement will have varying timestamps based on when the rows were created in the source.

All rows loaded using a specific COPY statement will have the same timestamp value.

Correct Answer: D

When data is loaded into a table with a column that has a default value of CURRENT_TIME() or CURRENT_TIMESTAMP(), the default value is set at the time the statement (e.g., COPY statement) is executed. Therefore, all rows loaded by that specific statement will get the same timestamp value, corresponding to the moment the statement was executed. This ensures uniformity for the load time across all rows inserted by the same operation.

Discussion

charemskiOption: D

Validated and a bit helpful: https://docs.snowflake.com/en/user-guide/data-load-transform#current-time-current-timestamp-default-column-values

hillcat111Option: D

Answer is D and is validated

hillcat111Option: C

I think C is the Answer

hillcat111

Answer is D