Teradata Random 5

Question 1

Which Teradata feature allows partitioning a table by a range of column values to improve partition elimination?

Accepted Answer

Partitioned Primary Index (PPI)

Answer

A Partitioned Primary Index (PPI) divides table rows into partitions based on column value ranges, allowing the optimizer to skip irrelevant partitions during scans.

Question 2

In Teradata SQL, what does the QUALIFY clause do?

Accepted Answer

Filters rows based on the result of an ordered analytical (window) function

Answer

QUALIFY filters the output of ordered analytical functions (similar to HAVING for aggregates), allowing conditions on window function results without a subquery.

Question 3

What is the effect of specifying CASESPECIFIC in a Teradata column definition?

Accepted Answer

Makes string comparisons case-sensitive for that column

Answer

CASESPECIFIC makes character comparisons on that column case-sensitive, so 'ABC' and 'abc' are treated as different values.

Question 4

Which Teradata concept describes the maximum amount of disk space allocated to a user or database?

Accepted Answer

Perm Space

Answer

Perm Space is the maximum permanent disk storage quota allocated to a user or database for storing tables and their data.

Question 5

In Teradata, what is a Join Index used for?

Accepted Answer

To pre-join and aggregate data from one or more tables to accelerate query performance

Answer

A Join Index stores precomputed joins or aggregations of one or more tables, allowing the optimizer to satisfy certain queries from the index rather than the base tables.

Teradata Practice Test

Teradata Practice Test

Teradata Random 5