TE0-124 Teradata 12 Database Administration Practice Exam Set 5

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


Options are :

  • It duplicates data across the system.
  • It is easier to review EXPLAINs on queries.
  • It allows for the collection of statistics on join and value columns.
  • It allows for the addition of partitioned primary indexes for query performance.

Answer : It duplicates data across the system. It allows for the addition of partitioned primary indexes for query performance.

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

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 if there are any queries currently blocked?


Options are :

  • ctl/xctl
  • Teradata Manager
  • Locking Logger
  • TDWM

Answer : Teradata Manager

If the PARTITIONS WHERE option is missing for a RESTORE operation from an archive of a single partition, what is the default action?


Options are :

  • Delete all the rows in the table and restore the data from the single-partition archive.
  • The table is dropped and the data is restored from the archive.
  • Only overwrite the partition in the table with the data from the single-partition archive.
  • There is no default action. The partitions must be specified to restore from a partitioned archive.

Answer : Delete all the rows in the table and restore the data from the single-partition archive.

A customer wants to use a continuous load strategy into a single transaction table for data that will arrive multiple times within each hour of the day. Which load utility is most optimal for the task?


Options are :

  • Teradata Parallel Data Pump (TPump)
  • MultiLoad
  • Teradata Parallel Transporter (TPT) using the Update Operator
  • Teradata Parallel Transporter (TPT) using the Load Operator

Answer : Teradata Parallel Transporter (TPT) using the Update Operator

TE0-125 Teradata 12 Solutions Development Practice Exam Set 3

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


Options are :

  • PUBLIC
  • ALL
  • NULL
  • Profile

Answer : PUBLIC

A user calls to complain that he is having problems logging into the system because their password is incorrect. The user has been on vacation for the last month and suspects that another user has changed their password and has been accessing the system with their user ID. Which two methods can the database administrator use to determine if such a security violation has occurred? (Choose two)


Options are :

  • Analyze entries in theDBC.Logon view.
  • Look for rows in theDBC.LogOnOff view.
  • Determine if a row was created in theDBC.SecurityLog table.
  • Evaluate theDBC.AccessLog view for queries that may have been run

Answer : Look for rows in theDBC.LogOnOff view. Evaluate theDBC.AccessLog view for queries that may have been run

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 app


Options are :

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

Answer : &L&S

TE0-125 Teradata 12 Solutions Development Practice Exam Set 2

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 :

  • 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.
  • Define a throttle rule that limits power users, make it a global rule, and make the power users and data loads bypass users.
  • 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.

Queries have been submitted to the Teradata database from multiple users sharing the same Userid over time. Which DBC view is used to parse the LogonSource column and retrieve the network or channel Userid of the sessions?


Options are :

  • LogOnOff
  • AccessLog
  • AccountInfo
  • SessionInfo

Answer : LogOnOff

While a MultiLoad Import Task job is executing, an AMP fails. The script has specified AMPCHECK NONE. The script is loading two target tables. One target table is defined as Fallback and the second table is defined as Non-Fallback. Which action will MultiLoad perform?


Options are :

  • MultiLoad will apply changes to Fallback tables and build a recovery table for the NonFallback table that must be manually applied when the AMP is back online
  • MultiLoad will stop since one of the Target tables is Non-Fallback.
  • MultiLoad will apply changes to the Fallback tables only.
  • MultiLoad will apply changes to the Fallback tables and the script must be resubmitted to apply changes to the Non-Fallback table when the AMP is back online.

Answer : MultiLoad will apply changes to the Fallback tables only.

NR0-015 Teradata Design Architecture V2R5 Practice Test Set 3

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


Options are :

  • Active Allocation Groups
  • ResUsageSnode
  • CSPSessionInfo
  • QryLogTDWM
  • Acctg

Answer : ResUsageSnode

A database administrator needs to provide additional performance improvements for the queries submitted by the claims department. The Claim table was redefined to have a PPI with a partitioning expression of Claim_date. The performance improved for 60% of the queries. Through additional analysis, it is determined that 70% of the queries access the Claim table by Claim_date and State_id, while the other 30% access by Claim_date or by State_id. The current primary index of the Claim table is Claim_id. The partitioned primary index of Claim_date has been defined with a one month interval. Which action could potentially provide performance benefit that will support all of these different access paths to the Claim table?


Options are :

  • Add multi-value compression on the columnClaim_id in the Claim table.
  • Remove the partitioned primary index from the Claim table.
  • Add a non-unique secondary index ofClaim_date and State_id to the Claim table.
  • Modify the Claim table's PPI to a multi-level PPI ofClaim_date and State_id.

Answer : Modify the Claim table's PPI to a multi-level PPI ofClaim_date and State_id.

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
  • &L
  • &S

Answer : &L

TE0-125 Teradata 12 Solutions Development Practice Exam Set 3

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 number of transactions submitted and all tables accessed by this user group needs to be tracked. Which type of logging should be used for this application group?


Options are :

  • Summary
  • Detail
  • Explain
  • Threshold

Answer : Threshold

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 Index Statistics
  • Collect Demographics
  • Collect Statistics
  • Collect Index Counts

Answer : Collect Index Counts

A small communications company has an application with a large transaction table of cellular telephone calls as well as a call type table with 20 values. When would it be beneficial to use sample statistics?


Options are :

  • on a skewed non-index column in the transaction table
  • on an evenly distributed column in the transaction table
  • on the call type table with evenly distributed PI values
  • on the call type table with skewed PI values

Answer : on the call type table with skewed PI values

NR0-016 NCR Teradata Application Development V2R5 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 how many WorkNew tasks are currently in use?


Options are :

  • WorkMON
  • AWTMON
  • TDWM
  • PMON

Answer : TDWM

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 :

  • ResUsageScpu
  • ResUsageShst
  • ResUsageSvpr
  • ResUsageSps

Answer : ResUsageSvpr

Which utility can be used to display the current system hardware configuration?


Options are :

  • gtwglobal
  • filer
  • ctl/xctl
  • ferret

Answer : gtwglobal

TE0-124 Teradata 12 Database Administration Practice Exam Set 5

Which three activities are performed by the reconfig utility? (Choose three.)


Options are :

  • redefine partitions in the system
  • revise the config map to reflect addition and deletion of vprocs and hosts
  • recalculate hash bucket assignments
  • redefine the database configuration based on the new config maps
  • redistribute data among AMPs that were added or deleted

Answer : recalculate hash bucket assignments redefine the database configuration based on the new config maps redistribute data among AMPs that were added or deleted

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


Options are :

  • CSPSessionInfo
  • CPU usage by user
  • DBC.Events
  • AMP Worker Tasks

Answer : DBC.Events

A customer has a critical application that runs 24x7. They have experienced data loss on the system in the past and have since implemented fallback on all their critical tables. The customer recently experienced a restart which occurred after two physical disks in the same rank failed. They have since replaced the disks, but now need to restore data to these new disks. Which method should they use to restore data to these disks?


Options are :

  • Restore data using the Down AMP Recovery Journal.
  • Restore data by performing a full archive restore.
  • Restore data from the data dictionary.
  • Restore data from the Transient Journal.

Answer : Restore data using the Down AMP Recovery Journal.

TE0-121 Teradata Basics Practice Test Set 6

Which two are true about when the object use count data held in cache will be written to disk? (Choose two.)


Options are :

  • when the cache cannot store any more object data
  • when theDBC.ObjectUseCollect macro is executed
  • when the object use count parameter is turned off
  • whenObjectUseCountCollectRate in DBS Control is reached

Answer : when the cache cannot store any more object data whenObjectUseCountCollectRate in DBS Control is reached

A customer wants to create a specific user-defined type (UDT) so that all users in the system can use it. Which management tool is available for the task?


Options are :

  • Administrative Workstation
  • Teradata Multi-System Management (TMSM)
  • Teradata Administrator
  • Teradata Dynamic Workload Manager (TDWM)

Answer : Administrative Workstation

which operation is allowed on a table during an Online Archive of that table?


Options are :

  • Drop the table
  • FastLoad
  • Delete rows
  • Add a column

Answer : Delete rows

NR0-015 Teradata Design Architecture V2R5 Practice Exam Set 1

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions