Data Architecture & Management Flashcards
7 cards from real CMA practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 7 Data Architecture & Management flashcards as text
What is the primary purpose of a data governance framework in enterprise architecture?
Answer: To ensure data quality, security, and proper stewardship across the organization
Data governance frameworks establish policies, roles, and processes to ensure data is accurate, secure, and managed as a strategic asset across the enterprise.
Which data modeling approach uses entities, attributes, and relationships to represent business concepts at the logical level?
Answer: Entity-Relationship (ER) modeling
Entity-Relationship (ER) modeling represents data using entities (business objects), their attributes, and the relationships between them, forming the foundation of relational database design.
In a data warehouse architecture, what distinguishes an Operational Data Store (ODS) from a data warehouse?
Answer: An ODS is updated in near real-time while a data warehouse contains historical snapshots
An ODS is designed for near real-time operational reporting with current data, while a data warehouse integrates historical data across subjects for analytical and strategic reporting.
What does the 'single source of truth' principle mean in enterprise data architecture?
Answer: Each data element has one authoritative source from which all other systems derive their data
The single source of truth principle designates one authoritative system of record for each data element, reducing inconsistencies and conflicting versions of data across enterprise systems.
Which of the following best describes Master Data Management (MDM)?
Answer: A discipline for ensuring a consistent, accurate view of key business entities across enterprise systems
MDM creates and maintains a single, consistent, accurate view of critical business entities such as customers, products, and employees across all enterprise systems.
In dimensional data modeling, what is the purpose of a Slowly Changing Dimension (SCD)?
Answer: To manage and track changes to dimension attributes over time in a data warehouse
Slowly Changing Dimensions define strategies (Type 1, 2, 3, etc.) for tracking changes to dimension attributes over time, preserving historical context appropriate to each business scenario.
What is a data lineage map used for in enterprise data architecture?
Answer: Tracking the origin, movement, and transformation of data as it flows across systems
Data lineage maps document where data originates, how it flows through systems, and what transformations it undergoes, supporting impact analysis, debugging, and regulatory compliance.