NR0-016 NCR Teradata Application Development V2R5 Exam Set 3

A person submits a high volume of all-AMP requests. What two strategies can be used to increase parallelism? (Choose two.)


Options are :

  • use NUSIs on the tables
  • use more sessions (Correct)
  • use multi-request transactions
  • use multi-statement requests (Correct)

Answer : use more sessions use multi-statement requests

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 5

Which three SQL statements are allowed in a triggered statement? (Choose three.)


Options are :

  • CREATE
  • DELETE (Correct)
  • COMMIT
  • INSERT SELECT (Correct)
  • EXEC (Correct)

Answer : DELETE INSERT SELECT EXEC

What can handle an input data type of timestamp without conversion?


Options are :

  • FastLoad
  • Insert/Select (Correct)
  • Teradata Warehouse Builder
  • MultiLoad

Answer : Insert/Select

Consider the table t1 created as follows: CREATE TABLE t1 ( a integer, d date, v varchar(100)) PRIMARY INDEX (a) PARTITION BY RANGE_N(d BETWEEN DATE '2002-01- 01' AND DATE '2007-12-31' EACH '1' YEAR); and the query: SELECT v FROM t1 WHERE d = DATE '2003-08-17'; Which plan will the Optimizer use to find qualifying rows?


Options are :

  • full scan on a single AMP
  • value lookup on every AMP
  • single partition scan on every AMP (Correct)
  • hash lookup on each AMP
  • single partition scan on a single AMP

Answer : single partition scan on every AMP

TE0-121 12 Teradata Basics Certification Practical Exam Set 8

What are three reasons for running Visual Explain on queries during application development? (Choose three.)


Options are :

  • to calculate necessary spool space requirements
  • to validate the usage of indexes (Correct)
  • to determine access paths (Correct)
  • to establish run times
  • to determine locking profiles (Correct)

Answer : to validate the usage of indexes to determine access paths to determine locking profiles

When creating multiple triggers on the same table, which three conditions must exist so that an ORDER clause can guarantee the correct sequencing of the triggered actions? (Choose three.)


Options are :

  • They must share the same trigger event. (Correct)
  • They must share the same trigger WHEN condition.
  • They must have the same trigger type. (Correct)
  • They must have the same trigger action time. (Correct)
  • They must affect the same triggered columns.

Answer : They must share the same trigger event. They must have the same trigger type. They must have the same trigger action time.

Which application development API requires a pre-processor in addition to a compiler for a high-level language?


Options are :

  • CLI
  • ODBC
  • ECLI
  • Embedded SQL (Correct)

Answer : Embedded SQL

TE0-121 Teradata Basics Practice Test Set 1

Which two tools allow you to import workloads from other Teradata tools? (Choose two.)


Options are :

  • Statistics Wizard (Correct)
  • TSET
  • Visual Explain
  • Index Wizard (Correct)

Answer : Statistics Wizard Index Wizard

Which distribution strategy is chosen by the Optimizer when the join calls for a Merge Join of two tables with the same primary index ?


Options are :

  • choose the smaller spool file and duplicate it on all AMPs, leaving the other table in place
  • redistribute one or both tables by the column that is the join constraint
  • choose the smaller spool file, duplicate it on all AMPs, and locally copy the other table into a spool file to be prepared for the join
  • join by accessing the table rows without redistribution (Correct)
  • send all rows of the smaller table to a single AMP for processing and locally copy the larger table into a spool file on each AMP

Answer : join by accessing the table rows without redistribution

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


Options are :

  • nested joins (Correct)
  • non-unique secondary index
  • full cylinder read
  • unique secondary index (Correct)

Answer : nested joins unique secondary index

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 4

Which type of join will Teradata perform if the EXPLAIN text states "by way of a Row-hash match scan?


Options are :

  • merge (Correct)
  • hash
  • outer
  • inner
  • rowID

Answer : merge

What does the Statistics Wizard do? (Choose three.)


Options are :

  • allows for "what-if" analysis
  • allows you to schedule statistics collection (Correct)
  • makes recommendations based on table demographics (Correct)
  • allows importing of workload from other Teradata utilities (Correct)

Answer : allows you to schedule statistics collection makes recommendations based on table demographics allows importing of workload from other Teradata utilities

A referential integrity constraint exists between two tables. An attempt to insert a row in the child table is unsuccessful because the referenced value is not in the parent table. Which three are corrective actions you can take prior to inserting the row into the child table? (Choose three.)


Options are :

  • change the referencing value to null (Correct)
  • change the referencing value to a value in the parent table (Correct)
  • insert a row with the referenced value into the parent table (Correct)
  • alter the parent table to drop inconsistent references
  • delete the referencing value

Answer : change the referencing value to null change the referencing value to a value in the parent table insert a row with the referenced value into the parent table

TE0-121 Teradata Basics Practice Test Set 1

Which join strategy is a special form of a Nested Join?


Options are :

  • Correlated Join
  • Hash Join
  • RowID Join (Correct)
  • Inclusion Join

Answer : RowID Join

Denormalization is done in which phase of modeling?


Options are :

  • dimensional
  • logical
  • extended logical
  • physical (Correct)

Answer : physical

A foreign key constraint is added to a column of a table. However, there are foreign key values in the child table that reference values that are not in the parent table. What are three possible corrective actions for each row in the error table? (Choose three.)


Options are :

  • add a row with the referenced value to the parent table (Correct)
  • add a row with the referenced value to the child table
  • delete the row from the child table (Correct)
  • add a row with a null value to the parent table
  • change the referencing value in the child table to null (Correct)

Answer : add a row with the referenced value to the parent table delete the row from the child table change the referencing value in the child table to null

TE0-141 14 Teradata Basics Certified Practice Test Set 2

Consider the table t1 created as follows: CREATE TABLE t1 ( a integer, d date, v varchar(100)) PRIMARY INDEX (a) PARTITION BY RANGE N(d BETWEEN DATE '2002-01-01' AND DATE '2007-12-31' EACH '1' YEAR); and the query: SELECT v FROM t1 WHERE d = DATE '2003-08-17'; Which plan will the Optimizer use to find qualifying rows?


Options are :

  • single partition scan on a single AMP
  • hash lookup on each AMP
  • single partition scan on every AMP (Correct)
  • full scan on a single AMP
  • value lookup on every AMP

Answer : single partition scan on every AMP

Which three statements about single-column NUSIs are true? (Choose three.)


Options are :

  • Their statistics are stored in DBC.TVFields. (Correct)
  • They must be dropped prior to running MultiLoad.
  • They may be used for access if statistics do not exist on them. (Correct)
  • Their access involves row-hash level locking.
  • They can be created on an existing value-ordered NUSI column. (Correct)

Answer : Their statistics are stored in DBC.TVFields. They may be used for access if statistics do not exist on them. They can be created on an existing value-ordered NUSI column.

What three statements about the MultiLoad utility are true? (Choose three.)


Options are :

  • Duplicate rows are allowed. (Correct)
  • Near real-time updates may be achieved.
  • The Transient Journal is used to allow roll back.
  • Multiple tables may be loaded in the same job. (Correct)
  • Target tables may have secondary indexes and referential integrity. (Correct)

Answer : Duplicate rows are allowed. Multiple tables may be loaded in the same job. Target tables may have secondary indexes and referential integrity.

TE0-121 Teradata Basics Practice Test Set 3

Which two statements are true when EXPLAIN output shows 'we lock databasename.tablename for access' ? (Choose two.)


Options are :

  • The query has a table level access lock on the object. (Correct)
  • The query has a rowhash level access lock on the object.
  • The user can read the object even when it is already or concurrently locked for read or write. (Correct)
  • The user can read the object even when it is already or concurrently locked for exclusive access.

Answer : The query has a table level access lock on the object. The user can read the object even when it is already or concurrently locked for read or write.

In Teradata mode, given: INSERT INTO tbl1 SELECT * FROM tbl2 ; UPDATE tbl1 SET col1 = '400' WHERE col2 = 'abc' ; A failure (abort) occurs during the execution of the UPDATE . Which two statements are true? (Choose two.)


Options are :

  • Tbl1 will be rolled-back to its condition before the insert operation. (Correct)
  • Only th e UPDATE to tbl1 will be rolled back.
  • All locks applied will be released after the failure is processed. (Correct)
  • Write locks will be maintained after the failure is processed.

Answer : Tbl1 will be rolled-back to its condition before the insert operation. All locks applied will be released after the failure is processed.

NR0-016 NCR Teradata Application Development V2R5 Exam Set 4

Which three periodic summaries assist with capacity planning? (Choose three.)


