Teradata Teradata Administration 3

Question 1

What is the primary utility used for backup and recovery operations in Teradata?

Accepted Answer

ARC (Archive/Recovery)

Answer

ARC (Archive/Recovery) is Teradata's native backup and restore utility that backs up databases or tables to tape or disk and restores them during recovery operations.

Question 2

What does the Teradata ARC utility acronym stand for?

Accepted Answer

Archive/Recovery

Answer

ARC stands for Archive/Recovery, reflecting its dual purpose of archiving (backing up) Teradata data and recovering it when needed.

Question 3

Which type of ARC backup captures only the data blocks that have changed since the last backup?

Accepted Answer

Incremental backup

Answer

An incremental backup in Teradata ARC copies only the data blocks modified since the previous backup, reducing backup time and storage compared to a full backup.

Question 4

What is the purpose of the Teradata CheckTable utility?

Accepted Answer

Detects and reports physical data inconsistencies in tables

Answer

CheckTable scans Teradata tables for structural and data inconsistencies such as corrupt rows, duplicate primary index values, and AMP skew issues that indicate physical corruption.

Question 5

Which Teradata journal type retains before-image copies of rows to support transaction rollback?

Accepted Answer

Before-image journal

Answer

A before-image journal stores the original versions of rows before they were modified, enabling Teradata to roll back uncommitted transactions and restore rows to their prior state.

Teradata Practice Test

Teradata Practice Test

Teradata Teradata Administration 3