CMA Data Architecture & Management

Question 1

What is the primary purpose of a data governance framework in enterprise architecture?

Accepted Answer

To ensure data quality, security, and proper stewardship across the organization

Answer

To replace the need for a database administrator

Answer

To limit data access to senior management only

Answer

To automate all data processing workflows

Question 2

Which data modeling approach uses entities, attributes, and relationships to represent business concepts at the logical level?

Accepted Answer

Entity-Relationship (ER) modeling

Answer

Dimensional modeling

Answer

Object-oriented modeling

Answer

Star schema modeling

Question 3

In a data warehouse architecture, what distinguishes an Operational Data Store (ODS) from a data warehouse?

Accepted Answer

An ODS is updated in near real-time while a data warehouse contains historical snapshots

Answer

An ODS stores historical data while a data warehouse stores only current data

Answer

An ODS uses dimensional modeling while a data warehouse uses ER modeling

Answer

An ODS is read-only while a data warehouse supports write operations

Question 4

What does the 'single source of truth' principle mean in enterprise data architecture?

Accepted Answer

Each data element has one authoritative source from which all other systems derive their data

Answer

All data must be stored in a single monolithic database instance

Answer

Only one user can modify data at a time to prevent conflicts

Answer

All reports must use the same business intelligence visualization tool

Question 5

Which of the following best describes Master Data Management (MDM)?

Accepted Answer

A discipline for ensuring a consistent, accurate view of key business entities across enterprise systems

Answer

The process of backing up critical business data on a nightly schedule

Answer

A method for encrypting sensitive personally identifiable information at rest

Answer

A technique for compressing large datasets to reduce storage infrastructure costs

Question 6

In dimensional data modeling, what is the purpose of a Slowly Changing Dimension (SCD)?

Accepted Answer

To manage and track changes to dimension attributes over time in a data warehouse

Answer

To handle time-sensitive transactional data in OLTP systems

Answer

To improve query performance by horizontally partitioning large fact tables

Answer

To reduce the storage footprint of rarely accessed historical records

Question 7

What is a data lineage map used for in enterprise data architecture?

Accepted Answer

Tracking the origin, movement, and transformation of data as it flows across systems

Answer

Organizing data assets by business domain for catalog and discovery purposes

Answer

Mapping database indexes to query execution plans to improve performance

Answer

Assigning data ownership and stewardship roles to business users