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 is for complex analytics; OLAP is for simple transactions

Answer

OLTP uses columnar storage; OLAP uses row-based storage

Answer

OLTP supports historical data; OLAP supports only current data

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

Store and process raw data at scale

Answer

Execute ETL jobs and data transformations

Answer

Manage database user permissions

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 database server hostname

Answer

A network partition for data storage

Answer

A type of data encryption algorithm

Question 4

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

Accepted Answer

Decoupled Storage-Compute Architecture

Answer

Shared-Nothing Architecture

Answer

Lambda Architecture

Answer

Federated Architecture

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

Store large binary files

Answer

Archive historical transaction data

Answer

Link two fact tables together

Question 6

In a logical data model, what is the difference from a physical data model?

Accepted Answer

Logical models define business entities and relationships without platform specifics; physical models include DBMS-specific implementation details

Answer

Logical models include hardware specifications; physical models do not

Answer

Logical models are used only by developers; physical models are for business users

Answer

Logical models always use star schemas