nerdexam
IBM

P2090-050 · Question #129

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

(33 responses)
  • A
    6% (2)
  • B
    12% (4)
  • C
    3% (1)
  • D
    79% (26)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full P2090-050 Practice