Question 1.
Red Brick Decision Server is implemented on Windows NT by a ____________ that runs as a ____________ .

A. single multithreaded process, Windows NT service
B. Windows NT service, single multithreaded process
C. NTFS file system, Windows NT service
D. none of the above

Answer: A

Question 2.
The ______________ collects statistics for the dynamic statistic tables (DSTs) and performs the actions specified by ALTER SYSTEM commands.

A. listener thread (rbwlsnr)
B. process checker thread (rbwpchk)
C. administration Daemon Process (rbwadmd)
D. Red Brick API thread (rbwapid)

Answer: C

Question 3.
Target indexes and multi-column B-Tree on the foreign key columns of a tact table support:

A. Natural join
B. TARGETJoin
C. Star index
D. Clustered index

Answer: B

Question 4.
Which of the following definitions describe the STAR index?

A. A sorted list of concatenated row IDs from the dimension tables named in the index key
B. A bitmap index based on fact table rows
C. An index built over multiple fact table columns
D. A multi-table join index based on fact table foreign key values
E. a and b
F. a, b, c, and d
G. a, c, and d
H. c and d

Answer: G

Question 5.
The fill factor should always be set to 100% in cases of:

A. Data spaces
B. Star indexes
C. TMU_REORG TEMPSPACE
D. Small domain target indexes

Answer: D

Question 6.
In cases where data is known to be skewed, the recommended target index domain should be:

A. small
B. normal
C. large
D. hybrid

Answer: D

Question 7.
The size of the memory work area for building indexes is set by which parameter?

A. INDEX TEMPSPACE
B. INDEX TEMPSPACE THRESHOLD
C. INDEX MAXSPILLSPACE
D. INDEX DIRECTORY MAXSIZE

Answer: B

Question 8.
The 'default' Red Brick Decision Server index is a:

A. Star Index
B. Target Index
C. B-Tree Index
D. Deferred Index

Answer: C

Question 9.
An ideal DSS STAR schema is said to be ____________ whereas a typical DLTP schema is said to be highly____________.

A. Normalized/denormalized
B. Factual/Dimensional
C. Denormalized/normalized
D. Current/historical

Answer: C

Question 10.
Which of the following describes a conformed dimension:

A. Dimensions that have built-in hierarchies
B. A dimension table that can be shared by one or more fact tables
C. A set of attributes that change overtime
D. All of the above

Answer: B

	Web www.certsbraindumps.com