CDP Data Warehousing and Business Intelligence

Question 1

What is the primary purpose of an Operational Data Store (ODS) in a data architecture?

Accepted Answer

Providing a near-real-time, integrated view of current operational data from multiple source systems

Answer

Long-term historical reporting

Answer

Storing raw unstructured data

Answer

Running batch ETL processes

Question 2

In data warehousing, what does ETL stand for?

Accepted Answer

Extract, Transform, Load

Answer

Execute, Transfer, Load

Answer

Extract, Test, Launch

Answer

Evaluate, Transfer, Link

Question 3

What distinguishes ELT from ETL in modern cloud data architectures?

Accepted Answer

ELT loads raw data into the target system first, then performs transformations using the target system's computing power

Answer

ELT does not require any data transformation

Answer

ELT is only used for unstructured data

Answer

ELT stands for Evaluate, Link, Transfer

Question 4

What is 'drill-down' in the context of OLAP and business intelligence?

Accepted Answer

Navigating from summary-level data to more detailed, granular data

Answer

Combining data from multiple data sources

Answer

Filtering data by a specific date range

Answer

Exporting data to a CSV file

Question 5

What is a data mart?

Accepted Answer

A small, subject-oriented subset of a data warehouse focused on a specific business area or department

Answer

A marketplace for buying and selling data assets

Answer

A type of real-time database

Answer

A tool for data visualization

Question 6

What does 'grain' mean in the context of a data warehouse fact table?

Accepted Answer

The level of detail that each row in the fact table represents

Answer

The number of rows in the fact table

Answer

The type of aggregation applied to measures

Answer

The number of dimensions linked to the fact table