Free NR0-016 Exam Braindumps (page: 6)

Page 5 of 28

What are three reasons for running Visual Explain on queries during application development? (Choose three.)

  1. To establish run times
  2. To determine access paths
  3. To determine locking profiles
  4. To validate the usage of indexes
  5. To calculate necessary spool space requirements

Answer(s): B,C,D



What does the Statistics Wizard do? (Choose three.)

  1. Allows for "what-if" analysis
  2. Allows you to schedule statistics collection
  3. Makes recommendations based on table demographics
  4. Allows importing of workload from other Teradata utilities

Answer(s): B,C,D



What does the TSET utility do? (Choose two.)

  1. Creates a view of your data demographics
  2. Allows you to schedule statistics collection
  3. Allows for the importing of workloads from other Teradata utilities
  4. Allows you to import data demographics from one system to another
  5. Allows you to import system characteristics from one system to another

Answer(s): D,E



Which two tools allow you to import workloads from other Teradata tools? (Choose two.)

  1. TSET
  2. Index Wizard
  3. Visual Explain
  4. Statistics Wizard

Answer(s): B,D






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

NR0-016 Discussions & Posts