TE0-124 Teradata 12 Database Administration Practice Exam Set 2

An application has defined Queryband in their reporting tool. Which table in Database Query Log can be used to report the performance statistics of queries grouped by Queryband?


Options are :

  • DBQLSummaryTbl
  • DBQLogTbl
  • DBQLSqlTbl
  • DBQLStepTbl
  • DBQLObjTbl

Answer : DBQLogTbl

TE0-122 12 Teradata SQL Certification Practice Exam Set 3

The overnight processing completed but ran longer than expected. Some new jobs were added which should not have had an impact, but it is suspected that there may have been some lock contention. Which utility can be used to determine if there were locking contentions?


Options are :

  • Show Locks
  • Performance Monito
  • Awtmon
  • Locking Logger

Answer : Locking Logger

Which three data elements should be collected to project future system capacity needs? (Choose three.)


Options are :

  • Table sizes
  • Locking Logger history
  • ResUsage
  • Spool Space
  • Active workload groups

Answer : Locking Logger history Spool Space Active workload groups

What will be the result of a system administrator changing the data block size of a 500 GB table with an ALTER TABLE statement using the IMMEDIATE option?


Options are :

  • The system needs to repack all of the data blocks in the table.
  • During the operation the table is available for read access.
  • This will fail because IMMEDIATE is not a valid option for this type of change
  • The table is altered, but the system administrator needs to run a REORG on it.

Answer : During the operation the table is available for read access.

TE0-141 14 Teradata Basics Certified Practice Test Set 4

What should be monitored to determine if system capacity is about to fall short?


Options are :

  • Normalized CPU Time
  • Normalized I/O Wait Time
  • Internalized System Time
  • Internalized Idle Time

Answer : Normalized CPU Time

A MultiLoad Import Task job abnormally terminated during the Application Phase. What is a recovery option?


Options are :

  • Resubmit the script and allow it to complete.
  • Drop the Work and Error tables only and resubmit the script.
  • Release theMultiLoad locks and resubmit the script.
  • Since there is no data corruption, no recovery is necessary.

Answer : Release theMultiLoad locks and resubmit the script.

A nightly process is updating a table that is defined with Fallback when two disks fail in the same drive group. The system restarts with an AMP down and the recovery process restarts. Which two statements are true about this situation? (Choose two.)


Options are :

  • Updates to the Fallback AMP cannot complete.
  • Updates to the primary AMP are stored in the down AMP recovery journal.
  • Updates to the down AMP can complete.
  • Updates to the down AMP are serviced by the Fallback AMP
  • Updates to the down AMP are serviced by the Backup AMP.

Answer : Updates to the primary AMP are stored in the down AMP recovery journal. Updates to the down AMP are serviced by the Fallback AMP

TE0-124 Teradata 12 Database Administration Practice Exam Set 5

What are three considerations when sizing a NUSI for a table? (Choose three.)


Options are :

  • the number of distinct values
  • whether the base table has a PPI
  • the data types of the columns in the NUSI
  • the number of nodes in the configuration

Answer : whether the base table has a PPI the data types of the columns in the NUSI the number of nodes in the configuration

An administrator is looking to reduce I/O utilization. The goal is to identify candidate queries using the statistic IO_Per_CPU_Second as defined below: SELECT SUM(DiskIO) / SUM(CpuTime) AS IO_Per_CPU_Second FROM DBC.AMPUsage; An average query for the system has an IO_Per_CPU_Second of 1000. Which scenario identifies candidate queries?


Options are :

  • Queries operating at 100 or lower are candidates for tuning and may haveexplain plans with unconstrained product joins.
  • Queries operating at approximately 1000 are candidates for tuning and may benefit from additional index analysis.
  • Queries operating at greater than or equal to 2500 are candidates for tuning and may benefit from additional index analysis.
  • None

Answer : Queries operating at greater than or equal to 2500 are candidates for tuning and may benefit from additional index analysis.

A new application is being developed for Teradata using an application ID. The developers are complaining that the first SQL statement is taking too long to execute. Which action can be performed to improve this?


