Free NR0-015 Exam Braindumps (page: 12)

Page 11 of 28

Which three areas should be considered when writing update applications? (Choose three.)

  1. processing window
  2. data timeliness requirements
  3. when users are accessing the data
  4. number of mini-cylpacks performed
  5. spool space limits for external users

Answer(s): A,B,C



How do secondary indexes support real-time data requirements?

  1. require no extra disk access
  2. require less row header space
  3. are maintained with the base table
  4. completely eliminate full table scans
  5. are given priority in the Optimizer queue

Answer(s): C



Which three statements are true about the creation and use of indexes? (Choose three.)

  1. Hash indexes are created in order to allow the Optimizer to choose hash joins.
  2. A Unique Secondary Index entry might not reside on the same AMP as the base table row.
  3. All secondary, hash, and join indexes are stored in subtables, so they require additionalstorage space.
  4. Index subtables are updated each time an indexed column value in the base table isupdated or deleted.

Answer(s): B,C,D



Which three software components run on a Teradata network-attached client? (Choose three.)

  1. CLI
  2. TDP
  3. MOSI
  4. MTDP
  5. BYNET

Answer(s): A,C,D






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

NR0-015 Discussions & Posts