A score of 20 of the 25 is normally considered a passing score. Use this information to assess your readiness to take the Teradata Certification Exams. When you are satisfied with your answers, click on the SUBMIT button at the end of the test. You will receive immediate notification of your score. 1. What is a possible cause for a Teradata system slowdown? insufficient host memory for TDP facility exceeding 80 F (27 C) lost LAN connectivity 68 AMP Worker Tasks on an SMP 2. Which information is collected in ResUsage table ResUsageSpma? logical device information channel and LAN host information vproc information SCSI controller information node processor information 3. Which two can be viewed with the AMPUsage view? (Choose two.) physical I/O session priority CPU time logical I/O parser activity 4. What are $L, $M, $H, and $R examples of? process groups allocation groups performance groups user partitions resource partitions 5. Which two types of collection options are allowed with Database Query Log (DBQL)? (Choose two.) threshold logging user logging database logging default logging 6. If required, during which Teradata Warehouse Builder Load Operator processing phase are Fallback rows generated? phase two phase three phase one phase four 7. Which parameter should you use to throttle TPump? PACK RATE SERIALIZE THROTTLE 8. What are two functional components of the Teradata Warehouse Builder? (Choose two.) utilities session control operators operator interface 9. Which two actions cause rows to be inserted into DBC.AccessRights? (Choose two.) an implicit grant to an owner an automatic grant to a creator an explicit grant to a user an inherited privilege on a nested role 10. A user needs to update rows in a table referenced by a view. Which privilege allows the user to perform this action? UPDATE privilege on the user UPDATE privilege on the underlying table referenced by the view REFERENCE privilege on the underlying tables referenced by the view DROP VIEW privilege on the user's view 11. When do inherited profile parameters take effect? (Choose three.) after an update to the DBC.AccessRights table upon the next logon starting with the current transaction in response to a SET SESSION starting with the next transaction 12. What is the limit on the number of roles that can be granted to a single user? 32 64 one unlimited 16 13. Which system view identifies the amount of remaining disk space in a database? DBC.DiskSpace DBC.SysInfo DBC.Tables DBC.TableSize 14. What do roles do? (Choose three.) reduce dictionary contention during DDL operations reduce disk space usage simplify access rights administration reduce logon time allow more concurrent users 15. How many sessions can a gateway handle? 600 1200 1800 2400 16. What are two benefits of using session pools? (Choose two.) Sessions are assigned to the same PE. Sessions are started automatically when a job is submitted. Sessions can be started with one command. Sessions stay with the PE to which they are assigned. 17. Which information is stored in the Transient Journal? before and after images of changed data rows images of inserted data rows before images of changed data rows after images of changed data rows 18. What is the advantage of a small cluster size? faster down AMP recovery in individual clusters more efficient update operations faster transaction recovery in individual clusters on a multi node system less likely for two AMPs in a cluster to fail at the same time 19. Which three types of archives are available with ARC? (Choose three.) index subtables data tables journal tables dictionary tables 20. When must you rebuild indexes for non-Fallback tables after a restore operation? (Choose three.) when a RELEASE LOCK statement executes before archive completes when a restore operation is not an all-AMP restore when an AMP is offline during an archive or restore when a dropped object is copied back to the original system when the restore includes the NO BUILD option 21. Which DBSControl command is used to view the General settings? SHOW GENERAL DISPLAY GENERAL SHOW DBSControl VIEW DBSControl GENERAL VIEW GENERAL 22. Which three are updated when using the Reconfiguration utility? (Choose three.) vdisk mapping configuration maps table IDs space accounting hash bucket arrays 23. Which Teradata Manager application is used to define the actions that should take place when specific events occur on a Teradata system? Alert Viewer Error Log Analyzer Alert Policy Editor Configuration Check 24. Which three can be used to analyze query performance? (Choose three.) DBC.AccountInfo Performance Monitor DBC.Events DBC.AMPUsage Database Query Log 25. Which utility can be used to monitor down AMP recovery? Performance Monitor qrysessn AMPManager ferret RCVManager