Options are :

  • user logons and logoffs (Correct)
  • spool usage (Correct)
  • number of materialized tables
  • table growth (Correct)

Answer : user logons and logoffs spool usage table growth

What are four reasons to use a macro? (Choose four.)


Options are :

  • to ensure consistency of SQL code (Correct)
  • t o create several secondary indexes on a table
  • to enforce locking choices (Correct)
  • to limit access to data (Correct)
  • t o pass a table name dynamically as a parameter
  • to reduce parsing overhead (Correct)

Answer : to ensure consistency of SQL code to enforce locking choices to limit access to data to reduce parsing overhead

Which two distribution strategies could be chosen by the Optimizer when the join calls for a Merge Join by matching two non-indexed columns from two tables? (Choose two.)


Options are :

  • choose the smaller spool file, duplicate it on all AMPs, and locally copy the other table into a spool file to be prepared for the join (Correct)
  • redistribute one or both tables by the column that is the join constraint (Correct)
  • choose the smaller spool file and duplicate it on all AMPs, leaving the other table in place
  • join by accessing the table rows without redistribution
  • send all rows of the smaller table to a single AMP for processing and locally copy the larger table into a spool file on each AMP

Answer : choose the smaller spool file, duplicate it on all AMPs, and locally copy the other table into a spool file to be prepared for the join redistribute one or both tables by the column that is the join constraint

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 3

Which two statements are true about the following ALTER TABLE statement. (Choose two.) ALTER TABLE Table_1 ADD CHECK (Col_a > 0 OR Col_b > 0);


Options are :

  • The constraint is unnamed. (Correct)
  • Only one of the two columns may be greater than zero
  • The table must be empty.
  • A table level check constraint is place on Table_1 (Correct)
  • The constraint may be changed with the MODIFY CONSTRAINT syntax

Answer : The constraint is unnamed. A table level check constraint is place on Table_1

Which three statements about single-column NUSIs are true? (Choose three.)


Options are :

  • Their statistics are stored in DBC.TVFields. (Correct)
  • They may be used for access if statistics do not exist on them. (Correct)
  • They can be created on an existing value-ordered NUSI column. (Correct)
  • They must be dropped prior to running MultiLoad.
  • Their access involves row-hash level locking.

Answer : Their statistics are stored in DBC.TVFields. They may be used for access if statistics do not exist on them. They can be created on an existing value-ordered NUSI column.

Which four factors are important to consider when deciding whether to calculate summary results on demand or to create a summary table? (Choose four.)


Options are :

  • complexity of the calculations (Correct)
  • volatility of the column to summarize (Correct)
  • frequency of summary request (Correct)
  • response time requirements (Correct)
  • concurrency of users
  • typical rows per value

Answer : complexity of the calculations volatility of the column to summarize frequency of summary request response time requirements

TE0-141 14 Teradata Basics Certified Practice Test Set 4

Consider the following identity column definition: Col1 INTEGER GENERATED ALWAYS AS IDENTITY (MAXVALUE 100) Which two statements are true about Col1 ? (Choose two.)


Options are :

  • The table cannot have more than 100 rows. (Correct)
  • By explicitly specifying values in the insert, it is possible to skip numbers in the sequence.
  • The first inserted row will have a value of 1. (Correct)
  • Deleted rows may be replaced in the sequence.

Answer : The table cannot have more than 100 rows. The first inserted row will have a value of 1.

In the following request, one employee has a null Manager_Number . SELECT Manager_Number FROM Department WHERE Manager_Number NOT IN (SELECT Manager_Number FROM Employee); Which two statements about the result are true? (Choose two.)


Options are :

  • No rows returned means all Manager_Number values from the Department table found a match.
  • The condition WHERE Manager_Number IS NOT NULL should be added to the subquery. (Correct)
  • No rows will be returned. (Correct)
  • All unmatched Manager_Number values from the Department table will be returned, if any.

Answer : The condition WHERE Manager_Number IS NOT NULL should be added to the subquery. No rows will be returned.

Which information is useful when determining resource impacts during application testing? (Choose three.)


Options are :

  • AMP utilization (Correct)
  • parallel efficiency at different time intervals (Correct)
  • errors occurring during data loading
  • user growth predictions
  • spool space peaks (Correct)

Answer : AMP utilization parallel efficiency at different time intervals spool space peaks

TE0-121 12 Teradata Basics Certification Practical Exam Set 6

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions