WorksheetsBasic Teradata Architecture Understanding Quiz
Total questions: 23
Worksheet time: 12mins
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
What is used by AMPs and PEs for internal communication?
The Disk
BYTNET
A priprietary LAN
An internode VAN
One node can handle maximum ___ many virtual processors.
128
64
32
16
Which of the following is true regarding Compute Clusters? (May have more than one correct answer)
Compute clusters don't have any permanent data
A compute cluster can read large tables in object storage
Compute clusters DO have permanent data
Compute clusters exist as separate cluster of a BYNET
TRUE or FALSE: SMPs have multiple nodes that work together to comprise a larger scale of Teradata implementation
TRUE
FALSE
What are the two types of Teradata Systems?
BYNET & AMP
DISK & AMP
PE & DISK
SMP & MPP
What are the primary components of Teradata architecture?
Parsing Engine
Bynet
Clusters
AMP
What is the use of FALLBACK?
to conduct a full table scan
When results of query exceeds AMP space
to handle AMP failures
To check if there are any record with the same row hash
Which is NOT a way for a user to access data in Teradata tables?
Through Primary Index
Through a Hashmap
Through Secondary Index
Full Table Scan
The difference between SET and MULTISET tables is that: SET table does not allow duplicate records whereas MULTISET allows duplicate records
True
False
Which of the following statements is false about Primary Key and Primary Index?
They can be the same column
They can contain unique data values
They can be defined in a "Create Table" statement
They are both optional in a Teradata table
The process of changing the Number of AMP in a system is called ______
Redistribution
Reconfiguration
Hash Mapping
Partitioning
MULTISET TABLE is created by default in ____ transaction mode
ANSI
Teradata
Both ANSI and Teradata
None of these
_____ function can change a column of TIMESTAMP data type to a DATE data type.
EXTRACT
CAST
INTERVAL
Add_month
