TE0-124 Teradata 12 Database Administration Practice Exam Set 3

What is a benefit of extrapolated and propagated statistics?


Options are :

  • Statistics only need to be collected once
  • Statistics are automatically collected as a background process
  • No statistics need to be collected.
  • There is less need for frequent statistics collection.

Answer : There is less need for frequent statistics collection.

NR0-015 Teradata Design Architecture V2R5 Practice Test Set 1

A customer has an Active Data Warehouse and restricts database access during financial month-end close, allowing only data loads and a limited number of power users to access the system. Which process should be used to implement the restrictions?


Options are :

  • Define a throttle rule that limits power users, make it a global rule, and make the power users and data loads bypass users.
  • Make sure the power users have the same default account string, create a filter, and make it a global rule.
  • Define a filter with a logon rule that identifies data loads and power users, make it a global rule, and assign it to the financial month-end period.
  • Using the state matrix, define a state that includes a throttle for the power users during the financial month-end period.

Answer : Using the state matrix, define a state that includes a throttle for the power users during the financial month-end period.

A new application was introduced to the production system. End users are reporting slower than expected response times. The database administrator suspects AMP-level skewing is causing performance issues. Which ResUsage table can be used to identify processing skew?


Options are :

  • ResUsageSps
  • ResUsageShst
  • ResUsageScpu
  • ResUsageSvpr

Answer : ResUsageSvpr

Which data should be collected to project future system capacity needs?


Options are :

  • ResUsageSps
  • HostsInfo
  • ResUsageSpma
  • ResUsageSnode
  • QryLogExceptions

Answer : ResUsageSnode

TE0-121 12 Teradata Basics Certification Practical Exam Set 7

What are two reasons to copy DBC performance data to a separate historical database? (Choose two.)


Options are :

  • DBC performance data tables cannot be queried.
  • DBC performance data tables cannot be altered to have fallback turned off.
  • DBC performance data tables are point in time tables only
  • DBC performance data tables are not archived in a backup of database DBC.

Answer : DBC performance data tables cannot be altered to have fallback turned off. DBC performance data tables are not archived in a backup of database DBC.

Database Accounting_DB is defined with 5 GB of PERM space. It has a User_Accounts table and 5 views defined in it. While loading 2 GB of data into the empty User_Accounts, the load process failed with a message that there is no more Perm Space in Accounting_DB. Which is a valid reason for the failure?


Options are :

  • User_Accounts has a PI defined that it is causing skewing.
  • The user id used for loading data does not have enough Perm space
  • The Views are getting built, due to the load process.
  • Table is defined with Fallback.

Answer : User_Accounts has a PI defined that it is causing skewing.

While executing the FastLoad job to load a Fallback table, a database full condition occurs during End Loading Phase (Phase 2). Which action needs to be performed to complete the load?


Options are :

  • Assign more space, remove the DEFINE and INSERT commands from the script, and resubmit the script.
  • Assign more space, remove the End Loading command from the script, and resubmit the script.
  • Assign more space, remove the Begin Loading command from the script, and resubmit the script.
  • Assign more space, specify the checkpoint number in the Begin Loading command in the script, and resubmit the script.

Answer : Assign more space, remove the End Loading command from the script, and resubmit the script.

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 4

You are receiving calls from various user communities that their queries are taking longer to run than normal. Which tool can be used to check if hardware components have failed?


Options are :

  • Configuration Utility
  • Teradata Administrator
  • PMON
  • TDWM

Answer : TDWM

The customer is maintaining two identical systems in a Dual Active Data Warehouse environment. Teradata Query Director is being used to route the traffic between these two systems. Which statement is true about this situation?


Options are :

  • If one system is verybusy,Teradata Query Director will redirect some query sessions to the other system, while load activity will be redirected based on the rules defined in Teradata Query Director.
  • If one system fails,Teradata Query Director redirects new sessions to the fail over system based on the rules defined in Teradata Query Director.
  • To useTeradata Query Director, there must be two active Teradata systems installed and in operation.
  • Teradata Query Director redirects the sessions based on the rules defined for sessions originating from load utilities or business queries to balance the workload across the two systems.

