|1.|| What distinguishes set processing from row processing? |
Set processing normally applies to primary key operations.
Set processing is unsupported by Teradata Utilities.
Set processing efficiently updates large amounts of data.
Set processing is seldom an all-AMP operation.
|2.|| What are two advantages of using a single-level (PPI) table as compared to a non-partitioned table? (Choose two.) |
Fewer AMPs are involved when accessing data.
There is faster access of a single row via a primary index access.
Range-based queries scan a subset of the data without a secondary index.
A table partitioned by column will access fewer partitions when using a primary index.
Fast deletes of all the rows in a partition are possible.
|3.|| Which two will increase the likelihood of a full table scan? (Choose two.) |
The use of an inequality in the query.
The primary index is defined as compressed.
The secondary index is defined on the column with a high number of rows per typical values.
The primary index is not part of the partitioning column.
|4.|| Which two can be achieved with Teradata Active System Management (TASM)? (Choose two.) |
react to hardware failure
influence response times
|5.|| What are three benefits of fallback? (Choose three.) |
During normal processing, reads are performed using the primary copy, while updates are performed on the fallback copy.
During normal processing, reads are performed using the primary copy, while updates are performed on both copies.
Down AMP recovery journal logs transactions and automatically applies them when the AMP rejoins the configuration.
A copy of the data is maintained in the same cliques.
A copy of the data is maintained on a different AMP in the same cluster.