Free Teradata for Beginner Questions and Answers — Questions and Answers
Question 1: What is the definition of an OLTP environment?
- Transactions typically occur within seconds, not minutes (Correct answer)
- Transactions are write intensive
- The number of rows transaction is large
- The number of rows per transaction is small (Correct answer)
Correct answer: Transactions typically occur within seconds, not minutes
OLTP (Online Transaction Processing) systems are defined by handling many short, fast transactions that complete within seconds, supporting high-concurrency operational workloads. Being write-intensive or processing large row counts describes OLAP/analytical or batch systems, not the defining characteristic of OLTP.
Question 2: What is the correct definition of a main index operation?
- When choosing a primary index you should pick a column with a severely limited value set
- The degree of uniqueness is not critical to efficiency
- Selecting a NUPI for storing data provides for maximum efficiency and makes the best use of the parallel features of Teradata
- If distribution is skewed an all-AMP operation will take longer than if all AMP were evenly utilized (Correct answer)
Correct answer: If distribution is skewed an all-AMP operation will take longer than if all AMP were evenly utilized
Explanation: <br> The statement "If distribution is skewed an all-AMP operation will take longer than if all AMP were evenly utilized" is true about a primary index operation.
Question 3: Data is hashed across all AMPs in Teradata systems that use two cliques.
- Disk Array
- System (Correct answer)
- Cluster
- Clique
Correct answer: System
Teradata hashes data rows across all AMPs in the entire system, independent of how many cliques exist—the hashing mechanism distributes rows system-wide. A clique, cluster, or disk array describes hardware groupings for fault tolerance, not the scope across which row hashing distributes data.
Question 4: A user with no permanent space has been defined by a database administrator. What items are present in this user?
- Tables
- Views (Correct answer)
- Triggers
- Macros
Correct answer: Views
Explanation: <br> If a database administrator has defined a user with no permanent space, the objects that can be found in this user are only volatile objects. <br> <br> In Teradata, a user with no permanent space is called a "no spool" user. This type of user can create volatile tables and views but cannot create permanent tables, indexes, macros, triggers, stored procedures, or any other objects that require permanent space. Volatile tables and views are temporary objects that are automatically dropped at the end of a session or transaction and do not consume permanent space.
Question 5: Which of the following is true regarding temporary space?
- Temporary space is subtracted from SysAdmin
- Temporary space is assigned at the table level
- Temporary space is permanent space currently not used (Correct answer)
- Temporary space is spool space currently not used
Correct answer: Temporary space is permanent space currently not used
Temporary space in Teradata is simply permanent space that is currently unused; it is borrowed from the unused portion of permanent space rather than being a separate physical allocation. It is not spool space, is not assigned at the table level, and is not subtracted from SysAdmin specifically.
Question 6: You create user A with 30 GB of permanent space on a Teradata system that has 100 GB of permanent space. What will user A have if user B is created with 20 GB of permanent space?
- 80 GB
- 10 GB (Correct answer)
- 30 GB
- 70 GB
Correct answer: 10 GB
Explanation: <br> If you have a Teradata system with 100 GB of permanent space and you create user A with 30 GB of permanent space, and then user A creates user B with 20 GB permanent space, user A will have 10 GB of permanent space left.
Question 7: Which Teradata database tool enables you to duplicate a table and restore it there?
- Table Rebuild
- FastExport
- Teradata Copy Tool
- Archive Recovery (Correct answer)
Correct answer: Archive Recovery
Explanation: <br> The utility that allows you to copy a table and restore it to another Teradata database is called Teradata FastExport and FastLoad utilities.
Free Teradata for Beginner Questions and Answers
What is the definition of an OLTP environment?