Options are :

  • Raise the priority of the logon for the application ID.
  • Create a filter for the application ID to avoid the logon.
  • Raise the priority of the application ID.
  • Have the developers implement session pooling for their application ID.

Answer : Raise the priority of the application ID.

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

Which Teradata Parallel Transporter (TPT) operator emulates the Teradata MultiLoad utility?


Options are :

  • Stream Operator
  • Update Operator
  • Load Operator
  • MultiTable Operator

Answer : Load Operator

The sessions parameter is not included in the FastLoad scripts. This may logon too many sessions when concurrent FastLoad jobs are running. Which three solutions are possible remedies for this situation? (Choose three.)


Options are :

  • Add a runtime parameter when running theFastLoad.
  • Add a session limit for theUserid running the FastLoad.
  • Add a SESSIONS parameter to each script.
  • Add a floadcfg.dat file with the default sessions.
  • Lower the priority of theUserid running the FastLoad.

Answer : Add a runtime parameter when running theFastLoad. Add a session limit for theUserid running the FastLoad. Add a SESSIONS parameter to each script.

The administrator finds that too many sessions are being used by load utilities that are running concurrently. How can TDWM be used to reduce the number of sessions to avoid modifying the load scripts?


Options are :

  • Define an object throttle.
  • Define a session limit on the PE for the loadUserids.
  • Define a query limit on a workload.
  • Define a utility limit.

Answer : Define a utility limit.

TE0-141 14 Teradata Basics Certified Practice Test Set 4

What should be monitored to determine if system capacity is about to fall short?


Options are :

  • CSPSessionInfo
  • I/O congestion
  • Cost Profiles
  • DBC.Events
  • Active workload groups

Answer : Cost Profiles

What can be identified by evaluating object use count data?


Options are :

  • the number of DBC catalog tables in use
  • the objects that are candidates to be removed from the system
  • the login information associated with the last access of the object
  • the actual number of database objects created and in use on the system

Answer : the objects that are candidates to be removed from the system

Which utility should be used to enable the Locking Logger?


Options are :

  • Gateway Control (gtwcontrol)
  • DBS Control (dbscontrol)
  • Control GDO Editor (ctl)
  • Gateway Global (gtwglobal)

Answer : DBS Control (dbscontrol)

TE0-141 14 Teradata Basics Certified Practice Test Set 2

The sessions parameter is not included in the FastLoad scripts. This may logon too many sessions when concurrent FastLoad jobs are running. Which three solutions are possible remedies for this situation? (Choose three.)


Options are :

  • Add a session limit for theUserid running the FastLoad.
  • Lower the priority of theUserid running the FastLoad.
  • Add a runtime parameter when running theFastLoad
  • Add a floadcfg.dat file with the default sessions.
  • Add a SESSIONS parameter to each script.

Answer : Add a session limit for theUserid running the FastLoad. Add a runtime parameter when running theFastLoad Add a SESSIONS parameter to each script.

A system administrator is receiving calls from various user communities that their queries are taking longer to run than normal. Which tool can be used to quickly determine which users are currently causing blocking?


Options are :

  • ctl/xctl
  • Locking Logger
  • TDWM
  • PMON

Answer : Locking Logger

A FastLoad job has failed with the following error: *** Failure 2644 No more room in database Utility_DB What should be analyzed to determine the possible root cause? (Choose two.)


Options are :

  • QueryDBC.DiskSpace for PeakSpool for your load user
  • QueryDBC.DiskSpace for today's PeakSpool for other users
  • QueryDBC.TableSpace against the load error tables
  • QueryDBC.ResUsageSvdsk for spikes in Perm or Spool data
  • QueryDBC.DiskSpace by Vproc.

Answer : QueryDBC.DiskSpace for PeakSpool for your load user QueryDBC.DiskSpace for today's PeakSpool for other users

NR0-012 Teradata Physical Implementation V2R5 Practice Exam Set 3

What should be monitored to determine if system capacity is about to fall short?


Options are :

  • Cost Profiles
  • ResUsageSnode
  • PeakSpool
  • ResUsageSawt

Answer : ResUsageSnode

