Associate Exam (TDBL1-16.20) Practice Test

Questions # 1:

What does a dimension table describe?

Options:

The attributes of a fact table

The detail table for each dimension

The number of rows in a detail table

The data types of a fact table

Questions # 2:

Which mechanism can be used to upgrade the severity of a lock?

Options:

Locking Request Modifier

Locking Protocol

Two-Phase Commit

Two-Phase Locking

Questions # 3:

Based on consistent performance and control as dominant factors in a data warehouse strategy, which deployment option is most viable?

Options:

Private Cloud

On-Premise

Public Cloud

VMware

Questions # 4:

How does a Primary Index differ from a Primary Key?

Options:

A Primary Key may be null

A Primary Index determines data distribution.

A Primary Key determines the access path.

A Primary Index enforces uniqueness.

Questions # 5:

Which concept is relational database management based on?

Options:

NoSQL

Set Theory

Object-Oriented Model

Network Model

Questions # 6:

Which locking severity is NOT compatible with an ACCESS lock?

Options:

WRITE

EXCLUSIVE

ROW HASH

READ

Questions # 7:

What are virtual processors (vprocs)?

Options:

Vprocs are software processes that run on a node.

Vprocs are system components that manage resource processing.

Vprocs are software processes that run on a Parsing Engine (PE).

Vprocs are communication components that process messages

Questions # 8:

Which type of index can result in skewed table data?

Options:

Primary Index

Secondary Index

Temporary Index

Global Index

Questions # 9:

Which statement is true about both Primary Key and Primary Index in Teradata?

Options:

They both are hashed.

They can be made up of multiple columns.

They can impact data distribution across AMPs.

They must be defined.

Questions # 10:

Which statement is true about a role in the Teradata Data Warehouse?

Options:

It is a collection of access Fights assigned to a user.

It has the feature to store password restriction constraints for the user.

It is the amount of spool space allocated to a user.

It has the authentic user password stored in it.

Viewing page 1 out of 3 pages

Viewing questions 1-10 out of questions

Weekend Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = simple70

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

Exam TDBL1-16.20 Premium Access

Options:

Options:

Options:

Options:

Options:

Options:

Options:

Options:

Options:

Options:

TOP CODES