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: 8)

Page 7 of 28
PDF with 110 Questions

Which type of table allows sharing of data across user sessions?

  1. derived
  2. volatile
  3. permanent
  4. global temporary

Answer(s): C



Which two statements are true about a dimensional data model? (Choose two.)

  1. It is extremely flexible.
  2. It often implements fewer tables.
  3. It requires significantly less ETL activity.
  4. It reduces the need for summary tables.
  5. It can be adapted to optimize performance.

Answer(s): B,E



Which three statements are true about data compression? (Choose three.)

  1. CPU path length associated with the I/Os saved is substantial.
  2. It reduces the overhead for storing variable character data.
  3. The actual uncompressed values are stored in the table header.
  4. It can achieve substantial reduction of space for both numeric and character data.

Answer(s): A,C,D



What are two reasons for considering Partitioned Primary Index (PPI) on a table? (Choose two.)

  1. to reduce the amount of I/O needed to process queries
  2. to reduce the number of columns in a table to those needed by most queries
  3. to eliminate ranges of data values from a query and thereby reduce scan time
  4. to reduce response time by placing all data in the same partition on the same AMP

Answer(s): A,C






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

NR0-015 Discussions & Posts