MicroStrategy Developer Practice Questions - MicroStrategy Certified Developer (Strategy) Exam

A lookup table stores attribute element data and defines attribute keys; a relationship table establishes many-to-many relationships between attributes at different levels A lookup table is used for caching query results; a relationship table stores the actual fact data A lookup table is only used for time-series dimensions; a relationship table is used for all other dimensions A lookup table is stored in the application server; a relationship table is stored in the data warehouse