Explanation:In Microsoft SQL Server 2005 Analysis Services (SSAS), a linked dimension is based on a dimension that is stored in another Analysis Services database. 7. The _______ attribute is the attribute in a dimension that identifies the columns in the dimension main table that are used in foreign key relationships to the fact table.
A. Dim
B. KEY
C. PK
D. None of the mentioned
Answer:A
Explanation:In Microsoft SQL Server 2005 Analysis Services (SSAS), a linked dimension is based on a dimension that is stored in another Analysis Services database. 7. The _______ attribute is the attribute in a dimension that identifies the columns in the dimension main table that are used in foreign key relationships to the fact table.
A. Dim B. KEY C. PK D. None of the mentioned
Explanation:Typically, the key attribute represents the primary key column or columns in the dimension table. 8. Which of the following property is set to zero so that all levels are not created ?