Which three are terms that are associated with star schema and dimensional modeling?
Answer(s): A, C, D
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
When comparing a Primary Key and a Primary Index, which statement is unique for the
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.
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