Information Architecture & Strategy Flashcards
7 cards from real CDO practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 7 Information Architecture & Strategy flashcards as text
In Kimball dimensional modeling, what does the 'grain' of a fact table define?
Answer: Exactly what a single fact row represents
Declaring the grain, such as one row per order line, is the critical first step in designing a fact table.
A dimension that keeps full history by adding a new row with effective dates whenever an attribute changes is which slowly changing dimension type?
Answer: Type 2
SCD Type 2 adds versioned rows, whereas Type 1 overwrites values and Type 3 keeps limited prior values in extra columns.
What is the main purpose of an architecture review board (ARB) in a data strategy?
Answer: To ensure solutions align with target architecture, standards, and principles, and to manage exceptions
An ARB governs design decisions against agreed principles and standards, which reduces fragmentation and technical debt.
Which statement best captures the difference between a data strategy and a data architecture?
Answer: Strategy defines the why and what (goals, priorities, operating model), while architecture defines how data is structured, integrated, and delivered
The data strategy sets direction and value, and the architecture is the blueprint that carries it out.
An organization wants to query data across several source systems in real time without copying it into a central store. Which approach fits best?
Answer: Data virtualization
Data virtualization gives a unified logical view by querying sources in place, without physically moving the data.
Which characteristic is NOT typically required for a dataset to be treated as a 'data product' in a data mesh?
Answer: Stored in one centralized enterprise warehouse
Data products should be discoverable, addressable, trustworthy, self-describing, interoperable, and secure, and they do not have to be centralized.
When building a data architecture roadmap, why should a CDO do a capability-based gap analysis between the current and target states?
Answer: To find and prioritize the initiatives needed to close gaps, then sequence them by value and dependency
Gap analysis turns the target state into a sequenced, prioritized portfolio of work.
How this page was made: written with AI tools and published by Nathan Beja, founder of Practice Test Geeks, who is responsible for its content. We have not yet matched this exam's facts to an official source, so confirm fees, dates and rules with the exam body. Not reviewed by a subject-matter expert. Editorial policy