TeraData Interview Questions - 4

1. Teradata acts as a data store to multiple hosts to provide _____. (Choose two.)

• multiple complex queries that run concurrently
• a data mart implementation based on functional units
• 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.)

• Space management is handled internally by the AMPs.
• The Database Administrator determines where data is placed.
• Data distribution is automatic.
• Manual partitioning schemes are required.

3. What are two examples of an OLTP environment? (Choose two.)

• Many transactions involve a small amount of data.
• 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.

4. Which three queries against a retail database are considered DSS? (Choose three.)

• decide what to put on sale
• automatically reorder products
• validate a credit card
• look-up price of a specific item
• determine monthly sales

5. What is a common data source for the central enterprise data warehouse?

• operational data stores
• backup tapes
• logical data marts
• dependent data marts

6. In which phase of the Active Data Warehouse evolution do you use data to determine what will happen?

• analytical modeling
• ad hoc queries
• continuous update
• pre-defined reports
• event based triggering

Read more...

TeraData Interview Questions - 3

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.
• Each Foreign Key must exist as a Primary Key.
• Foreign Keys provide a second level uniqueness.

9. The Teradata database supports logical models because it _____. (Choose three.)

• requires separate history and current data tables
• stores the data for faster access
• has the ability to perform large aggregations during query runtime
• has the ability to perform up to 64 joins in a single query

10. Cliques are physically composed of _____.

• gateways
• PEs
• AMPs
• nodes

11. Which statement about spool space is true?

• Spool space must be specified during creation of the user.
• Spool space is permanent space.
• Spool space is limited to the size of the table.
• Spool space is used to hold the intermediate result set.

Read more...

TeraData Interview Questions - 2

12. Which statement is true if using NUPIs to accomplish data distribution?

• Uniform row distribution is accomplished using UPIs.
• The low-order 16 bits of the row hash are input to the hash map.
• The increase of hash buckets has resulted in more hash collisions.
• Duplicate NUPI values will produce the same row hash.

13. Which three statements are true for Primary Keys and Primary Indexes? (Choose three.)

• They are both optional in a Teradata table.
• They are conceptually the same.
• They can be the same column.
• They can contain unique data values.
• 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
• based on hashing of the Primary Index
• automatic distribution of the data

15. Which three statements are true about the way Teradata handles data access? (Choose three.)

• Skewed data distribution does not affect data access.
• The rows of each table are distributed among all AMPs based on the Primary Index of the table.
• A table stored entirely on one disk offers improved access performance.
• A full table scan accesses all AMPs in parallel.
• 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 guarantees even data distribution.
• A UPI requires no duplicate row checking during loads.
• A UPI is the Primary Key of the table.
• A UPI access is a two-AMP operation.

17. What are the two types of Secondary Indexes? (Choose two.)

• Non-Unique Secondary Indexes
• Unique Secondary Indexes
• Partitioned Secondary Indexes
• Non-Partitioned Secondary Indexes

Read more...

TeraData Interview Questions - 1

18. Which two statements about the Transient Journal are true? (Choose two.)

• Transient Journal operation is automatic.
• Before Images are kept until manually purged.
• It permits successful rollback to the last archive.
• Transient Journals are stored in a user's spool space.
• After the transaction is committed, the Before Images are discarded.

19. What is a clique? (Choose two.)

• a physical construct that defines a secondary access path from a host
• a logical construct that defines disk availability for a group of AMPs
• a group of disk arrays that are physically cabled to a group of nodes
• a group of physical disk drives within a disk array.

20. The database restarts and a node stays down.Which two components will migrate to other nodes? (Choose two.)

• channel attached PE
• GTW
• AMP
• LAN attached PE

21. Which three are Teradata Warehouse Builder operators? (Choose three.)

• UnloadX Field
• Load
• DataConnector
• Stream

22. Within the following list, which tool should you use to collect and analyze database performance?

• BTEQ
• Teradata SQL Assistant
• TDQM
• Teradata Manager

23. X On which three platforms does the ARC utility run? (Choose three.)

• Web based servers
• IBM Mainframe
• network attached servers
• NCR UNIX servers

Read more...