Pass the Teradata Vantage Certified Associate TDBL1-16.20 Questions and answers with CertsForce

Viewing page 3 out of 3 pages
Viewing questions 21-30 out of questions
Questions # 21:

Which type of lock is automatically placed for an INSERT?

Options:

A.

UPDATE


B.

HUT Write


C.

EXCLUSIVE


D.

WRITE


Expert Solution
Questions # 22:

How does a Primary Index differ from a Primary Key?

Options:

A.

A Primary Key may be null


B.

A Primary Index determines data distribution.


C.

A Primary Key determines the access path.


D.

A Primary Index enforces uniqueness.


Expert Solution
Questions # 23:

Which Teradata component provides bi-directional communication between virtual processors (vprocs)?

Options:

A.

Node


B.

Dispatcher


C.

BYNET


D.

Gateway (GTW)


Expert Solution
Questions # 24:

Which part of a data warehouse architecture allows users to explore and model information across all data sources?

Options:

A.

Operational data store


B.

Staging layer


C.

Logical schema


D.

Analytic layer


Expert Solution
Questions # 25:

Which attribute has to be defined at table creation?

Options:

A.

Secondary Index


B.

Block Size


C.

Column Data Type


D.

Fallback


Expert Solution
Questions # 26:

Which relational modeling concept facilitates the use case of storing a value only once?

Options:

A.

Distinctiveness


B.

Cardinality


C.

Atomic


D.

Normalization


Expert Solution
Questions # 27:

What differentiates a database from a user?

Options:

A.

Only databases have spool allocation.


B.

Users have passwords.


C.

Users do not own tables.


D.

Databases own users, users cannot own databases.


Expert Solution
Questions # 28:

Which statement is true about Primary Key or Primary Index?

Options:

A.

Primary Index is a physical access mechanism and allows NULL values.


B.

Primary Key identifies a row uniquely and allows NULL values.


C.

Primary Key can be unique or non-unique and does not allow NULL values.


D.

Primary Index is a physical access mechanism and does not allow NULL values.


Expert Solution
Questions # 29:

Which Teradata Database management tool is responsible for providing high availability?

Options:

A.

Teradata Studio


B.

Teradata Viewpoint


C.

Unity Director


D.

Teradata Query Scheduler


Expert Solution
Questions # 30:

Which Teradata component is responsible for managing the individual disk space?

Options:

A.

AMP


B.

Gateway (GTW)


C.

BYNET


D.

Parsing Engine (PE)


Expert Solution
Viewing page 3 out of 3 pages
Viewing questions 21-30 out of questions