CompTIA
Checkpoint
ISC
HP
Dell
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
Certiport
ISC2
All Vendors
  2. Home
  3. Exams
  4. TeraData
  5. NR0-016

Free NR0-016 Exam Braindumps (page: 7)

Page 6 of 28
PDF with 108 Questions

Which two access types provide good OLTP performance? (Choose two.)

  1. Nested joins
  2. Full cylinder read
  3. Unique secondary index
  4. Non-unique secondary index

Answer(s): A,C



You have a 4-node Teradata system, with 40 AMPs and 6 PEs. By default, what is the maximum number of sessions that can be connected at the same time?

  1. 240
  2. 400
  3. 720
  4. 960
  5. 2400

Answer(s): C



What are two ways to lessen the impact of TPump on the system? (Choose two.)

  1. Apply options in the Ferret utility
  2. Add a SLEEP parameter to the TPump job
  3. Add a TENACITY parameter to the TPump job
  4. Reduce the RATE parameter in the TPump job
  5. Modify the Priority Scheduler Facility (PSF) settings

Answer(s): D,E



Which statement applies to applications written for Teradata?

  1. The applications should use set manipulation to leverage parallelism.
  2. The applications should minimize the use of extensions to ANSI SQL.
  3. The applications should use the Optimizer to resolve rules-based calculations.
  4. The applications should be written to use multiple instances of the program running in parallel.

Answer(s): A






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

NR0-016 Discussions & Posts