Microsoft
70-460 · Question #70
70-460 Question #70: Real Exam Question with Answer & Explanation
Sign in or unlock 70-460 to reveal the answer and full explanation for question #70. The question stem and answer options stay visible for context.
Question
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?
Exhibit
Options
- ADelete the Geography hierarchy.
- BRelate the State-Province and Country attributes directly to the City attribute.
- CRemove the duplicate data from the DimGeography table.
- DRemove the State-Province attribute.
Unlock 70-460 to see the answer
You've previewed enough free 70-460 questions. Unlock 70-460 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.