CMA Data Architecture & Management 2

Question 1

Which data integration pattern is most appropriate for synchronizing large volumes of data between enterprise systems on a scheduled basis?

Accepted Answer

Batch ETL (Extract, Transform, Load) processing

Answer

Event-driven streaming via a message broker

Answer

Synchronous REST API integration

Answer

Manual data reconciliation and file transfer

Question 2

What is the key architectural difference between a data lake and a data warehouse?

Accepted Answer

A data lake stores raw data in native format while a data warehouse stores processed, structured data

Answer

A data lake stores only structured data while a data warehouse stores unstructured data

Answer

A data lake enforces schema at load time while a data warehouse uses schema-on-read

Answer

A data lake is exclusively for real-time analytics while a data warehouse is batch-only

Question 3

What does the CAP theorem state about distributed data systems?

Accepted Answer

A distributed system cannot simultaneously guarantee Consistency, Availability, and Partition tolerance

Answer

Data Capacity, Access speed, and Performance are the three pillars of database design

Answer

Caching, APIs, and Processing are the three components of a modern data pipeline

Answer

Cloud, on-premises, and hybrid are the three viable deployment options for enterprise data

Question 4

What is the primary advantage of a data mesh architecture approach?

Accepted Answer

Enabling domain teams to own, manage, and serve their data as products

Answer

Centralizing all data processing under a single enterprise data engineering team

Answer

Replacing all existing data warehouses with a unified cloud data lake

Answer

Eliminating the need for enterprise-wide data governance policies

Question 5

Which integration approach best supports real-time data flow between microservices with loose coupling?

Accepted Answer

Event streaming using a message broker such as Apache Kafka

Answer

Nightly batch ETL jobs between service databases

Answer

Scheduled full-table database replication

Answer

Synchronous REST API calls with retry logic

Question 6

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

Accepted Answer

To provide a searchable inventory of data assets with metadata, lineage, and business context

Answer

To store encrypted backup copies of all enterprise databases

Answer

To enforce row-level data access controls across all source systems

Answer

To transform and cleanse data before loading it into the data warehouse

Question 7

In data architecture, what is 'data virtualization'?

Accepted Answer

Providing unified, real-time data access across multiple sources without physical data movement

Answer

Creating virtual machines dedicated to hosting database servers

Answer

Compressing data to reduce on-disk storage requirements

Answer

Replicating data to geographically distributed disaster recovery sites