0 Welcome to the Teradata Quiz. Each time you take the quiz, a different set of questions will be asked. We are adding new questions on a regular base. At the end of the quiz, we will show you the correct answers, your score and the average score of all people. Enter your name and press "NEXT" to start the quiz Name Email 1. Which of the following are characteristics of a full table scan? It is a way to access the data without using an index It accesses all AMPs sequentially It requires a read lock to operate It accesses each data row only once2. Is "SELECT DATE;" and "SELECT DATE FROM (SELECT NULL AS x) t01;" delivering the same result? Yes No3. Are tables without Primary Index (NOPI) always distributed evenly across all AMPs? Yes No4. Which of these technical join types are available on Teradata? Hash Join Merge Join Sliding Window Merge Join Product Join Left Outer Join5. Which of these technical join types are available on Teradata? The FastLoad Protocol The MultiLoad Protocol The TPump Protocol The FastExport Protocol The Backup & Restore Protocol6. Where are random AMP samples stored? DBC.StatisticsV Table Header in FSG cache Parsing Engine7. A USI has which advantages? duplicate row checking is not necessary cannot insert rows with duplicate USI values can eliminate a full table scan saves disk space is used to cover queries8. Assume you have a very long running and resource intense query. Were would you definitely not put it? The SLG tier The tactical tier The timshare tier9. Which compression methods are related to Teradata Columnar? Run-length Encoding Block Level Compression Dictionary Encoding Delta Encoding TIM Encoding10. Is the row hash of the value 4 for INTEGER and DECIMAL(5,0) the same? Yes NoBe sure to click "Submit Quiz" to see your results (click only once, the rating process may need a couple of seconds)!