A score of 24 of the 30 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 are the two tradeoffs that must be considered in making primary index choices? (Choose two.) distribution access block size row size 2. What are three characteristics of third normal form? (Choose three.) Indexes are defined on the attributes. There are no repeating groups. Attributes must relate to the primary key and not to each other. Attributes must relate to the entire primary key. Attributes must relate to the entire foreign key. 3. What information is needed to evaluate primary index distribution? (Choose two.) maximum number of columns null number of distinct values within the primary index column non-typical number of rows per distinct value maximum number of rows per distinct value 4. What does the TSET utility do? (Choose two.) creates a view of your data demographics allows you to schedule statistics collection allows you to import data demographics from one system to another allows you to import system characteristics from one system to another allows for the importing of workloads from other Teradata utilities 5. Which two tools allow you to make changes to the database? (Choose two.) Index Wizard Visual Explain Statistics Wizard TSET 6. What does vertical partitioning on a table do? (Choose two.) separates columns from a table for performance (shorter rows) reduces the number of columns in a table to the bare minimum eliminates ranges of data values that are less often used from a query and thereby reduces the time taken for a table scan reduces the number of columns in a table to those needed by most queries 7. Which three statements are true about join indexes? (Choose three.) They can be used with only three table joins or less because otherwise the Optimizer will not use it. They can cover a query as long as there are fewer than 65 columns selected or used in the WHERE clause. They can provide an alternate path to a table if there are more than one commonly used column(s) to access the table. They can be a substitute for Summary tables when used with aggregation. They can be used with inequality conditions for the ON clause. 8. Which denormalization technique can be applied to a table to help optimize query access when there are many columns that are not often used? derived data repeating groups vertical partitioning pre-joined tables horizontal partitioning 9. Your application frequently references sales data by month. It is occasionally necessary to access this sales data across months. The retrieval applications reference the data by product and location. Which three statements are true? (Choose three.) A partition key of month must be redefined every month by issuing an ALTER TABLE command in order to add the new month's partition. A primary index on product and location minimizes row redistribution. A partition key of month reduces the scan time for retrieving a month's data. A partition key of month increases local AMP scan time if the primary index doesn't include month. 10. Which two statements are true concerning creators and owners of objects? (Choose two.) If a DBA creates an object in your database, you are the creator and the owner of that object. If you create an object, you are the creator of the object but not necessarily the owner of that object. If you create an object in another user's space, you are the creator of that object but the other user is the owner of that object. If an object is directly below you in the hierarchy, you are the creator and the owner of that object. 11. Which utility is required for updating a multiset table with a sparse join index, a value ordered secondary index, and can update five tables from one source? FastLoad MultiLoad FastExport TPump 12. Which parameter in TPump needs to be coded to ensure incoming transactions are applied in the correct order? TENACITY SEQUENCE ORDERED ROBUST SERIALIZE 13. Which Teradata utility does not have fully automatic Checkpoint/Restart capabilities? FastExport FastLoad ARC BTEQ 14. A DBA needs to copy a one billion row table that is 30,000 bytes wide from the production to the test system. Which two methods can be used to accomplish this? (Choose two.) use BTEQ to export the production table, then APPLY it onto the test system use BTEQ to export the production table, then COPY it onto the test system FastExport the production table, then FastLoad it onto the test system archive the production table, then COPY it onto the test system 15. What is the maximum number of concurrent TPump sessions that can be running at the same time? 64 256 unlimited 128 16. It takes 36 hours to backup your large database. You have opted to take one backup and to enable Permanent Journaling to back up the changes on a daily basis. What are two characteristics of Permanent Journaling? (Choose two.) On a daily basis, you must archive, then delete the journals. Any tables using Permanent Journaling do not require transient journal activity. On a daily basis, you must checkpoint with save, then archive the journals. For a recovery, you must restore the original image of the database, then restore and roll forward each journal in sequence. 17. What is included in data block overhead? number of AMPs * 512 rowid + spare byte + presence byte(s) block header and trailer row header and trailer 18. Which option completes the following equation for calculating Row "Overhead"? Length code + rowid + spare byte + presence byte(s) + (Partition number) + compressed column values + 2 bytes in block reference array 2 bytes in block reference array generated identity column value + 2 bytes in block reference array (varchar offest array size) + 2 bytes in block reference array 19. Your application data loads are running 7x24 using TPump. What do you need in order to back up the data tables? views with "locking for access" modifiers Fallback on your tables staging tables for the TPump rows Permanent Journals 20. Which two statements about spool space are true? (Choose two.) It can reside on all disk cylinders with any unused space. It is a system-wide resource. Disk space used for spool space is pre-allocated to each user. The spool space limit is defined in the user definition. 21. When setting up Roles for the Teradata System, which two questions must the administrator consider? (Choose two.) Does the user need create object access to a database? How much spool space do the users need for their activities? Which time of the day will the user need the most service from Teradata? How many different job functions that a user might need to have? 22. Concerning creating roles in Teradata, the WITH ADMIN option allows you to do which three functions? (Choose three.) grant any role you create to other users assign a default role to a user grant any role you create to other roles drop any role or profile you created change the password for all users with an assigned role 23. Which statement is true concerning restoring objects from a complete database archive? The ARC utility first drops all objects from the database to be restored and then restores all tables, views, macros, and triggers from the archive but any stored procedures must be recompiled manually. The ARC utility only overlays any objects from the database to be restored rather than dropping and recreating any objects from the archive. The ARC utility first drops all objects from the database to be restored and then restores all tables, views, and macros from the archive but any triggers or stored procedures must be recompiled manually. The ARC utility first drops all objects from the database to be restored and then restores all tables, views, macros, triggers, and stored procedures from the archive without any need for manual processing. 24. During a daily application audit, you discover a batch update has run twice with the same input file. The table that has been updated twice has a before image permanent journal and is archived every other week. The update file includes unrecoverable changes. What is the most effective recovery method? delete the table and start over, losing all history use the Permanent Journal to roll back the updates to the values prior to the second update re-execute the update process using the same input file after it has been multiplied by -1 recover the table using the last archive and orderly process all update files to current day 25. A company is developing a business continuity plan. The company's greatest concern is to ensure data is available should a disaster occur at the site. What provides the optimal solution for data availability, should an event occur causing loss of data only at the site? sending the input files offsite regularly copying the data to a different database using ARCMAIN to generate dual copies of archive, one to be sent offsite using ARCMAIN to archive data and send the archive offsite 26. To ensure a query does not exceed a set amount of processing power, which policy can be used with priority scheduling? Default Limited Immediate Absolute 27. Which three functions of Priority Scheduler administrator help you to maintain performance as queries are running? (Choose three.) views CPU utilization and shows all process on the CPU views sessions in each performance group allows you to change parameters at any time charts realtime usage 28. Which two Priority Scheduler options are available to ensure that high-priority tactical requests are given special treatment in a mixed workload environment? (Choose two.) high relative weight for the submitting user's Allocation Group session milestones for tactical requests reserved AMP Worker tasks immediate scheduling policy for the Allocation Group used for tactical requests 29. What can you do to allow Priority Scheduler to control a CPU intensive query? use the Immediate Policy to immediately place the user into the low tier Allocation Group and monitor the user's query performance every 60 seconds use the Relative Policy on the user's existing Allocation Group use a "penalty-box" Allocation Group with an Absolute Policy and move the user into a separate Resource Partition use the Default Policy and reduce the user's priority to $L 30. Which three types of input can be used to define restrictions that may be applied to a Teradata system through TDQM? (Choose three.) a TDQM output log from "Warning Mode" tests run desired response time by time of day the need for expedited access for special users during critical periods space utilization reports from Teradata Manager Locking Logger output