A score of 19 of the 23 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. Teradata acts as a data store to multiple hosts to provide _____. (Choose two.) a data mart implementation based on functional units multiple complex queries that run concurrently ease of data replication a single version of the truth 2. Which two statements are true about the way the Teradata database is administered? (Choose two.) Manual partitioning schemes are required. The Database Administrator determines where data is placed. Data distribution is automatic. Space management is handled internally by the AMPs. 3. What are two examples of an OLTP environment? (Choose two.) Transactions take minutes or more to complete. A few complex transactions involve a large amount of data. Transactions take a matter of seconds or less. Many transactions involve a small amount of data. 4. Which three queries against a retail database are considered DSS? (Choose three.) validate a credit card determine monthly sales decide what to put on sale look-up price of a specific item automatically reorder products 5. What is a common data source for the central enterprise data warehouse? logical data marts operational data stores dependent data marts backup tapes 6. In which phase of the Active Data Warehouse evolution do you use data to determine what will happen? analytical modeling event based triggering ad hoc queries continuous update pre-defined reports 7. Which two can be implemented within the centrally located logical architecture of a data warehouse? (Choose two.) independent data mart dependent data mart logical data mart operational data store 8. Which two statements are true about a foreign key? (Choose two.) Foreign Keys cannot contain NULL or missing values. Foreign Keys can change values over time. Foreign Keys provide a second level uniqueness. Each Foreign Key must exist as a Primary Key. 9. The Teradata database supports logical models because it _____. (Choose three.) stores the data for faster access has the ability to perform large aggregations during query runtime requires separate history and current data tables has the ability to perform up to 64 joins in a single query 10. Cliques are physically composed of _____. gateways AMPs nodes PEs 11. Which statement about spool space is true? Spool space is limited to the size of the table. Spool space must be specified during creation of the user. Spool space is permanent space. Spool space is used to hold the intermediate result set. 12. Which statement is true if using NUPIs to accomplish data distribution? Uniform row distribution is accomplished using UPIs. The increase of hash buckets has resulted in more hash collisions. Duplicate NUPI values will produce the same row hash. The low-order 16 bits of the row hash are input to the hash map. 13. Which three statements are true for Primary Keys and Primary Indexes? (Choose three.) They can be the same column. They are both optional in a Teradata table. They can contain unique data values. They are conceptually the same. They can be defined in a Create Table. 14. Which two statements are true of Teradata data distribution? (Choose two.) manual distribution of the data based on hashing of the Primary Key automatic distribution of the data based on hashing of the Primary Index 15. Which three statements are true about the way Teradata handles data access? (Choose three.) A full table scan accesses all AMPs in parallel. The rows of each table are distributed among all AMPs based on the Primary Index of the table. Skewed data distribution does not affect data access. A table stored entirely on one disk offers improved access performance. If an index is referenced in a query, it is used unless a full table scan is determined to be more efficient. 16. What are two reasons for choosing a Unique Primary Index (UPI) verses a Non Unique Primary Index (NUPI)? (Choose two.) A UPI is the Primary Key of the table. A UPI requires no duplicate row checking during loads. A UPI access is a two-AMP operation. A UPI guarantees even data distribution. 17. What are the two types of Secondary Indexes? (Choose two.) Non-Unique Secondary Indexes Non-Partitioned Secondary Indexes Partitioned Secondary Indexes Unique Secondary Indexes 18. Which two statements about the Transient Journal are true? (Choose two.) Transient Journal operation is automatic. After the transaction is committed, the Before Images are discarded. It permits successful rollback to the last archive. Transient Journals are stored in a user's spool space. Before Images are kept until manually purged. 19. What is a clique? (Choose two.) a group of disk arrays that are physically cabled to a group of nodes a group of physical disk drives within a disk array. a logical construct that defines disk availability for a group of AMPs a physical construct that defines a secondary access path from a host 20. The database restarts and a node stays down. Which two components will migrate to other nodes? (Choose two.) GTW channel attached PE AMP LAN attached PE 21. Which three are Teradata Warehouse Builder operators? (Choose three.) Load Field DataConnector Unload Stream 22. Within the following list, which tool should you use to collect and analyze database performance? Teradata Manager TDQM Teradata SQL Assistant BTEQ 23. On which three platforms does the ARC utility run? (Choose three.) IBM Mainframe NCR UNIX servers Web based servers network attached servers