Free TE0-121 Braindumps


  • Exam Number: TE0-121
  • Provider: TeraData
  • Questions: 189
  • Updated On: 11-Dec-2018


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

Get The Premium Version

Allbraindumps.com
 Test Questions PDF from Myitguides.com

 Test Questions PDF from Myitguides.com