70-460 Free Dumps Study Materials
Question 9: A production SQL Server Analysis Services (SSAS) cube is processed daily. The users query facts
by using a hierarchy named Geography from a dimension named Geography.
The DimGeography table in the data source view is used as the source of the Geography dimension.
The table has the following structure.
The Geography dimension has three attribute hierarchies:
- City
- State-Province
- Country
The attributes have the following relationships defined: City > State-Province > Country. Each
attribute has a key and a name sourced from the related key and name columns in the
DimGeography table.
During processing, you receive the following error message: "Errors in the OLAP storage engine: A
duplicate attribute key has been found when processing: Table: 'dbo_DimGeography, Column:
StateProvinceKey', Value: '23'. The attribute is 'State-Province'."
You verify that the data is accurate.
You need to ensure that the dimension processes successfully.
What should you do?
A. Remove the duplicate data from the DimGeography table.
B. Delete the Geography hierarchy.
C. Relate the State-Province and Country attributes directly to the City attribute.
D. Remove the State-Province attribute.
Correct Answer: C