Question

Which of the following is/are strengths of dimensional modeling?

A. Standard design approaches have been developed
B. Predictable, standard framework
C. Respond well to changes in user reporting needs
D. All of the listed options

Answer 1

This is actually a trick Multiple choice question. The correct answer for this is D, all of the listed options. This is because, the strengths of dimensional modelling consist of certain rules we need to follow, word-by-word in order to get the desired results. Hence, Standard Design Approaches, need to developed with a standard and a predictable framework on which to work. Along with working on the modeling, we need to response to any changes in user reporting needs as soon as possible, rather than leaving them for later.
Following all the steps ensures a smooth workflow with minimum problems