Free NR0-015 Exam Braindumps (page: 14)

Page 13 of 28

An existing table has a Referential Integrity constraint.What are two ways to add new rows to the table? (Choose two.)

  1. use TPump to insert the new rows
  2. insert the new rows with FastLoad
  3. drop the Referential Integrity constraint and MultiLoad the new rows
  4. use MultiLoad if the table contains the primary key not the foreign key

Answer(s): A,C



Table X has a Partitioned Primary Index (PPI), NUSIs, and an USI defined on it.
What can be used for daily maintenance? (Choose two.)

  1. TPump
  2. MultiLoad
  3. Teradata Warehouse Builder Load Operator
  4. FastLoad into an empty Table Y, then INSERT/SELECT into Table X

Answer(s): A,D



Which two utilities require an empty target table when loading data? (Choose two.)

  1. MultiLoad
  2. FastLoad
  3. FastExport
  4. Teradata Warehouse Builder Load operator

Answer(s): B,D



Which two methods can be used to update a table that has a join index? (Choose two.)

  1. TPump
  2. MultiLoad
  3. Teradata Warehouse Builder Apply Operator
  4. FastLoad into an empty table and INSERT/SELECT into the target table

Answer(s): A,D






Post your Comments and Discuss TeraData NR0-015 exam with other Community members:

NR0-015 Discussions & Posts