Free NR0-014 Exam Braindumps (page: 9)

Page 8 of 26

Which two activities can the Teradata Statistics Wizard perform? (Choose two.)

  1. recommend secondary indexes
  2. execute statistics collection recommendations
  3. display current versus captured statistics information
  4. reproduce Optimizer related issues in a test environment
  5. recommend recollection of statistics based on table skew

Answer(s): B,E



Which three activities can you control using Teradata Manager profiles? (Choose three.)

  1. the ability to change a profile
  2. the number of concurrent users
  3. the start time for auto-start applications
  4. the Data Dictionary tables available to the user
  5. the functions available through drop-down menus

Answer(s): A,C,E



What are two benefits of Teradata Manager? (Choose two.)

  1. It provides session-level resource usage data.
  2. It provides data as detailed as ResUsage data.
  3. It acquires data in near real-time with less overhead.
  4. It accumulates large amounts of data over a long period.

Answer(s): A,C



Which two tools can be used to identify an inappropriate job mix? (Choose two.)

  1. filer
  2. ferret
  3. DBSControl
  4. Locking Logger
  5. Performance Monitor

Answer(s): D,E






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

NR0-014 Discussions & Posts