NR0-014 Teradata Administration V2R5 Certified Practice Exam Set 1

What is the result of another user trying to log on when a host group has exceeded its session limit?


Options are :

  • The user receives an error message and is logged on to the next host group
  • The user's connection is refused and the user receives an error message
  • The user does not receive an error message and is logged on to the next hostgroup.
  • The user's connection is refused and the user does not receive an error message

Answer : The user's connection is refused and the user receives an error message

TE0-121 12 Teradata Basics Certification Practical Exam Set 3

Which of the following are three accurate statements on the subject of roles? (Choose three.)


Options are :

  • They are a set of common user parameters applied to a group of users.
  • Roles help reduce the number of rows in the DBC.AccessRights table.
  • Changes are not effective until the next logon.
  • They are viewed as a pseudo-user with privileges on objects.
  • Changes are effective immediately.

Answer : Roles help reduce the number of rows in the DBC.AccessRights table. They are viewed as a pseudo-user with privileges on objects. Changes are effective immediately.

Whichtwo of the followingare advantages of session pools? (Choose two.)


Options are :

  • Logon times are typically 2-3 seconds faster
  • They allow better tracking of when applications log on and log off.
  • The number of sessions a user can log on is controlled
  • If all sessions are active, the next pool is used regardless of the logon string.

Answer : Logon times are typically 2-3 seconds faster The number of sessions a user can log on is controlled

Information on the amount of permanent disk space currently in use at the table level is provided by which system view?


Options are :

  • DBC.DiskSpace
  • DBC.Tables
  • DBC.SysInfo
  • DBC.TableSize

Answer : DBC.TableSize

TE0-125 Teradata 12 Solutions Development Practice Exam Set 1

An inappropriate job mix can be identified with the use of which two tools? (Choose two.)


Options are :

  • filer
  • Locking Logger
  • ferret
  • Performance Monitor
  • DBSControl

Answer : Locking Logger Performance Monitor

Which is a statement that is true with regards to the TDP command SET MAXSESS?


Options are :

  • A change to MAXSESS only takes effect at TDP startup
  • The number of sessions is constrained for the TDP.
  • The allowable values must equal a multiple of the PE session limit.
  • It changes the maximum number of sessions supported by the Teradata server.

Answer : The number of sessions is constrained for the TDP.

In what situation is Fallback data not available?


Options are :

  • when there are two AMPs down in clique two
  • when there is an AMP down in cluster one and an AMP down in cluster two
  • when there is a drive down in AMP one and a drive down in AMP two
  • when there is an AMP down in clique one and an AMP down in clique two
  • when there are two AMPs down in cluster three

Answer : when there are two AMPs down in cluster three

TE0-141 14 Teradata Basics Certified Practice Test Set 3

You are a database administrator at Your company.You are currently analyzing application performance using the Access Log. Of the followingoptions, which are two that you can capture? (Choose two.)


Options are :

  • start time
  • SQL function
  • CPU time
  • disk I/O
  • embedded views

Answer : start time SQL function

Teradata Dynamic Query Manager (TDQM) supports which three of the following activities? (Choose three.)


Options are :

  • delaying query processing
  • limiting types of joins
  • controlling access to database objects
  • controlling access to host groups
  • limiting the number of reserved AMP Worker Tasks

Answer : delaying query processing limiting types of joins controlling access to database objects

To use all the functions of the Performance Monitor, you need possess which three user privileges? (Choose three.)


Options are :

  • setresrate
  • monsession
  • insertsesrate
  • selsession
  • abortsession

Answer : setresrate monsession abortsession

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

You can control which three of the followingactivities using Teradata Manager profiles? (Choose three.)


Options are :

  • the number of concurrent users
  • the ability to change a profile
  • the start time for auto-start applications
  • the Data Dictionary tables available to the user
  • the functions available through drop-down menus

Answer : the ability to change a profile the start time for auto-start applications the functions available through drop-down menus

The Fallback rows for AMP 0 are stored in which location?


Options are :

  • on PEs in the same cluster as AMP 0
  • on other AMPs in the same cluster as AMP 0
  • on other AMPs in the same clique as AMP 0
  • on PEs in the same clique as AMP 0
  • on all other AMPs in the system

Answer : on other AMPs in the same cluster as AMP 0

Of the following options, which are the three that you would use to modify collection and logging rates for ResUsage in Teradata? (Choose three.)


Options are :

  • ferret
  • gdb
  • xdbw
  • xctl
  • Teradata Manager

Answer : xdbw xctl Teradata Manager

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 5

In which way is data protected by RAID 1?


Options are :

  • with pairs of drives containing mirrored data
  • It uses parity to reconstruct the data on a failed drive.
  • with pairs of AMPs containing mirrored data
  • It uses parity to reconstruct the data on a failed AMP.

Answer : with pairs of drives containing mirrored data

TE0-125 Teradata 12 Solutions Development Practice Exam Set 1

