NR0-014 Teradata Administration V2R5 Certified Practice Exam Set 3

The Teradata Statistics Wizard is able to execute which two tasks? (Choose two.)


Options are :

  • recommend recollection of statistics based on table skew
  • execute statistics collection recommendations
  • display current versus captured statistics information
  • recommend secondary indexes
  • reproduce Optimizer related issues in a test environment

Answer : recommend recollection of statistics based on table skew execute statistics collection recommendations

Both FastLoad and the Teradata Warehouse Builder Load Operator support which two of the following Teradata features? (Choose two.)


Options are :

  • partitioned primary indexes
  • secondary indexes
  • multi-value compression
  • referential integrity

Answer : partitioned primary indexes multi-value compression

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 5

An authorized user is allowed to do whichof the followingby the Performance Monitor? (Choose three.)


Options are :

  • purge ResUsage tables
  • identify a blocked user
  • set ResUsage rates
  • abort user sessions
  • reset peak utilization values

Answer : identify a blocked user set ResUsage rates abort user sessions

The GIVE statement has an effect on which of the following?


Options are :

  • passwords and explicit access rights
  • owned databases and space
  • space and explicit access rights
  • owned databases and explicit access rights
  • owned databases and passwords

Answer : owned databases and space

Which is a facility that automatically manages system workflow by blocking queries that defy predefined rules from entering the system?


Options are :

  • ResUsage
  • Priority Scheduler
  • TDQM
  • DBSControl

Answer : TDQM

TE0-125 Teradata 12 Solutions Development Practice Exam Set 2

Logons to the RDBMS via the gateway is enabled by whichof the following?


Options are :

  • ENABLE LOGONS
  • ENABLE GTW
  • START SESSIONS
  • RUN GTW

Answer : ENABLE LOGONS

What condition allows you to restore database DBC to a Teradata system?


Options are :

  • following a standard data table archive
  • following the creation of new database objects
  • following a system reconfiguration
  • following a system initialization

Answer : following a system initialization

The Teradata Administrator tool can be used to perform which three tasks? (Choose three.)


Options are :

  • copy DDL from one system to another
  • abort a user session
  • clone users
  • copy table data from one system to another
  • grant MONITOR privileges to a user

Answer : copy DDL from one system to another clone users grant MONITOR privileges to a user

TE0-122 12 Teradata SQL Certification Practice Exam Set 4

Permanent Journals offers which three types of protection? (Choose three.)


Options are :

  • protection from loss of data caused by failure of a secondary storage device
  • protection against incorrect operation of a batch process
  • Fallback protection for journaled non-Fallback tables
  • protection against the loss of changes made after a data table is archived

Answer : protection from loss of data caused by failure of a secondary storage device protection against incorrect operation of a batch process protection against the loss of changes made after a data table is archived

Whichtwo of the followingare advantages of Teradata Manager? (Choose two.)


Options are :

  • It provides session-level resource usage data.
  • It acquires data in near real-time with less overhead.
  • It accumulates large amounts of data over a long period.
  • It provides data as detailed as ResUsage data.

Answer : It provides session-level resource usage data. It acquires data in near real-time with less overhead.

You are currently working in the Default resource partition. Due to the negative performance that can be introduced into Your company's system, you should use which Performance Group sparingly?


Options are :

  • $R
  • $H
  • $M
  • $L

Answer : $R

TE0-124 Teradata 12 Database Administration Practice Exam Set 4

Which three of the following privileges are automatically granted to User B on User B, after User A creates User B? (Choose three.)


Options are :

  • CREATE TABLE
  • CREATE DATABASE
  • WITH GRANT OPTION
  • RESTORE
  • DUMP

Answer : CREATE TABLE RESTORE DUMP

Which is the Teradata Warehouse Builder consumer operator that employs multiple sessions to execute DML transactions against Teradata tables in near real-time mode?


Options are :

  • DataConnector
  • Stream
  • Load
  • Update

Answer : Stream

Which type of database object is affects affected by the DBSControl parameter PPICacheThrP?


Options are :

  • partitioned databases
  • partitioned tables
  • temporary tables
  • global temporary tables
  • cached tables

Answer : partitioned tables

TE0-121 12 Teradata Basics Certification Practical Exam Set 6

To verify data integrity, you should run which two utilities? (Choose two.)


Options are :

  • Checktable
  • Defrag
  • Scandisk
  • DBSControl
  • Packdisk

Answer : Checktable Scandisk

When the ALL option is specified in the ARC utility, whichthree is archived? (Choose three.)


Options are :

  • all tables, views, macros, and stored procedures in the specified database's parent
  • all column and index information in the specified database and its parent
  • all tables, views, macros, and stored procedures in the specified database'sdescendants
  • all tables, view, macros, and stored procedures in the specified database
  • all column and index information in the specified database and its descendants

Answer : all tables, views, macros, and stored procedures in the specified database'sdescendants all tables, view, macros, and stored procedures in the specified database all column and index information in the specified database and its descendants

The Teradata Warehouse Builder ODBC operator executes which task?


Options are :

  • reads data from an ODBC provider
  • writes data to an ODBC provider
  • preprocesses data from an ODBC provider
  • transforms data from an ODBC provider

Answer : reads data from an ODBC provider

TE0-141 14 Teradata Basics Certified Practice Test Set 4

When you change password features such as expiration, reuse, minimum, and maximum length, what is updated?


Options are :

  • DBC.LogonRules
  • DBC.LogOnOff
  • DBC.Users
  • DBC.SysSecDefaults

Answer : DBC.SysSecDefaults

What does the followingphrase specify in the ARCHIVE and RESTORE commands? EXCLUDE <dbname1> TO <dbname2>


Options are :

  • a range of alphabetically sorted databases
  • location of databases/users within the hierarchy
  • a sequential group of database IDs
  • database descendants through ownership

Answer : a range of alphabetically sorted databases

The maximum size of a datablock in a table is controls by which DBSControl parameter?


Options are :

  • MaxDBSize
  • PermDBSize
  • PermDBAllocUnit
  • DBSize

Answer : PermDBSize

TE0-141 14 Teradata Basics Certified Practice Test Set 3

Which are two tasks that you should execute prior to a Reconfig? (Choose two.)


Options are :

  • reassign spool to Reconfig
  • delete unneeded data
  • drop secondary indexes
  • verify data integrity

Answer : delete unneeded data verify data integrity

Which two of the following are scheduling policies found in Priority Scheduler? (Choose two.)


Options are :

  • low
  • rush
  • relative
  • absolute

Answer : relative absolute

What is calculated the CPU Eff % column in the ResNode macro?


Options are :

  • how well the CPUs work in parallel across all nodes
  • efficiency of each CPU in each node
  • percentage of CPUs working in parallel across all nodes
  • percentage of CPUs working efficiently in all nodes

Answer : how well the CPUs work in parallel across all nodes

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 5

Which three tasks does the Profile subsystem in Teradata Manager allows you to execute? (Choose three.)


Options are :

  • program automatic application starts
  • tailor the Teradata Manager drop-down menus
  • establish a connection to a Teradata Database
  • store information about registered users
  • identify users with similar characteristics

Answer : program automatic application starts tailor the Teradata Manager drop-down menus establish a connection to a Teradata Database

Of the following, which are two features that the Teradata Warehouse Builder Load Operator supports? (Choose two.)


Options are :

  • checkpoint restartable
  • secondary index on target table
  • create table
  • error limits

Answer : checkpoint restartable error limits

The allocation of which two resources is controlled by weights and scheduling policies within Priority Scheduler? (Choose two.)


Options are :

  • I/O
  • perm space
  • CPU
  • sessions
  • spool space

Answer : I/O CPU

TE0-122 12 Teradata SQL Certification Practice Exam Set 4

If a NUPI is included in a Partitioned Primary Index (PPI) table, how can you determine the number of hash collisions?


Options are :

  • with the SQL HASHCOL function
  • with the SQL HASHAMP function
  • with the SQL HASHROW function
  • with the SQL HASHBUCKET function

Answer : with the SQL HASHROW function

An allocation group has a scheduling policy of ABS and a group weight of 40%. What will happen if a user that belongs to this group, logs onto an idle system?


Options are :

  • The user's session will have access to its owner's partition weight %.
  • The user's session will have access to more than 60% of the system if resources are available.
  • The user's session will have access to no more than 60% of the system.
  • The user's session will have access to no more than 40% of the system
  • The user's session will have access to more than 40% of the system if resources are available.

Answer : The user's session will have access to no more than 40% of the system

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions