nerdexam
Snowflake

COF-R02 · Question #261

What is the following SQL command used for? Select * from table(validate(t1, job_id => '_last'));

The correct answer is D. To return errors from the last executed COPY command into table t1 in the current session. See the full explanation below for the reasoning.

Question

What is the following SQL command used for? Select * from table(validate(t1, job_id => '_last'));

Options

  • ATo validate external table files in table t1 across all sessions
  • BTo validate task SQL statements against table t1 in the last 14 days
  • CTo validate a file for errors before it gets executed using a COPY command
  • DTo return errors from the last executed COPY command into table t1 in the current session

How the community answered

(24 responses)
  • A
    4% (1)
  • B
    4% (1)
  • C
    8% (2)
  • D
    83% (20)

Community Discussion

No community discussion yet for this question.

Full COF-R02 Practice