Teradata Random 3

Question 1

In Teradata, what does a Derived Table refer to?

Accepted Answer

A subquery in the FROM clause used as a temporary result set

Answer

A derived table is an inline subquery placed in the FROM clause that produces a temporary result set used by the outer query.

Question 2

Which Teradata join strategy scans both tables on each AMP and performs the join locally without data redistribution?

Accepted Answer

Row Hash Join

Answer

A Row Hash Join occurs when both tables are co-located by their PI, so matching rows reside on the same AMP and no redistribution is needed.

Question 3

What is the maximum number of columns allowed in a Teradata Primary Index definition?

Accepted Answer

16

Answer

Teradata allows up to 16 columns in a composite Primary Index definition.

Question 4

Which Teradata object type is most similar to a stored procedure but returns a value to the calling statement?

Accepted Answer

User-Defined Function (UDF)

Answer

A User-Defined Function (UDF) executes logic and returns a scalar or aggregate value that can be used within a SQL expression.

Question 5

In Teradata Workload Management, what does a Workload Definition (TDWM) primarily control?

Accepted Answer

Resource allocation and priority for queries based on classification criteria

Answer

TDWM workload definitions classify incoming requests and assign resource priorities, concurrency limits, and throttles to manage system throughput.

Teradata Practice Test