Teradata Teradata Utilities 2 — Questions and Answers
Question 1: In BTEQ, what does the .LOGON command do?
- Establishes a session connection to a Teradata system (Correct answer)
- Logs SQL activity to a file
- Sets the output log file path
- Authenticates the DBA for system commands
Correct answer: Establishes a session connection to a Teradata system
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?
- Specifies the number of parallel sessions to use for the data export (Correct answer)
- Sets the maximum rows per export file
- Defines the session timeout interval
- Controls which AMPs participate in the export
Correct answer: Specifies the number of parallel sessions to use for the data export
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?
- Acquisition Phase (Correct answer)
- Application Phase
- Cleanup Phase
- Restart Phase
Correct answer: Acquisition Phase
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?
- Sets the maximum line width for report output formatting (Correct answer)
- Limits the number of columns returned
- Controls the session character set
- Defines the maximum row size for a query
Correct answer: Sets the maximum line width for report output formatting
.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?
- Backs up and restores Teradata databases, tables, and journals (Correct answer)
- Archives old partitions to cold storage automatically
- Generates audit logs for DDL operations
- Migrates databases between Teradata versions
Correct answer: Backs up and restores Teradata databases, tables, and journals
ARC (ARCMAIN) performs online and offline backup and recovery of Teradata databases, tables, and journals to tape or disk-based media.
Question 6: In Teradata's TPT framework, what is an 'operator'?
- A reusable component that performs a specific data movement function such as reading, writing, or transforming data (Correct answer)
- A SQL function for string manipulation
- A scheduling unit within TASM workloads
- A named user permission set
Correct answer: A reusable component that performs a specific data movement function such as reading, writing, or transforming data
TPT operators are plug-in components — producers read data (e.g., ODBC operator), consumers write data (e.g., Load operator), and filters transform data between them.
Teradata Teradata Utilities 2
In BTEQ, what does the .LOGON command do?