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

Page 1 of 28
PDF with 110 Questions

When creating an identity column as GENERATED ALWAYS, which statement is true?

  1. The column may be used in a join index.
  2. The column may be updated by an SQL statement.
  3. The column may be used to define the primary index.
  4. The column is used to facilitate copying data from one table into another.

Answer(s): C



What type of query population benefits from a sparse index?

  1. queries that often redistribute a large table
  2. queries that repeatedly use the same subset of the table
  3. queries that rarely redistribute a large table in complex join processing
  4. queries that often return a large percent of the rows of a large table based on the primarykey
  5. queries that often eliminate a large percent of the rows of a large table using a superset of the table

Answer(s): B



Which utility supports multiple sources of data coming from multiple platforms concurrently?

  1. BTEQ
  2. MultiLoad
  3. FastLoad
  4. Teradata Warehouse Builder

Answer(s): D



How will a query be affected when run against a table without Fallback if an AMP is down?

  1. The query will not execute under these conditions.
  2. The query will execute and return data from all AMPs.
  3. The query will execute only if it does not require data from the down AMP.
  4. The query will always execute and return data from only the AMPs that are available.

Answer(s): C






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

NR0-015 Discussions & Posts