Teradata Teradata Utilities 2

Question 1

In BTEQ, what does the .LOGON command do?

Accepted Answer

Establishes a session connection to a Teradata system

Answer

The .LOGON command in BTEQ connects to a specified Teradata system using the provided host, username, and password to begin a session.

Question 2

What is the FastExport SESSIONS parameter used for?

Accepted Answer

Specifies the number of parallel sessions to use for the data export

Answer

The SESSIONS parameter in FastExport controls how many parallel sessions are opened, directly affecting throughput for large data extractions.

Question 3

Which phase of a MultiLoad job is responsible for acquiring locks and reading the input data file?

Accepted Answer

Acquisition Phase

Answer

During the Acquisition Phase, MultiLoad reads input data, acquires table locks, builds hash tables, and loads rows into work tables on each AMP.

Question 4

What does the BTEQ command .SET WIDTH do?

Accepted Answer

Sets the maximum line width for report output formatting

Answer

.SET WIDTH specifies the maximum character width of each output line in BTEQ, controlling how reports wrap or truncate when printed.

Question 5

What is the role of the Teradata Archive/Recovery (ARC) utility?

Accepted Answer

Backs up and restores Teradata databases, tables, and journals

Answer

ARC (ARCMAIN) performs online and offline backup and recovery of Teradata databases, tables, and journals to tape or disk-based media.

Teradata Practice Test