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

FastExport

Answer

MultiLoad

Answer

BTEQ

Question 2

What does the Teradata ARC utility acronym stand for?

Accepted Answer

Archive/Recovery

Answer

Automated Recovery Console

Answer

Advanced Replication Controller

Answer

Application Resource Coordinator

Question 3

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

Accepted Answer

Incremental backup

Answer

Full backup

Answer

Differential backup

Answer

Snapshot backup

Question 4

What is the purpose of the Teradata CheckTable utility?

Accepted Answer

Detects and reports physical data inconsistencies in tables

Answer

Verifies SQL syntax before execution

Answer

Measures query performance statistics

Answer

Validates foreign key constraints across tables

Question 5

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

Accepted Answer

Before-image journal

Answer

After-image journal

Answer

Dual journal

Answer

Transient journal

Question 6

Which Teradata system table tracks the status and history of all ARC backup jobs?

Accepted Answer

DBC.DBCJobs

Answer

DBC.BackupLog

Answer

DBC.ResUsageSpma

Answer

DBC.EventLog

Question 7

What is the correct order of steps when using ARC to restore a single table to Teradata?

Accepted Answer

DROP the table, then run RESTORE

Answer

DELETE the table, then RESTORE

Answer

RESTORE the table directly without pre-deletion

Answer

COPY backup to spool, then INSERT SELECT