You are a database administrator at Your company. Your company Users are complaining about poor system response time. You discover a query that is consuming a large amountof CPU, and subsequently run an EXPLAIN on it. Which of the following are two steps in the EXPLAIN that could detect the root of this problem? (Choose two),


Options are :

  • a (1=1) product join of two large tables
  • redistribution of a large table across all AMPs
  • a Merge Join of a small table to a large table
  • a Merge Join of two large tables
  • duplication of a small table across all AMPs

Answer : a (1=1) product join of two large tables redistribution of a large table across all AMPs

Which are three privileges that are automatically granted to User A on Database X, if User A creates Database X? (Choose three.)


Options are :

  • CREATE USER
  • CREATE INDEX
  • CREATE REFERENCES
  • CREATE TABLE
  • CREATE DATABASE

Answer : CREATE USER CREATE TABLE CREATE DATABASE

Which of the following is a clause in a CREATE VIEW statement that limits the rows in a table that can be inserted by users?


Options are :

  • SELECT
  • WHERE
  • WITH CHECK OPTION
  • USING

Answer : WITH CHECK OPTION

TE0-125 Teradata 12 Solutions Development Practice Exam Set 1

What occurs in the event of a user that belongs to an allocation group with an IMD policy and a weight of 40%, logs onto an idle system?


Options are :

  • The user's session will have access to 60% of available system resources.
  • The user's session will have access to its owner's partition weight %.
  • The user's session will have access to all available system resources.
  • The user's session will have access to 40% of available system resources.
  • The user's session will have access to 40% of all system resources

Answer : The user's session will have access to all available system resources.

Which of the followingare three consequences of the EMPLOYEE ALL clause in the Archive utility being used? (Choose three.)


Options are :

  • Database EMPLOYEE and all its descendants are archived.
  • All tables in database EMPLOYEE are archived
  • Only database EMPLOYEE and its immediate descendants are archived
  • All tables, views, and macros in database EMPLOYEE are archived.
  • All databases with the root name EMPLOYEE are archived.

Answer : Database EMPLOYEE and all its descendants are archived. All tables in database EMPLOYEE are archived All tables, views, and macros in database EMPLOYEE are archived.

Which of the following are three FastExport requirements? (Choose three.)


Options are :

  • OUTMOD
  • SELECT
  • NOTIFY
  • LOGTABLE
  • END EXPORT

Answer : SELECT LOGTABLE END EXPORT

TE0-122 12 Teradata SQL Certification Practice Exam Set 2

Which two of the followingare activities that should be carried out subsequent to a Reconfig? (Choose two)


Options are :

  • reload data
  • initialize tables
  • verify data integrity
  • test existing applications

Answer : verify data integrity test existing applications

You are allows to archive secondary indexes with which type of archive?


Options are :

  • all-AMP archive
  • single cluster archive
  • single-AMP archive
  • index archive

Answer : all-AMP archive

HUT locks can be displayed using which utility?


Options are :

  • Locking Logger
  • RCVManager
  • lokdisp
  • Performance Monitor
  • showlocks

Answer : showlocks

TE0-124 Teradata 12 Database Administration Practice Exam Set 5

I/O and CPU usage at the user level can be determined using which view?


Options are :

  • AMPUsage
  • ResNode
  • ResIOView
  • ResCPUUsageByAMPView

Answer : AMPUsage

What three parameters you can set in TPump? (Choose three.)


Options are :

  • PACK
  • REPEAT
  • SERIALIZE
  • ROBUST

Answer : PACK SERIALIZE ROBUST

Which of the following are two accurate statements regarding MultiLoad? (Choose two.)


Options are :

  • It is limited by the MaxLoadTasks parameter of DBSControl.
  • It requires empty tables
  • It allows multiple concurrent loads to the same table.
  • It is checkpoint restartable.

Answer : It is limited by the MaxLoadTasks parameter of DBSControl. It is checkpoint restartable.

TE0-141 14 Teradata Basics Certified Practice Test Set 1

On which three of the following can Logging be invoked if you are using Database Query Log (DBQL)? (Choose three)


Options are :

  • a list of database objects
  • all users
  • a list of account strings
  • a list of users

Answer : all users a list of account strings a list of users

Two thousand users have recently been added to Your company's Teradata database and are experiencing connection problems. What might be added to solve this problem?


Options are :

  • PEs
  • AMPs
  • I/O service processors
  • vdisks

Answer : PEs

The Recovery Manager utility has the ability to display which locking information?


Options are :

  • locks blocking other sessions
  • HUT locks
  • locks currently held by online transaction recovery
  • tables locked by in-flight transactions

Answer : locks currently held by online transaction recovery

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

Which the system view you would use to monitor failed logon attempts?


Options are :

  • DBC.SessionInfo
  • DBC.AccLog
  • DBC.LogOnOff
  • DBC.LogOnInfo

Answer : DBC.LogOnOff

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions