NR0-015 Teradata Design Architecture V2R5 Practice Test Set 3

When grouping the Teradata users under profiles, which of the followingare two options that are available? (Choose two.)


Options are :

  • management over the external connections available to users
  • control of the AMP Usage Logging and Account String Expansion (Correct)
  • management of the Priority Scheduler Performance Groups (Correct)
  • control over the object creation access rights

Answer : control of the AMP Usage Logging and Account String Expansion management of the Priority Scheduler Performance Groups

NR0-016 NCR Teradata Application Development V2R5 Exam Set 2

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 :

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

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

For software fault tolerance, which are two vital Teradata RDBMS facilities? (Choose two.)


Options are :

  • vproc migration (Correct)
  • Checktable Utility
  • dual buffering
  • Fallback tables (Correct)

Answer : vproc migration Fallback tables

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


Options are :

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

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

TE0-141 14 Teradata Basics Certified Practice Test Set 4

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 null occurrences (Correct)
  • variable length character columns with nulls
  • columns with a large number of default occurrences (Correct)
  • numeric columns with a large number of leading zeros

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

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. (Correct)

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

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


Options are :

  • A write lock ensures that the requester has exclusive rights to the locked resource except for readers not concerned with data consistency. (Correct)
  • A read lock ensures that no modification of that resource is permitted while a SELECT operation is in progress. (Correct)
  • 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.

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.

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 5

Permanent space has whichtwo features? (Choose two.)


Options are :

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

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

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


Options are :

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

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

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 (Correct)
  • the number of AMPs running at 100% CPU during the specified time
  • the occurrence of full table scans during the specified time (Correct)
  • 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

TE0-121 12 Teradata Basics Certification Practical Exam Set 8

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


Options are :

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

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

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


Options are :

  • RAID S
  • RAID 5
  • RAID 0
  • RAID 1 (Correct)

Answer : RAID 1

Which two of the followingare features of highly non-unique primary index values? (Choose two.)


Options are :

  • cause efficient distribution among AMPs (Correct)
  • cause database full condition on AMPs where excessive number of rows are store
  • maximize parallel processing
  • cause multiple data blocks to be used and incur multiple I/Os

Answer : cause efficient distribution among AMPs

TE0-121 Teradata Basics Practice Test Set 5

Which three of the following options will enhance overall job mix and throughput? (Choose three.)


Options are :

  • using the Priority Scheduler Administrator to set slow AMPs to a higher priority
  • defining Allocation Groups for different times of the day (Correct)
  • changing the poorly performing queries to $R status
  • maintaining development and testing users in a separate Allocation Group (Correct)
  • using the MODIFY USER statement to change the ACCOUNT for users receiving too much or too little CPU (Correct)

Answer : defining Allocation Groups for different times of the day maintaining development and testing users in a separate Allocation Group using the MODIFY USER statement to change the ACCOUNT for users receiving too much or too little CPU

The sharing of data across user sessions is allows by what kind of table?


Options are :

  • global temporary
  • permanent (Correct)
  • derived
  • volatile

Answer : permanent

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


Options are :

  • BYNET
  • TDP
  • MTDP (Correct)
  • CLI (Correct)
  • MOSI (Correct)

Answer : MTDP CLI MOSI

TE0-141 14 Teradata Basics Certified Practice Test Set 1

Which are three accurate statements regarding global temporary tables? (Choose three.)


Options are :

  • Global temporary tables can reduce the number of times the user needs to create and drop tables. (Correct)
  • Global temporary tables require the user to have the necessary permanent space to store data when the table is materialized.
  • Global temporary tables provide the user with a place to store interim results. (Correct)
  • Global temporary tables have a persistent definition that is stored in the Data Dictionary, but their contents do not persist across sessions. (Correct)

Answer : Global temporary tables can reduce the number of times the user needs to create and drop tables. Global temporary tables provide the user with a place to store interim results. Global temporary tables have a persistent definition that is stored in the Data Dictionary, but their contents do not persist across sessions.

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. (Correct)
  • 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 means the transaction gets put at the head of the queue for its performance group.
  • NOWAIT puts the transaction at the head of the queue to get the resource as soon as it becomes available.

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

You are a database administrator at Your company. Your companyhas an eight node Teradata system with DBC.CRASHDUMPS defined as FALLBACK. Assume that a 200 MB/node is required for one PDE dump. Youwant the CRASHDUMPS allocation, which is currently 1600 MB, to hold the recommended three PDE dumps. What must the total space allocation be for CRASHDUMPS, and what database does it come from?


Options are :

  • 600 MB from database ALL
  • 4800 MB from database ALL
  • 4800 MB from database DBC (Correct)
  • 600 MB from database DBC

Answer : 4800 MB from database DBC

TE0-121 12 Teradata Basics Certification Practical Exam Set 3

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 :

  • BTEQ (Correct)
  • TPump (Correct)
  • FastLoad
  • MultiLoad

Answer : BTEQ TPump

To determine the optimal set of secondary indexes on a given workload, a "what-if" analysis is performed using which Teradata Analyst tool?


Options are :

  • Teradata Statistics Wizard
  • Teradata Index Wizard (Correct)
  • Teradata System Emulation Tool
  • Teradata Visual Explain

Answer : Teradata Index Wizard

Of the following options,which three are considered when you select a column as a primary index? (Choose three.)


Options are :

  • frequency of change (Correct)
  • maximum rows per value (Correct)
  • sample data
  • distinct values (Correct)
  • minimum rows per value

