NR0-015 Teradata Design Architecture V2R5 Practice Exam Set 4

Which of the followingis a true statement on the subject of archiving tables with join indexes?


Options are :

  • Since the Teradata ARC utility cannot be used on a join index, you must archive the underlying tables and manually rebuild all the join indexes when you need to restore.
  • The Teradata ARC utility is sufficient if the join indexes are archived at least on a weekly basis.
  • The Teradata ARC utility cannot be used on a join index itself but it automatically recreates and repopulates all the join indexes as long as you have saved the join index definitions within a Data Dictionary archive.
  • The Teradata ARC utility is sufficient if the join indexes are archived as frequently as the data is changed.

Answer : Since the Teradata ARC utility cannot be used on a join index, you must archive the underlying tables and manually rebuild all the join indexes when you need to restore.

Which two of the following options should you take into account when calculating the size requirements for global temporary tables? (Choose two.)


Options are :

  • the archive policy for the system
  • the number of concurrent materializations per user
  • the size and number of rows per use
  • the spool requirements for the user

Answer : the number of concurrent materializations per user the size and number of rows per use

In which of the following situations should you consider using value-ordered NUSIs?


Options are :

  • when you have a high number of range constraint queries
  • when you have a high number of concurrent queries
  • when you have a high number of joins in queries
  • when you have a high number of updated rows

Answer : when you have a high number of range constraint queries

NR0-016 NCR Teradata Application Development V2R5 Exam Set 2

You are a Teradata administrator at Your company.What are two QUESTION NO:s you must consider when organizing the system into databases? (Choose two.)


Options are :

  • Which users will be doing the FastLoads of multiple tables?
  • Which views are needed to be used by the same users?
  • How frequently are the archives of the tables needed?
  • Which views are needed to have extended privileges such as update and delete?

Answer : Which views are needed to be used by the same users? Which views are needed to have extended privileges such as update and delete?

Which three extremely effective join plans is the Optimizer allowed to choose as a result of joining tables on their primary index? (Choose three.)


Options are :

  • Merge Join
  • Product Join
  • Cross Join
  • Hash Join
  • Nested Join

Answer : Merge Join Hash Join Nested Join

Of the followingstatements, which two are accurate for primary keys as compared to primary indexes? (Choose two.)


Options are :

  • The data values may not be null.
  • The data values may change over time.
  • They are logical constructs which ensure uniqueness.
  • The first objective is to control row distribution.

Answer : The data values may not be null. They are logical constructs which ensure uniqueness.

TE0-122 12 Teradata SQL Certification Practice Exam Set 2

When you are comparing MultiLoad and TPump, which are three statements that you find to be true? (Choose three.)


Options are :

  • MultiLoad uses multiple statement requests to improve performance; TPump uses multiple sessions to improve performance.
  • MultiLoad performs better as volume of changes increases; TPump performs better on low volume of changes.
  • MultiLoad updates tables from a work table; TPump updates tables from CLI parcels directly.
  • MultiLoad uses table locks; TPump uses row hash locks.

Answer : MultiLoad performs better as volume of changes increases; TPump performs better on low volume of changes. MultiLoad updates tables from a work table; TPump updates tables from CLI parcels directly. MultiLoad uses table locks; TPump uses row hash locks.

What would be an alternative archive method for a table that takes too long to execute a full archive?


Options are :

  • cluster data table archive with a full archive of the Data Dictionary
  • cluster data table archive
  • use FastExport to unload the data and FastLoad to reload the data
  • BTEQ Export

Answer : cluster data table archive with a full archive of the Data Dictionary

When you plan the allocation of system resources in Priority Scheduler, which are two vital tasks? (Choose two.)


Options are :

  • calculating how many CPU cycles are available
  • recognizing the goal of using Priority Scheduler
  • gaining an understanding of the current workload
  • defining at least four Resource Partitions for workload balance

Answer : recognizing the goal of using Priority Scheduler gaining an understanding of the current workload

TE0-141 14 Teradata Basics Certified Practice Test Set 2

What is verified by the system when a row is inserted into a referencing table and foreign key columns are defined to be NOT NULL?


Options are :

  • It verifies if a row exists in the reference index subtable with a zero count.
  • It verifies if a row exists in the referenced table that is NOT NULL.
  • It verifies if a row exists in the referenced table with the same values as those in the primary key of the referencing table.
  • It verifies if a row exists in the referenced table with the same value(s) as that in the foreign key column(s).

Answer : It verifies if a row exists in the referenced table with the same value(s) as that in the foreign key column(s).

Which of the followingis a characteristic of Permanent Journals?


Options are :

  • Permanent Journals (BEFORE and AFTER images) may be used to roll back or roll forward changes after a RENAME TABLE operation.
  • Permanent Journals may be used to roll back or roll forward changes after an ALTER TABLE operation.
  • Permanent Journals (AFTER images) allow the user to recover changes lost when tables are restored.
  • Permanent Journals allow you to create and store comments using the COMMENT ON statement.

Answer : Permanent Journals (AFTER images) allow the user to recover changes lost when tables are restored.

The elapsed time of a particular query can shorten by performing which of the following tasks? (Choose two.)


Options are :

  • delete all Performance Groups that are not being used
  • change the Priority Scheduler settings to give a higher priority to all long-running (CPU intensive) queries
  • modify the weight assigned to the Allocation Group of the session used to run the query
  • raise the priority of either the query or of the session in which it is running

Answer : modify the weight assigned to the Allocation Group of the session used to run the query raise the priority of either the query or of the session in which it is running

TE0-125 Teradata 12 Solutions Development Practice Exam Set 1

The primary index columns will differ from the primary key columns for what two reasons? (Choose two.)


Options are :

  • to increase volatility
  • join performance
  • known access paths
  • to enforce uniqueness

Answer : join performance known access paths

The amount of raw data generated by a single INSERT EXPLAIN in the Query Capture Database is affected by whichthree elements? (Choose three.)


Options are :

  • size of the SQL statement
  • size of the EXPLAIN statement output
  • average size of the tables in the query
  • number of tables and views in the query

Answer : size of the SQL statement size of the EXPLAIN statement output number of tables and views in the query

Which three statements with reference to MultiLoad are true? (Choose three.)


Options are :

  • It can load data using a view.
  • Each import task can do multiple insert, update, and delete functions.
  • It maintains all secondary indexes.
  • A maximum of five tables can be loaded at a time.

Answer : It can load data using a view. Each import task can do multiple insert, update, and delete functions. A maximum of five tables can be loaded at a time.

TE0-141 14 Teradata Basics Certified Practice Test Set 3

When writing update applications, which are three areas that should be taken into consideration? (Choose three.)


Options are :

  • when users are accessing the data
  • spool space limits for external users
  • data timeliness requirements
  • number of mini-cylpacks performed
  • processing window

Answer : spool space limits for external users number of mini-cylpacks performed

The use of global temporary tables has what two performance advantages? (Choose two.)


Options are :

  • They allow reuse of intermediate results.
  • Referential Integrity rules can be enforced
  • They share data between user sessions.
  • There are no locks placed on any objects when they are materialized or dropped.

Answer : They allow reuse of intermediate results. There are no locks placed on any objects when they are materialized or dropped.

Which three of the followingare essential Teradata RDBMS facilities for hardware fault tolerance? (Choose three.)


Options are :

  • AWS
  • redundant power supplies
  • cliques
  • RAID disk units

Answer : redundant power supplies cliques RAID disk units

NR0-013 Teradata SQL v2r5 Certification Practice Exam Set 3

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions