Forum Discussion
Role Playing dimensions with duplicated queries
Wouldn't this work? A. Yes? Does anyone know why the exam questions are so vague about the approach? I don't even know if I can score if it's so ambiguous.
Hello YoungLearning - Technically option A would be able to achieve the desired result, however it is not the best practice, which is why I think it is not the right answer. In general, duplicate (even copies by means of reference) Dim tables is a red flag and eludes to bloated/inefficient models and should be avoided. I agree that the correct answer to this question is no; I think the ambiguous part is that it does not specify (at least in what is seen above) that "Yes" should be chosen if the correct result can be obtained AND if it is done according to best practices.