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

An ODS integrates current operational data from multiple source systems to support short-term operational reporting and decision-making with near-real-time data.

Question 2

In data warehousing, what does ETL stand for?

Accepted Answer

Extract, Transform, Load

Answer

ETL (Extract, Transform, Load) is the process of extracting data from source systems, transforming it for quality and consistency, and loading it into the target data warehouse.

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 (Extract, Load, Transform) loads raw data into the target cloud data warehouse first, then leverages its massive parallel processing power to perform transformations in place.

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

Drill-down in OLAP allows users to navigate from aggregate summary data to increasingly detailed, granular levels of data (e.g., from year → quarter → month).

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 data mart is a subject-specific subset of a data warehouse (e.g., Sales, HR, Finance) designed to serve the reporting needs of a specific business unit or function.

CDP - Certified Data Professional Practice Test

CDP - Certified Data Professional Practice Test

CDP Data Warehousing and Business Intelligence