Answer : frequency of change maximum rows per value distinct values

TE0-121 Teradata Basics Practice Test Set 4

Which are two true statements with reference to FastLoad? (Choose two.)


Options are :

  • It can load data from tape files on a channel-attached client system. (Correct)
  • . It can load up to five empty tables.
  • When an error occurs, locks are dropped with no ill effect.
  • Number of sessions are defaulted to one session per AMP. (Correct)

Answer : It can load data from tape files on a channel-attached client system. Number of sessions are defaulted to one session per AMP.

When creating profiles on the Teradata Database, whichof the followingare two concerns? (Choose two.)


Options are :

  • Which databases are to be accessed at the same time?
  • Which users will need the same priorities? (Correct)
  • Which users will need to create tables and which will not?
  • Which users will need approximately the same amount of spool? (Correct)

Answer : Which users will need the same priorities? Which users will need approximately the same amount of spool?

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


Options are :

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

Answer : nulls per column rows per value in a column

TE0-141 14 Teradata Basics Certified Practice Test Set 2

Of the followingfeatures, which one allows multiple users to share the blocks that are read from a table?


Options are :

  • Access Locking
  • Redistribution Buffering
  • PreReads
  • SyncScan (Correct)

Answer : SyncScan

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 2

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


Options are :

  • a write lock and a write lock
  • a write lock and an access lock (Correct)
  • . a read lock and a write lock
  • a read lock and a read lock (Correct)

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

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


Options are :

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

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

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 :

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

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

NR0-016 NCR Teradata Application Development V2R5 Exam Set 1

Whichtwoof the followingare planning considerations when you want to set up Roles in Teradata? (Choose two.)


Options are :

  • Will the users need to create volatile tables?
  • Will the users need permissions to access specific tables? (Correct)
  • Will the users be assigned to the same profile?
  • Will the users need to create permanent tables? (Correct)

Answer : Will the users need permissions to access specific tables? Will the users need to create permanent tables?

When a column defined as a foreign key in the referencing table is compared to the primary key in the referenced table, which three rules will apply? (Choose three.)


Options are :

  • The case sensitivity must be the same. (Correct)
  • The compression values must be the same.
  • No column in the foreign key (referencing) can be an identity column. (Correct)
  • The data type must be the same. (Correct)

Answer : The case sensitivity must be the same. No column in the foreign key (referencing) can be an identity column. The data type must be the same.

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


Options are :

  • is especially powerful for transaction processing applications
  • allows the system to reduce the processing speed of inserts into tables
  • is enabled by the memory allocation specified in the DBSControl utility (Correct)
  • 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 (Correct)

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

TE0-121 12 Teradata Basics Certification Practical Exam Set 5

Which is an accurate statement pertaining to Performance Periods in Priority Scheduler?


Options are :

  • There are five types of Performance Periods allowed Time, Session, Period, Query, and Cycle
  • A Performance Period is assigned to only one Performance Group.
  • Performance Periods allow for users assigned to one performance group to be automatically shifted into a different Allocation Group. (Correct)
  • Performance Periods allow for a DBA to be notified that a user is using more system resources than planned.

Answer : Performance Periods allow for users assigned to one performance group to be automatically shifted into a different Allocation Group.

What is the correct formula for the number of bytes used by a table with Fallback, if you are given the following information? b = block size c = table row count n = number of AMPs r = rows per block h = table header size


Options are :

  • (c/r)*b + n*h
  • 2*(c/r)*b + n*h (Correct)
  • 2*(r/c)*b + n*h
  • (r/c)*b + n*h

Answer : 2*(c/r)*b + n*h

Multiple sources of data arriving from multiple platforms concurrently, is supported by which utility?


Options are :

  • Teradata Warehouse Builder (Correct)
  • MultiLoad
  • BTEQ
  • FastLoad

Answer : Teradata Warehouse Builder

TE0-141 14 Teradata Basics Certified Practice Test Set 2

Which of the followingis a true statement regarding row inserts into a table with an identity column?


Options are :

  • Numbering gaps can occur. (Correct)
  • Generated numbers reflect row insertion sequence.
  • Values will be unique if the GENERATED BY DEFAULT option is used.
  • Serialization is guaranteed.

Answer : Numbering gaps can occur.

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 execute only if it does not require data from the down AMP. (Correct)
  • The query will always execute and return data from only the AMPs that are available.
  • The query will execute and return data from all AMPs.
  • The query will not execute under these conditions.

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

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 (Correct)
  • (Number of blocks*Typical block size) + (Number of header bytes*2)

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

TE0-141 14 Teradata Basics Certified Practice Test Set 4

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. (Correct)
  • They store images (copies) of each table both before and, optionally, after they have been updated. (Correct)
  • They store images (copies) of each data row that has been changed with an insert, update or delete statement.
  • They can store both before and after images (copies) of rows changed in one or more tables.

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.

How can improve a query's performance without restarting Teradata? (Choose three.)


Options are :

  • By changing the priority of the user's session which is running slow (Correct)
  • By modifying the weights assigned to the user's Allocation Group (Correct)
  • By modifying the weights assigned to the user's Resource Partition (Correct)
  • By increasing the number of cylinder slots in FSG Cache
  • By modifying the user's account to increase the spool space of the user

Answer : By changing the priority of the user's session which is running slow By modifying the weights assigned to the user's Allocation Group By modifying the weights assigned to the user's Resource Partition

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions