nerdexam
IBM

A2090-560 · Question #61

Within a single PureData System for Analytics, what is the fastest way to copy a 10TB TableA from DatabaseA to another DatabaseB?

The correct answer is D. Use a CTAS (Create Table as Select) SQL statement. See the full explanation below for the reasoning.

Question

Within a single PureData System for Analytics, what is the fastest way to copy a 10TB TableA from DatabaseA to another DatabaseB?

Options

  • AUse the COPY command.
  • BUse external tables and UNIX pipes.
  • CUse nzbackup and nzrestore commands.
  • DUse a CTAS (Create Table as Select) SQL statement.

How the community answered

(28 responses)
  • A
    14% (4)
  • B
    4% (1)
  • C
    4% (1)
  • D
    79% (22)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full A2090-560 Practice