The ATTRIBUTE clause:
A) Defines a functional dependency between a dimension level and a non-source column
B) Specifies a constraint of the dimension
C) Both of the above
D) None of the above

Question

Quizplus · Accepted Answer

The ATTRIBUTE clause in a dimensional table's CREATE TABLE statement specifies a constraint of the dimension and defines a functional dependency between a dimension level and a non-source column. Therefore, both options A and B are correct.

The ATTRIBUTE Clause