Question 410
The team wants to record when the COPY reader began scanning a staged source. Which metadata field fits?
Explanation
Correct Answer
Correct: the scan start time. METADATA$START_SCAN_TIME records the timestamp at which a staged file's scan began.
Incorrect Answers
Incorrect for the stated load scenario: METADATA$FILENAME reports the staged source file path for an input row; it does not provide the scan start time.
Incorrect for the stated load scenario: METADATA$FILE_ROW_NUMBER reports the row number in a staged source file; it does not provide the scan start time.
Incorrect for the stated load scenario: METADATA$FILE_CONTENT_KEY identifies a file's content using supported metadata; it does not provide the scan start time.