CDP Data Architecture and Modeling 3

Question 1

What distinguishes OLTP systems from OLAP systems in terms of design purpose?

Accepted Answer

OLTP is optimized for high-volume, short transactions; OLAP is optimized for complex analytical queries

Answer

OLTP systems are designed for high-volume, short-duration transactions (insert/update/delete), while OLAP systems are designed for complex, read-heavy analytical queries.

Question 2

What is a data catalog's primary function in a modern data architecture?

Accepted Answer

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

Answer

A data catalog acts as an organized inventory of data assets, providing metadata, lineage, and business context to help users discover and understand available data.

Question 3

In enterprise data architecture, what is a 'Data Domain'?

Accepted Answer

A logical grouping of related data assets under a common subject area or business function

Answer

A Data Domain is a logical grouping of related data (e.g., Customer, Product, Finance) organized around a common business subject area or function.

Question 4

Which architectural pattern separates compute from storage to allow independent scaling in cloud data platforms?

Accepted Answer

Decoupled Storage-Compute Architecture

Answer

Decoupled Storage-Compute Architecture allows storage (e.g., S3) and compute (e.g., query engines) to scale independently, reducing costs and improving flexibility.

Question 5

What is the purpose of a 'reference data' table in a database?

Accepted Answer

Provide a controlled set of valid values for data fields, such as country codes or status types

Answer

Reference data tables store stable, controlled sets of valid values (like country codes, currency codes, or status enumerations) used to ensure data consistency.

CDP - Certified Data Professional Practice Test

CDP - Certified Data Professional Practice Test

CDP Data Architecture and Modeling 3