Answer : To useTeradata Query Director, there must be two active Teradata systems installed and in operation.

Which table or view in database DBC should be utilized to analyze a user's CPU utilization on each vproc in a system?


Options are :

  • AMPUsage
  • SessionInfo
  • ResUsageScpu
  • DBQLogTbl

Answer : ResUsageScpu

TE0-124 Teradata 12 Database Administration Practice Exam Set 3

A system administrator is upgrading a system to a newer software release. After the system is upgraded, the administrator is interested in knowing which changes occurred in the execution plans as a result of the upgrade. Which tool can be used to compare the before and after execution plans?


Options are :

  • Query Compare Facility
  • Teradata Workload Analyzer
  • Teradata Query Analyzer
  • Visual Explain

Answer : Teradata Workload Analyzer

To limit DBC.AccessRights table growth, what could be granted?


Options are :

  • NULL
  • PUBLIC
  • Profile
  • ALL

Answer : PUBLIC

An update query that had been running for a long period of time aborted. The table is currently locked and the users want to know when the table will be available. Which utility is used to estimate whether to cancel the rollback for this table?


Options are :

  • Check Table
  • Recovery Manager
  • Teradata Workload Analyzer
  • Teradata Query Manager

Answer : Teradata Workload Analyzer

TE0-124 Teradata 12 Database Administration Practice Exam Set 4

Which feature is allowed in combination with Online Archive?


Options are :

  • Node Archive
  • Cluster Archive
  • Database Copy
  • FastLoad

Answer : Database Copy

Which two parameters does the DBS Control utility allow to be modified or adjusted? (Choose two.)


Options are :

  • Rollback Priority
  • Maximum Sessions per node
  • FSG cache
  • MaxLoadAWT

Answer : FSG cache MaxLoadAWT

What should be utilized to project future system capacity needs?


Options are :

  • ResUsageSvpr
  • QryLogTDWM
  • ResUsageSps
  • HostsInfo

Answer : HostsInfo

TE0-121 12 Teradata Basics Certification Practical Exam Set 5

A system administrator wants to quantify the amount of CPU utilization for transactions submitted from a specific logon source. Which Account String Expansion (ASE) variable will enable this type of analysis?


Options are :

  • &T
  • &D
  • &S
  • &L

Answer : &L

A user USERA has failed with the following error: 2646 No more spool space in USERA. What should be analyzed to identify the possible root cause?


Options are :

  • DBC.DiskSpace for PeakPerm
  • DBC.SessionInfo to identify the session history
  • DBC.ResUsageSAWT to see if you are out of AWTs
  • DBC.Logonoff for concurrent USERA sessions

Answer : DBC.DiskSpace for PeakPerm

An end user has asked the database administrator to review a query that has not performed as expected. A review of the ResUsageSpma data indicates a product join may be occurring when the query runs. Which Database Query Log table can be used to confirm or rule out this suspicion by calculating performance characteristics at the query level?


Options are :

  • DBQLObjectTbl
  • DBQLSummaryTbl
  • DBQLogTbl
  • DBQLSqlTbl

Answer : DBQLObjectTbl

NR0-013 Teradata SQL v2r5 Certification Practice Exam Set 2

What is a critical resource level that may impact the performance of tactical queries?


Options are :

  • 100 user connections per node
  • parser usage at 5%
  • 50WorkNew AWTs in use
  • average system CPU use of 60%

Answer : average system CPU use of 60%

Which two methods can be used to determine space used by a NUSI? (Choose two.)


Options are :

  • UseDBC.DiskSpace to check the index space used
  • UseTeradata Manager to sample the index space used by the table.
  • Use Ferret to check how many data blocks are used by the index sub-table.
  • Use COLLECT DEMOGRAPHICS data to calculate the sub-table space.

Answer : Use Ferret to check how many data blocks are used by the index sub-table. Use COLLECT DEMOGRAPHICS data to calculate the sub-table space.

If an object use count is turned on, which action could be completed after evaluating the object use count statistics?


Options are :

  • Identify high I/O consumers of the system.
  • Establish a user creation policy.
  • Review the expanded account string of the user who last accessed the object.
  • Reclaim disk space by deleting objects that are not used.

Answer : Review the expanded account string of the user who last accessed the object.

NR0-015 Teradata Design Architecture V2R5 Practice Exam Set 1

A user submitted an ALTER TABLE against a very large, highly skewed production table. When the operation began to impact overall system performance, the database administrator canceled the rollback in Recovery Manager. What are two options to access the table data? (Choose two.)


Options are :

  • Drop the table and restore it from backup.
  • Recover the table using the Recovery Manager utility.
  • Access the table using the LOCKING FOR READ OVERRIDE modifier.
  • Issue a RELEASE LOCK on the table.

Answer : Access the table using the LOCKING FOR READ OVERRIDE modifier. Issue a RELEASE LOCK on the table.

Which characteristic is true about AMP Worker Tasks (AWTs)?


Options are :

  • They are limited to 64 per AMP.
  • Additional AWTs are created as they are needed.
  • Currently running AWTs will shutdown if they haven't been used in 20quantums.
  • They can be reserved for special use.

Answer : They are limited to 64 per AMP.

A system is continually running out of AMP Worker Tasks (AWT) and failing to meet business service level agreements (SLAs). The database administrator determines that the best method to solve the problem is to use TDWM to manage the workload. Which feature in TDWM should be used to limit the number of queries for an application?


Options are :

  • Throttles
  • Filters
  • States
  • Events

Answer : Filters

TE0-124 Teradata 12 Database Administration Practice Exam Set 1

An application user logs on and submits several queries with every transaction. A system administrator wants to analyze AMP level I/O skew per query for this application. Which Account String Expansion (ASE) variables would enable this analysis?


Options are :

  • &L&A
  • &L&T
  • &L&S
  • &L&I

Answer : &L&A

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 greater than or equal to 2500 are candidates for tuning and may benefit from additional index analysis.
  • None
  • Queries operating at approximately 1000 are candidates for tuning and may benefit from additional index analysis.

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

A table with 200 GB of data is in an active data warehouse environment. Approximately 20- 30% of the data is being updated nightly using BTEQ. Business rules require that this table remain available 24x7 for user access and updates. Space limitations have prevented fallback from being defined for this table. Which two types of data protection are needed to allow continuous user access while ensuring the data can be recovered in the event of data loss or corruption? (Choose two.)


Options are :

  • Implement a daily online archive.
  • Implement a daily dictionary archive.
  • Implement permanent journaling for the table.
  • Implement a daily all-AMP archive.

Answer : Implement a daily online archive. Implement permanent journaling for the table.

TE0-121 Teradata Basics Practice Test Set 6

A data integration job is used to load large amounts of historical data into a single table. The job has failed because there is no more room in the database which contains the target table. The administrator has examined the distribution of the data across AMPs and found that the data is distributed evenly. The administrator cannot get additional Perm Space from any other databases. Which two actions will reclaim Perm Space and allow the data integration job to complete? (Choose two.)


Options are :

  • Drop views and macros from the database.
  • Run PACKDISK.
  • Remove unnecessary Secondary Indexes from tables in the target database
  • Drop unnecessary statistics

Answer : Drop views and macros from the database. Drop unnecessary statistics

An administrator recognizes that an important transaction is running too slowly. Which tool should be used to dynamically change the transaction's ability to access more resources and improve its capability to run more quickly?


Options are :

  • Gateway Control
  • Query Configuration
  • Performance Monitor
  • Reconfiguration Utility

Answer : Gateway Control

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions