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-015

Free NR0-015 Exam Braindumps (page: 9)

Page 8 of 28
PDF with 110 Questions

Which denormalization technique can be applied to a table to help optimize query access when there are many rows that are not often used?

  1. derived data
  2. repeating groups
  3. pre-joined tables
  4. vertical partitioning
  5. horizontal partitioning

Answer(s): E



What are two characteristics of the SyncScan operation in Teradata? (Choose two.)

  1. allows more than one user to share read buffers for a table
  2. is especially powerful for transaction processing applications
  3. allows the system to reduce the processing speed of inserts into tables
  4. is enabled by the memory allocation specified in the DBSControl utility
  5. allows users to control which AMPs are to be processed first during a retrieval operation

Answer(s): A,D



Which feature enables multiple users to share the blocks that are read from a table?

  1. PreReads
  2. SyncScan
  3. Access Locking
  4. Redistribution Buffering

Answer(s): B



A join index has been created to optimize access to frequently used tables. MultiLoad is used on these tables for daily updates.
What can you do to update these tables now?

  1. modify the MultiLoad script to include the join index
  2. use the Teradata Warehouse Builder Apply Operator instead of MultiLoad
  3. drop the join index; run the MultiLoad script; recreate the join index
  4. run the MultiLoad script unchanged (The join index will automatically be updated.)

Answer(s): C






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

NR0-015 Discussions & Posts