Basic Teradata Architecture Understanding Quiz

Which component is responsible for conversion?

• Amp

• PE

• BYNET

• CLI

Non-Unique secondary index operation is always a ___________

• one AMP operation

• ALL AMPs operation

• five AMPs operation

• three AMPs Operation

Which application interface is used by BTEQ?

• ODBC

• JDBC

• CLI

• NONE

Which table will have UNIQUE records?

• MULTISET table with NUPI

• MULTIPSET with UPI

• MULTISET with NUSI

• All of the above

Which of the following utilities use Work table?

• FastLoad

• FastExport

• TPUMP

• Multiload

Which of the following is/are called Virtual Processor?

• AMP

• PE

• Both AMP and PE

• BYNET

Which of the following is/are performed by bynet?

• communication between multiple SMP nodes

• checking syntax errors in SQL queries

• session management

• sending results to client

Which of the following is NOT a way to create a Teradata table?

• CREATE TABLE statement with column definition

• CREATE TABLE from a node

• CREATE TABLE from an existing table

• CREATE TABLE statement with a SELECT statement

Which command displays the create statement of an object?

• show

• help

• Both show & help

• None of these answers

​ ​ ​ Which of the following tables have DDL stored in data dictionary, but does not share the data?

• Permanent

• Derived

• Volatile

• Global Temporary