Teradata Teradata MCQ 4

Question 1

Which Teradata feature enables rolling window partitioning by automatically deleting the oldest partition and adding a new one?

Accepted Answer

Rolling partition maintenance via ALTER TABLE MODIFY

Answer

ALTER TABLE MODIFY allows adding and dropping partitions to implement a rolling window without physically moving data.

Question 2

In Teradata's BYNET, what is its primary function?

Accepted Answer

High-speed inter-node communication fabric for redistributing rows

Answer

BYNET is Teradata's high-bandwidth, fault-tolerant interconnect that moves rows between nodes during join and aggregation operations.

Question 3

What does the Teradata 'CASE' expression return when no WHEN clause matches and no ELSE is specified?

Accepted Answer

NULL

Answer

If no WHEN condition matches and no ELSE clause is provided, the CASE expression returns NULL.

Question 4

Which Teradata workload management feature assigns queries to performance groups based on rules like user, time of day, or query band?

Accepted Answer

TASM (Teradata Active System Management)

Answer

TASM classifies workloads using filters and throttles, then manages resources and priority dynamically based on defined rules.

Question 5

In Teradata, what does 'skew factor' measure?

Accepted Answer

How unevenly rows are distributed across AMPs

Answer

Skew factor quantifies data distribution imbalance across AMPs; high skew causes some AMPs to do disproportionately more work.

Teradata Practice Test