Hello TD Gurus/Enthusiasts,
Can you share some insight on this and why?
“Which two statements are true? (choose two)
A. Dimensional models are process oriented
B. Relational models are process oriented
C. Dimensional models are enterprise oriented
D. Relational models are enterprise oriented
E. Fact tables contain only detail data
F. 3NF tables contain aggregated data”
A & D are TRUE Statements
Dimensional models are process oriented --> Dimension models help in measuring fact in different dimesions which are process oriented.
Relational models are enterprise oriented --> Relational model has characteristics of adoptability, extensibility and flexbility and hence close to Enterprise