A TDWM Utility Throttle has been activated that restricts the number of combined FastLoad and MultiLoad utilities to a maximum of 2 and delays utilities that exceed the throttle limit. A user submits a FastLoad job and has also specified a Tenacity parameter of 2 hours and Sleep parameter of 6 minutes. The FastLoad job has been on the delay queue for over 2 hours. What happens to the FastLoad job in the delay queue?


Options are :

  • It is automatically released from the delay queue.
  • It remains in the delay queue, but a message is sent to the user informing the user the utility has exceeded the tenacity parameter.
  • It is purged from the delay queue since it has exceeded the tenacity parameter.
  • It remains in the delay queue and no action is taken.

Answer : It is automatically released from the delay queue.

What can be identified by evaluating object use count data?


Options are :

  • the number of DBC catalog tables in use
  • the objects that are candidates to be removed from the system
  • the actual number of database objects created and in use on the system
  • the login information associated with the last access of the object

Answer : the objects that are candidates to be removed from the system

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 1

An application processes approximately 100,000 transactions each hour until noon. The transaction rate is approximately 40,000 transactions per hour for the remainder of the day. This application is well tuned and nearly 99% of the transactions are single-AMP. The system administrator needs to track the number of transactions submitted by the user group. There is no need to track tables used by this application. Which type of logging should be used for this application group?


Options are :

  • Summary
  • Throttle
  • Object
  • Detail

Answer : Throttle

When implementing a new application, which two techniques can help limit DBC.AccessRights table growth? (Choose two.)


Options are :

  • Implement views on the tables and grant privileges to the views
  • Grant rights on each object to a Role and grant the Role to each user
  • Grant rights on each object to a Profile and grant the Profile to each user
  • Grant rights at the Database level to ALL users

Answer : Grant rights on each object to a Role and grant the Role to each user Grant rights at the Database level to ALL users

The system administrator finds that many clients have more connections to the first Teradata node as compared to the others. Which resource should be used to see the gateway connections?


Options are :

  • gtwglobal
  • DBC.SessionInfo
  • ctl/xctl
  • PMON

Answer : DBC.SessionInfo

NR0-014 Teradata Administration V2R5 Certified Practice Exam Set 3

A database Administrator has created several secondary indexes for a very large table. The Administrator wants to know the number of rows and the average row size for each secondary index subtable. Which statement should be used to collect this information?


Options are :

  • Collect Demographics
  • Collect Index Statistics
  • Collect Index Counts
  • Collect Statistics

Answer : Collect Index Counts

Last night, a set of load jobs ran excessively slow. Which ResUsage table can be used to determine if the system was in flow control?


Options are :

  • DBC.ResUsageSawt
  • DBC.ResUsageSvpr
  • DBC.ResUsageShst
  • DBC.ResUsageSpma

Answer : DBC.ResUsageSvpr

If using the following COPY statement to restore a table: COPY DATA TABLE (Payroll.Employee) ,FILE = ARCHIVE; Which statement is true?


Options are :

  • If the Employee table does not exist in the Payroll database, it will be created.
  • If the database Payroll does not exist, it will be created.
  • No Permanent Journaling options for the Employee table will be carried forward to the target system.
  • If the Employee table exists in the Employee database, the copy operation will be stopped.

Answer : If the database Payroll does not exist, it will be created.

TE0-141 14 Teradata Basics Certified Practice Test Set 4

A database administrator has been asked to review the EXPLAIN of a query that is running out of spool. In the EXPLAIN plan, the following statement appears: Sales.Inventory and Spool 4 are joined using a product join, with a join condition of ("(1=1)") What could this potentially indicate?


Options are :

  • The data type between two join columns does not match.
  • A join index has been created on theSales.Inventory table.
  • The column-level statistics on theSales.Inventory table need to be recollected.
  • The query is missing a join condition to theSales.Inventory table.

Answer : The query is missing a join condition to theSales.Inventory table.

A customer wants to set up and utilize query access logging. Which management tool is available for the task?


Options are :

  • Teradata Query Director
  • Teradata Dynamic Workload Manager (TDWM)
  • Teradata Administrator
  • Administrative Workstation

Answer : Administrative Workstation

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions