TE0-123 Teradata 12 Physical Design & Implementation Exam Set 1

A database restore is being performed when a restart occurs. A user attempts to submit queries against one of the tables that was being restored, but the query fails. Why is the user's query unable to complete?


Options are :

  • The RELEASE LOCK statement was not executed against the database.
  • The rollback operation is not complete and the utility locks remain.
  • Therollforward operation is not complete and the utility locks remain
  • The RELEASE LOCK statement was not executed against the table.

Answer : The RELEASE LOCK statement was not executed against the table.

TE0-124 Teradata 12 Database Administration Practice Exam Set 5

Which statement is true about specifying a journal option during table definition?


Options are :

  • Protection for data in a new table defaults to that specified for the database in which the table is created.
  • It can only be assigned with a CREATE TABLE statement.
  • The journal table must exist in the database being used or a parent of that database.
  • If the table header undergoes changes, permanent journalrollforward and rollback operations from previous table header versions are no longer valid.

Answer : The journal table must exist in the database being used or a parent of that database.

An insurance Claims table is partitioned by range using the claim_date column and has a NUPI on column insured_id. The Claims table has 30 million rows, capturing data for the insurance company's three million customers. Given the following query: SELECT * FROM Claims WHERE insured_id = 2566898; What would improve the performance of this query


Options are :

  • Put a Value-Ordered NUSI oninsured id.
  • Makeinsured_id a UPI.
  • Re-partition the table byinsured id.
  • Put a NUSI oninsured_id.

Answer : Makeinsured_id a UPI.

What is a positive impact of implementing System Generated Keys via use of identity columns?


Options are :

  • improved join processing via like keys
  • . improved Dual Active environment processing
  • simplified data load transformations
  • improved value access query performance

Answer : . improved Dual Active environment processing

NR0-016 NCR Teradata Application Development V2R5 Exam Set 3

An application is being ported to Teradata that stores and calculates metrics using a variety of large integers. Both 128-bit and 256-bit integers are required to capture the results of complex calculations. Which Teradata data type should be used for these large integers?


Options are :

  • INTEGER
  • UDT
  • BIGINT
  • VARBYTE

Answer : INTEGER

A frequently run query does a count of product codes for items sold in the last 24 hours. Which index should the database administrator create to cover that query?


Options are :

  • value ordered NUSI
  • hash ordered NUSI
  • sparse single table join index
  • NUSI

Answer : NUSI

A transaction table has a CalendarDate column on which statistics have not been recently collected. A user submits a range-based query that specifies a date that is beyond the upper bound of the statistics collected for CalendarDate. Which two statements are true about the Optimizer's extrapolation technique? (Choose two.)


Options are :

  • It requires recollected statistics onCalendarDate to create a good plan.
  • It may allow statistics to be collected less frequently onCalendarDate.
  • . It may eliminate the need for collected statistics onCalendarDate.
  • It may allow statistics to be collected less frequently on the primary index.

Answer : It may allow statistics to be collected less frequently onCalendarDate. It may allow statistics to be collected less frequently on the primary index.

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 1

Which two table level attributes affect table sizing estimates? (Choose two.)


Options are :

  • Unicode
  • compression
  • partitioning
  • fallback

Answer : compression partitioning

Which two statements are true about UPIs? (Choose two.)


Options are :

  • The database can perform partial-value searches on them.
  • They may be a referenced column in a Referential Integrity constraint
  • The Optimizer can derive demographical information even without collected statistics.
  • They must be defined as NOT NULL.

Answer : The database can perform partial-value searches on them. The Optimizer can derive demographical information even without collected statistics.

Which type of Referential Integrity allows the Optimizer to utilize join elimination in the generated plan but does not enforce any restrictions when data is inserted, deleted, or updated?


Options are :

  • Soft RI
  • Batch RI
  • Standard RI
  • Explicit RI

Answer : Explicit RI

TE0-125 Teradata 12 Solutions Development Practice Exam Set 1

A call center application's high concurrency, low response time queries have required the use of multiple USIs. Which two load approaches can be used to load this application's tables? (Choose two.)


Options are :

  • FastLoad
  • MultiLoad
  • TPump
  • INSERT SELECT

Answer : MultiLoad TPump

An administrator needs to drop a column in a table that contains 100 billion rows. Which approach is the least invasive and maximizes data availability?


Options are :

  • Create a join index on the table,then use an ALTER TABLE statement to drop the column.
  • Use an ALTER TABLE statement to drop the column.
  • Add a NUSI on the table, then use an ALTER TABLE statement to drop the column.
  • Create a clone of the table without the column, drop the old table,then rename the new table.

Answer : Add a NUSI on the table, then use an ALTER TABLE statement to drop the column.

Which action will help conserve disk space?


Options are :

  • Specify a limit on spool space for users in their profile.
  • Use theDBQL.LogSQL table instead of the DBQL.LogSummary table.
  • Set permanent space limits for each table that is created.
  • Use a low number for the Cylinders saved forPERM setting.

Answer : Use a low number for the Cylinders saved forPERM setting.

TE0-141 14 Teradata Basics Certified Practice Test Set 3

A table has been partitioned using the RANGE_N function and includes the NO RANGE and UNKNOWN partitions. There are gaps in the ranges and the designer needs to add new partitions to fill the gaps. The data in the NO RANGE partitions must be checked against the new partitions. Which procedure should be used?


Options are :

  • Submit an ALTER TABLE statement to add the new partitions, extract the data from the NO RANGE and UNKNOWN partitions, and import the data into the existing table.
  • Create another table with the new partition definition, then extract the data from the NO RANGE and UNKNOWN partitions and import the data into the new table.
  • Create another table with the new partition definition, then submit an INSERT SELECT statement to populate the new table.
  • Submit an ALTER TABLE statement to add the new partitions, then data from the NO RANGE and UNKNOWN partitions will automatically be checked against the added partitions.

Answer : Submit an ALTER TABLE statement to add the new partitions, extract the data from the NO RANGE and UNKNOWN partitions, and import the data into the existing table.

In DBSControl, FreeSpacePercent=5, PermDBSize=254, and PermDBAllocUnit=1. FastLoad is used to load 100,000,000 rows into a data table and TPump is then used to add 25,000,000 rows to the same table. When creating this table, which option can be used to minimize the amount of space that this table will use after both loads have completed?


Options are :

  • MAXIMUM DATABLOCKSIZE
  • FREESPACE=15
  • MINIMUM DATABLOCKSIZE
  • FREESPACE=0
  • CHECKSUM=LOW

Answer : FREESPACE=0

When will random AMP samples be collected?


Options are :

  • at the four-hour interval when the dictionary cache is flushed
  • when the Optimizer requires demographics on secondary indexes
  • at the start of query optimization only if random samples for each table in the query are not found in the dictionary cache
  • when it is determined that no collected statistics exist for a column that is used for selection by the query

Answer : at the four-hour interval when the dictionary cache is flushed

TE0-123 Teradata 12 Physical Design & Implementation Exam Set 2

Which method could be used to uncover embedded views when applications are running longer than agreed upon in Service Level Agreements (SLAs)?


Options are :

  • UseTeradata Workload Analyzer to identify queries and calculate Service Level Goals (SLGs).
  • Analyze Total CPU Time, Total I/O Count, and Elapsed Time in TDWM.
  • Use the DBQL Summary table to identify individual queries and evaluate query performance.
  • Read the EXPLAIN plan to find similar steps that repeat excessively.

Answer : UseTeradata Workload Analyzer to identify queries and calculate Service Level Goals (SLGs).

What is an advantage of Global Temporary Tables?


Options are :

  • They allow column values to be compressed.
  • Their rows are stored in spool space and do not require permanent storage to be allocated.
  • A local copy is materialized when referenced.
  • No privilege checking is performed.

Answer : No privilege checking is performed.

A table has been partitioned using the RANGE_N function and includes the NO RANGE partition. The data in the older partitions at the beginning of the range needs to be removed. How should the old partitions be removed?


Options are :

  • Submit an ALTER TABLE statement to drop the specified partitions using the WITH INSERT option into a temporary table, followed by a DROP TABLE statement to drop the temporary table.
  • Submit an ALTER TABLE statement to drop the specified partitions using the WITH DELETE option.
  • Submit an ALTER TABLE statement to drop the NO RANGE partition, followed by an ALTER TABLE statement to drop the specified partitions using the WITH DELETE option.
  • Submit a DELETE statement identifying the ranges to delete, followed by an ALTER TABLE statement to drop the specified partitions using the WITH DELETE option.

Answer : Submit an ALTER TABLE statement to drop the NO RANGE partition, followed by an ALTER TABLE statement to drop the specified partitions using the WITH DELETE option.

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 1

The following repositories need to be created on a system: - a repository holding the retail data - a repository holding the inventory data - a repository holding views for each - a repository holding stored procedures (includes some dynamic SQL procedures) Which one must be implemented as a User with space allocated?


Options are :

  • stored procedures
  • retail data
  • views
  • inventory data

Answer : views

Which two column level attributes affect table sizing estimates? (Choose two.)


Options are :

  • journaling
  • Unicode
  • fallback
  • compression

Answer : fallback compression

TE0-141 14 Teradata Basics Certified Practice Test Set 3

A user submits a series of multi-statement requests that include updates against multiple tables. An ARC dump operation is executed on one of the tables. A restart occurs, and when the system comes back up the ARC job is not restarted and the user's query is blocked. Which two will allow the user's query to successfully complete? (Choose two.)


Options are :

  • The user who executed the ARC job must release the host utility lock.
  • The user who is locked out can use theShowlocks utility to release the lock.
  • The user should resubmit the job as the restart automatically released the lock.
  • The database administrator can execute the RELEASE LOCK command.

Answer : The user who is locked out can use theShowlocks utility to release the lock. The user should resubmit the job as the restart automatically released the lock.

FastLoad is used to load 100,000,000 rows into a data table. TPump is then used to add 25,000,000 rows to the same table. When creating this table, which option can be used to minimize the amount of space that this table will use after both loads have completed?


Options are :

  • CHECKSUM=LOW
  • MINIMUM DATABLOCKSIZE
  • FREESPACE=0
  • FREESPACE=15
  • MAXIMUM DATABLOCKSIZE

Answer : MAXIMUM DATABLOCKSIZE

A bank has a requirement to perform asynchronous processing on transactions that are 'possibly interesting' based on business rules, (e.g., a large deposit.) They use a simple trigger to test upon INSERT/UPDATE whether an update meets this criteria. If a transaction passes this test, which two steps might the application perform? (Choose two.)


Options are :

  • Use a trigger to perform simple data mining against a queue table
  • Place the event into a queue table for further analysis.
  • Run a polling loop that repeatedly "peeks" into a queue table while waiting for an event to occur.
  • Use an external stored procedure to "pop" the row from a queue table.

Answer : Use a trigger to perform simple data mining against a queue table Run a polling loop that repeatedly "peeks" into a queue table while waiting for an event to occur.

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 1

Analysis of a set of queries against a large table with 150 columns has identified that only five of the columns have a high access frequency. One of these columns is a BIGINT and is used to qualify rows using an equality condition. Which index(s) could vertically partition the five columns to improve performance to the largest degree?


Options are :

  • Create a covering composite NUSI.
  • Create a covering Value Ordered NUSI.
  • Create multiple single column NUSIs to cover the query.
  • Create a covering hash ordered NUSI.

Answer : Create a covering Value Ordered NUSI.

A transaction table has a CalendarDate column on which statistics have not been recently collected. A user submits a range-based query that specifies a date that is beyond the upper bound of the statistics collected for CalendarDate. Which two statements are true about the Optimizer's extrapolation technique? (Choose two.)


Options are :

  • It may result in a better estimate ifCalendarDate has a relatively constant number of rows per value.
  • It requires recollected statistics onCalendarDate to create a good plan.
  • It may allow statistics to be collected less frequently onCalendarDate.
  • It may allow statistics to be collected less frequently on the primary index.
  • It may eliminate the need for collected statistics onCalendarDate.

Answer : It may allow statistics to be collected less frequently onCalendarDate. It may allow statistics to be collected less frequently on the primary index.

A large transaction table for a global implementation is being created that has the columns Region_Id, Location_Id, and Transaction_Dt. The table will contain five years of data and the filters will primarily be on the columns identified. In reviewing the data demographics, the designer sees the following: The Region_Id has 10 distinct values The Location_Id has 2,000 distinct values The Transaction_Dt typically has 200,000 rows per value What is the optimal implementation in terms of request performance?


Options are :

  • Implement MLPPI onRegion Id (higher) Transaction_Dt (lower).
  • Implement MLPPI onTransaction Dt (highest), Location_Id, Region_Id (lowest).
  • Implement MLPPI onRegion Id (highest), Location Id, Transaction_Dt (lowest).
  • Implement MLPPI onTransaction Dt (higher) and Location_Id (lowest).

Answer : Implement MLPPI onRegion Id (highest), Location Id, Transaction_Dt (lowest).

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 4

Which two locking strategies may be used to increase request concurrency? (Choose two.)


Options are :

  • Use the lockingmodifier LOCKING ROW FOR ACCESS.
  • Add the NOWAIT option to a locking modifier.
  • Set an isolation levelof SERIALIZABLE for the session.
  • Set READ UNCOMMITTED as a session characteristic

Answer : Add the NOWAIT option to a locking modifier. Set READ UNCOMMITTED as a session characteristic

Referential Integrity has been implemented on two tables. When a row is deleted from the referenced table, a Full Table Scan (FTS) of the referencing table is performed if an index does not exist on the Foreign Key column. Which type of Referential Integrity was implemented?


Options are :

  • Application RI
  • Explicit RI
  • Standard RI
  • Soft RI
  • Batch RI

Answer : Application RI

A query is retrieving data from two very large tables that have different primary indexes. Which type of index could be used to optimize the query plan and avoid data redistribution and join processing?


Options are :

  • composite NUSI on the join columns
  • single table join index
  • hash index
  • multi-table join index

Answer : single table join index

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 3

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions