NR0-015 Teradata Design Architecture V2R5 Practice Exam Set 1

Your company'sdata warehouse environment has critical data that needs to be available 24 hours a day, 7 days a week. How can continual availability be ensured?


Options are :

  • send archived data to the offsite system to be loaded on a regular basis
  • keep a dual system offsite and restore the data as needed
  • archive data and keep a copy of the archived data offsite
  • develop and implement a strategy for simultaneously or near simultaneous loading of critical data to an offsite dual system

Answer : develop and implement a strategy for simultaneously or near simultaneous loading of critical data to an offsite dual system

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 1

Which two of the followingstatements are true with regard to lock levels? (Choose two.)


Options are :

  • A read lock permits modifications on the underlying data while a SELECT operation is in progress.
  • A write lock ensures that the requester has exclusive rights to the locked resource so that no other process can read from, write to, or access the locked resource in any way.
  • A write lock ensures that the requester has exclusive rights to the locked resource except for readers not concerned with data consistency.
  • A read lock ensures that no modification of that resource is permitted while a SELECT operation is in progress.

Answer : A write lock ensures that the requester has exclusive rights to the locked resource except for readers not concerned with data consistency. A read lock ensures that no modification of that resource is permitted while a SELECT operation is in progress.

Permanent space has whichtwo features? (Choose two.)


Options are :

  • It is limited at the table level.
  • It is system managed and maintained.
  • Upper limit is defined in the USER definition.
  • Disk space is pre-allocated to each database.

Answer : It is system managed and maintained. Upper limit is defined in the USER definition.

Which of the followingare compatible types of Teradata locks? (Choose two.)


Options are :

  • a read lock and a read lock
  • a write lock and an access lock
  • a write lock and a write lock
  • . a read lock and a write lock

Answer : a read lock and a read lock a write lock and an access lock

TE0-141 14 Teradata Basics Certified Practice Test Set 3

Whichare two pieces of information from DBQL that may be used to define a workload policy for TDQM? (Choose two.)


Options are :

  • the typical processing time for queries during the defined time
  • the number of AMPs running at 100% CPU during the specified time
  • the occurrence of full table scans during the specified time
  • the size of the tables involved in queries during the defined time

Answer : the typical processing time for queries during the defined time the occurrence of full table scans during the specified time

For what two reasons are allowing columns to follow consistent data types administered at the domain level important? (Choose two.)


Options are :

  • avoids data conversions
  • reduces data redistribution
  • eliminates data compression
  • eliminates need for constraints
  • reduces data storage requirements

Answer : avoids data conversions reduces data redistribution

Which three of the followingaspects should be taken into consideration when a column is chosen as a primary index? (Choose three.)


Options are :

  • stability of the data values
  • data type
  • frequency of access
  • distribution across the AMPs

Answer : stability of the data values frequency of access distribution across the AMPs

TE0-124 Teradata 12 Database Administration Practice Exam Set 5

Which are three factual statements concerning the creation and use of indexes? (Choose three.)


Options are :

  • Index subtables are updated each time an indexed column value in the base table is updated or deleted.
  • A Unique Secondary Index entry might not reside on the same AMP as the base table row.
  • All secondary, hash, and join indexes are stored in subtables, so they require additional storage space.
  • Hash indexes are created in order to allow the Optimizer to choose hash joins.

Answer : Index subtables are updated each time an indexed column value in the base table is updated or deleted. A Unique Secondary Index entry might not reside on the same AMP as the base table row. All secondary, hash, and join indexes are stored in subtables, so they require additional storage space.

The difference between the COPY and RESTORE operations of the ARC utility is best described by which two of the followingstatements? (Choose two.)


Options are :

  • A RESTORE operation moves the data from an archived file back to any Teradata system and creates a new table if one does not already exist on the target database.
  • A COPY operation moves the data from an archived file back to any Teradata system and creates a new table if one does not already exist on the target database.
  • A RESTORE operation moves the data from an archived file back to the same Teradata system from which it was archived or moves data to a different Teradata system as long as the database DBC is already restored.
  • A COPY operation moves the data from an archived file back to the same Teradata system from which it was archived or moves data to a different Teradata system as long as the database DBC is already restored.

Answer : A COPY operation moves the data from an archived file back to any Teradata system and creates a new table if one does not already exist on the target database. A RESTORE operation moves the data from an archived file back to the same Teradata system from which it was archived or moves data to a different Teradata system as long as the database DBC is already restored.

Permanent Journaling allows continuous operation In which two of the followingways? (Choose two.)


Options are :

  • All archive related activities on a Permanent Journal take significantly less time than an archive of the referenced table.
  • An archive of a Permanent Journal subtable places locks on the underlying table(s).
  • If the Permanent Journal includes After Images, the table can be archived without impeding concurrent update activity in progress.
  • It is not necessary to checkpoint a Permanent Journal when using a Group Read Lock. Answer: A,C

Answer : All archive related activities on a Permanent Journal take significantly less time than an archive of the referenced table. If the Permanent Journal includes After Images, the table can be archived without impeding concurrent update activity in progress.

TE0-01A 12 Teradata Fundamentals Certification Practice Exam Set 1

Which of the followingis an accurate statement when creating an identity column as GENERATED ALWAYS?


Options are :

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

Answer : The column may be used to define the primary index.

For columns with which two characteristics should you consider the compression allowed in Teradata, when designing tables? (Choose two.)


Options are :

  • columns with a large number of default occurrences
  • variable length character columns with nulls
  • columns with a large number of null occurrences
  • numeric columns with a large number of leading zeros

Answer : columns with a large number of default occurrences columns with a large number of null occurrences

When you run a query against a table without Fallback if an AMP is down, how will it be affected?


Options are :

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

Answer : The query will execute only if it does not require data from the down AMP.

NR0-015 Teradata Design Architecture V2R5 Practice Test Set 1

Which formula is appropriate for calculating the base table size with Fallback?


Options are :

  • (Number of blocks*Typical block size) + (Number of header bytes*2)
  • 2(Number of blocks*Typical block size) + Number of header bytes
  • 2(Number of blocks*Typical block size) - Number of header bytes
  • (Number of blocks*Typical block size) - (Number of header bytes*2)

Answer : 2(Number of blocks*Typical block size) + Number of header bytes

Sufficient data protection can be provided by a backup of your entire database using the ARC utility, in which three of the followingcircumstances? (Choose three.)


Options are :

  • when there are accidentally dropped tables, views, or macros
  • when there is a loss of the data on multiple AMPs within the same cluster
  • when global temporary tables are in use at the time of the archive operation
  • when there is a loss of data on an AMP for non-Fallback tables

Answer : when there are accidentally dropped tables, views, or macros when there is a loss of the data on multiple AMPs within the same cluster when there is a loss of data on an AMP for non-Fallback tables

A table that has a join index can be updated using which two methods? (Choose two.)


Options are :

  • TPump
  • FastLoad into an empty table and INSERT/SELECT into the target table
  • Teradata Warehouse Builder Apply Operator
  • MultiLoad

Answer : TPump FastLoad into an empty table and INSERT/SELECT into the target table

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 1

You are an administrator at Your company. Your company'sapplication finds the Partitioned Primary Index to be valuable for avoiding scans on large tables, and it has also established that primary index access (without specifying the partition key) takes significantly longer. Which of the followingis an option that will improve this?


Options are :

  • COLLECT STATISTICS on the partitioning column
  • create a non-unique secondary index on the partitioning key
  • create a unique secondary index on the columns of the primary index
  • COLLECT STATISTICS on the primary index columns individually

Answer : create a unique secondary index on the columns of the primary index

Which two are inaccurate statements about Permanent Journals? (Choose two.)


Options are :

  • They store an image of each table that has been altered using any DML statement.
  • They store images (copies) of each table both before and, optionally, after they have been updated.
  • They can store both before and after images (copies) of rows changed in one or more tables.
  • They store images (copies) of each data row that has been changed with an insert, update or delete statement.

Answer : They store an image of each table that has been altered using any DML statement. They store images (copies) of each table both before and, optionally, after they have been updated.

You are a database administrator at Your company.When determining the workload rules for TDQM, which of the followingare two sets of information provided by Teradata tools that you could use? (Choose two.)


Options are :

  • the RDBMS Setup report from Teradata Manager
  • objects accessed by users in DBQL reports
  • Logon / Off usage reports from Teradata Manager
  • the DBSControl Utility - Performance Settings

Answer : objects accessed by users in DBQL reports Logon / Off usage reports from Teradata Manager

TE0-125 Teradata 12 Solutions Development Practice Exam Set 2

Which two of the followingare features of the SyncScan operation in Teradata? (Choose two.)


Options are :

  • allows the system to reduce the processing speed of inserts into tables
  • is enabled by the memory allocation specified in the DBSControl utility
  • allows users to control which AMPs are to be processed first during a retrieval operation
  • allows more than one user to share read buffers for a table
  • is especially powerful for transaction processing applications

Answer : is enabled by the memory allocation specified in the DBSControl utility allows more than one user to share read buffers for a table

In Usage Demographics of a column, which are two factors that are considered? (Choose two.)


Options are :

  • frequency of change
  • frequency of loading data
  • frequency of join access in SQL queries
  • frequency of value access in SQL queries

Answer : frequency of join access in SQL queries frequency of value access in SQL queries

TE0-122 12 Teradata SQL Certification Practice Exam Set 2

Real-time data requirements are supported secondary indexes in which way?


Options are :

  • require no extra disk access
  • are maintained with the base table
  • are given priority in the Optimizer queue
  • completely eliminate full table scans
  • require less row header space

Answer : are maintained with the base table

Which three of the followingstatements pertaining to data compression are true? (Choose three.)


Options are :

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

Answer : The actual uncompressed values are stored in the table header. It can achieve substantial reduction of space for both numeric and character data CPU path length associated with the I/Os saved is substantial.

Which three of the followingare software components that run on a Teradata networkattached client? (Choose three.)


Options are :

  • TDP
  • CLI
  • MTDP
  • BYNET
  • MOSI

Answer : CLI MTDP MOSI

NR0-013 Teradata SQL v2r5 Certification Practice Exam Set 2

The best Teradata performance is provided by which configuration of disk arrays?


Options are :

  • RAID 0
  • RAID 5
  • RAID 1
  • RAID S

Answer : RAID 1

Which two of the followingutilities can you used to update a table that has Referential Integrity, as well as enabled triggers? (Choose two.)


Options are :

  • MultiLoad
  • TPump
  • BTEQ
  • FastLoad

Answer : TPump BTEQ

A lock is held on a resource and a transaction arrives with a LOCKING ROW NOWAIT option. What is the meaning of NOWAIT in this instance?


Options are :

  • NOWAIT means the transaction will not wait in a queue and is aborted immediately.
  • NOWAIT means the transaction cannot wait and the current lock holder temporarily gives up the lock so the transaction can quickly finish and return the lock.
  • NOWAIT puts the transaction at the head of the queue to get the resource as soon as it becomes available.
  • NOWAIT means the transaction gets put at the head of the queue for its performance group.

Answer : NOWAIT means the transaction will not wait in a queue and is aborted immediately.

TE0-141 14 Teradata Basics Certified Practice Test Set 3

What are two data demographics that should be considered in the design of a Teradata table? (Choose two.)


Options are :

  • nulls per row
  • rows per value in a column
  • numeric columns per row
  • nulls per column
  • number of character columns per row

Answer : rows per value in a column nulls per column

Of the followingstatements,which two concerning Fallback protected tables are correct? (Choose two.)


Options are :

  • Fallback protection is accomplished by grouping AMPs into cliques and distributing every row to a different AMP from the one containing the primary row.
  • Fallback protected tables take up twice the space on your system as non-Fallback protected tables.
  • If the primary AMP fails, the system can still access data on the fallback AMP.
  • In limited cases, the Fallback copy of a row can reside on the same AMP as the primary copy.

Answer : Fallback protected tables take up twice the space on your system as non-Fallback protected tables. If the primary AMP fails, the system can still access data on the fallback AMP.

Which is an accurate statement with regard to two queries in deadlock for the same tables?


Options are :

  • A detection mechanism will abort the youngest transaction.
  • A transaction time-out mechanism aborts and restarts a transaction without notifying the user.
  • A detection mechanism will abort the transaction that has completed the least work.
  • A 'hung transaction' detection mechanism detects and aborts hung transactions.

Answer : A detection mechanism will abort the youngest transaction.

TE0-125 Teradata 12 Solutions Development Practice Exam Set 3

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions