Topic 1

QUESTION: 1

Which three are terms that are associated with star schema and dimensional modeling?
(Choose three.)
A. facts
B. entities
C. attributes
D. snowflakes
E. dimensions
F. relationships

Answer(s): A, C, D
QUESTION: 2

For what reason would a multi-level partitioned primary index (MLPPI) be defined as
opposed to a single-level partitioned primary index (PPI)?
A. to eliminate the need for a USI
B. to avoid the need to collect statistics on PARTITION
C. to provide multiple access paths to rows in the base table
D. to improve data distribution across all partitions on all AMPs

Answer(s): C
QUESTION: 3

When comparing a Primary Key and a Primary Index, which statement is unique for the
Primary
Key?

A. It implies an access path to the data.
B. It identifies relationships between views.
C. It can be made up of a maximum of 64 columns.
D. It is a logical database representational concept.

Answer(s): D
QUESTION: 4

For a table-level lock, which two lock type combinations are compatible? (Choose two.)

A. Read and Read
B. Read and Share
C. Read and Write

2

Free TE0-121 Exam Braindumps

Exam Code: TE0-121 Exam Title: Teradata 12 Basics exam
Exam Provider: TeraData

Pass your Teradata 12 Basics exam exam with these free Actual Questions and Answers